Skip to main content

I am new to K2 workflow and was wondering that what would be the quickest apprach for following ?

 

Find list of unique users who are associated with 'Completed' or 'Running' workflow instances from Ddate X till Y where these users could be either Approver -or- Reviwer -or- Initiator of the workflow.

 

I need this report to get a sence of active users in the application.

 

 

 

Assumming you are using BlackPearl and this data is hosted in a SQL Table. I would probably create the SQL as View. then create a RO SMO for that View to be presented in a Report. Some Grouping and Totals can be built within the Query.

 

Of course if the data is in Sharepoint, the approach might change a bit.

 

Hope this helps.

 

 


Thanks a lot for this direction. Yes, we are using K2 Black Pearl and data is in SQL. Can you suggest what tables i should be looking for to create the View ?

 

Thanks!


Reply