Symptoms
How to generate a report to view all the process and their status
Diagnoses
We don't advise to use the DB directly because lot of tables are impacted.
Resolution
You can find corresponding information on the smart objects of the following category (Accessible in the Smart Object Service Tester):
SmartObject ExplorerWorkflow ReportsWorkflow General
Mainly:Activity_Instance and Process_Instance
We already do some joins between these tables and work with this with ADO query. please Find attached file
ADO Query displaying all process instances with a correct manage of the delete one.txt
The query is not on the K2 Database but on the K2 Standard Smart Object: you can test it with the smart object service tester in the main button "ADO Query" or from "Tools/ADOQuery"
Note: You can create a SmartObject that return a list after ADO query with the necessary join.
To do it I advise to use: ADO Query Service Broker from the K2 community: http://community.k2.com/t5/K2-blackpearl/ADO-Query-Service-Broker/ba-p/62327
Note: you can find attached the same broker with a limitation of 17 columns returned (instead of 9 by the community one). Compiled in 4.6.11.
For instruction of the installation of the ADO query service type, you can found it on the pdf file of the original one:
http://community.k2.com/t5/K2-blackpearl/ADO-Query-Service-Broker/ba-p/62327
PS: I provided queries and ADO Query provider because I built them for another ticket linked to an issue of K2 standard reports, it's not the role of the K2 Support to provide custom query or custom service broker for free.
