Does anyone have the SQL used to populate the worklist shown in K2 Service Mgr?
We want to build some reports based on this data. Can someone provide a SQL statement to return the data in tje Worklist, or identifiy the K2Log tables and the foreign key relationships? Thanks much!!!
+6
You can run a SQL trace while the worklist loads and that way you should see the exact SQL that is being run on the server.
+1
You can use the kUserWorklist procedure on K2 database to get the worklist item of the specific user.
Regards,
Zahid
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.