Skip to main content
Nintex Community Menu Bar
Question

Custom Worklist using Store Procedure

  • November 18, 2025
  • 1 reply
  • 17 views

Forum|alt.badge.img+1

Hi Team,

Is there any existing K2 stored procedure that we can use to create our own custom worklist?
The issue I am facing is that when a user sets Out of Office (OOF), I am unable to display the corresponding requests to the person to whom the tasks have been delegated.

Could you please let me know which table stores the OOF configuration, or advise on the logic required to retrieve these delegated requests?

1 reply

ScottCaseIT
Forum|alt.badge.img+1
  • Novice
  • December 8, 2025

I don’t recommend using a stored procedure. Going against K2 delivered database artifacts will put you at risk of a breaking change if K2 makes a change interally.

The recommended path is you use the ODatav4 endpoint and expose one of K2’s out of the box SmartObjects that will give you access to Worklist item information, OR if this is a .NET application (4.x), you can use the SmartObject.Client API.

The short answer, go through a SmartObject to get worklist information outside of K2. It is the recommended method, and you will be future proofed.