Skip to main content
Nintex Community Menu Bar

SQL Query or K2 Procedure that will List the User and Actions for an Activity/Event

  • May 5, 2017
  • 1 reply
  • 11 views

Forum|alt.badge.img

For a given Process Instance, is there a query or an out of the box K2 Procedure that will return the Action information for a given Process, Activity, or Event Instance?

 

I've tried poking around a bit in the tables and looking through the list of Stored Procs but nothing jumps out at me.

 

Any clues?

 

Thank you.

1 reply

  • May 12, 2017

Hi, You can use the standard K2 smartobjects available to list all users/actions for an activty/event.

 

open the smartobject tester and expand "Workflow Reporting" and create a smartobject from the object that you want. if you're using 4.7 you can use the System smartobjects which includes a smartobject to list all events "Event" for a given process, or "Event Action" to list out available actions for a given event in a process..

 

you can find those smartobjects under System -> Management ->Workflows ->Smartobjects