+4
Greetings-
Is there a query that can be run to return all the available worklist items and destination users associated to those items? We are looking to create a report to show who has the most outstanding worklist items by user.
I would rather not use the K2Mgr API but it might be my only choice.
Mike Trouard
+5
I had the same problem. To solve it i run this query in a sql reporting services report
SELECT _procInst.FOLIO,_procInst.Originator,_Worklist.Destination,_worklist.StartDate FROM [K2ServerLog].[dbo].[_Worklist]
LEFT JOIN _procInst ON procInstID = _procInst.ID
ORDER BY _Worklist.startDate
+2
Any idea how to get the specific user with the worklist item open if the user destination is a role ?!!
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.