K2 Worklist - Query

  • 30 October 2017
  • 1 reply
  • 34 views

Badge +5

We are wanting to gather all approval data from our applications (K2 and other apps)  via sql scripts to publish so that all users are able to get to this to see outstanding approvals.

 

Does anyone have the script for this handy?


1 reply

Badge +7

No script but there is a  way to build a view that shows this data

 

Use this smart onbject: Worflow reportsworkflow generalActivity Instance destination

 

Make sure and create a parameter for Folio and filter this by folio or you will be pulling wokflow information for every workflow ever. If your folios are not unique you can filter by Process Intance ID.

 

If you want you can out this on a form (or on your main form) build a dashboard with a link to this and then your users can check on the status of there workflow.

 

I hope this helps, excuse any typos

 

 

Reply