Is it possible to write reports or queries against worklist items in Blackpearl (ex. Give me all worklist items for DENALLIX
on where Process in ('Gl Coding','Invoice Reconcilliation'))?
I cannot find a way either through the report designer or through the ado.net provider (i.e. SELECT * from Process_Instance,Activity_Instance,Activity_Instance_Destination where ...). The Desintation column on the Activity_Instance_Destination table seems to be K2Server until the activity is completed or acted on which is not what I need (i.e. worklist or items user could be working on but isn't).
I saw the GetWorklistItems call in the Mng and Workflow.Management apis but the filtering isn't flexible enough (i.e. I need to specifiy multiple process names, etc.). I was hoping there was a smartobject called User_Worklist (or whatever) that I could just write a query against like the other process and activity tables.
Thanks,
Jim Partin
Bluethread Technologies Inc.