report to get data of all the instances

  • 14 August 2021
  • 4 replies
  • 31 views

Hi,

Is there any out of box report, which could give the data of all the instances of a particular report, with all the data field values? In short, I need the data audit log of the instances in one report. I am not looking for just the process instances, i need the data audit for every instance in a report. As of now, i am clicking on the data audit by going to each instance manually.

Thanks,
Pradeep


4 replies

Userlevel 2
Badge +10

Hi pnelli,


 


Have you tried the the Process Data SmartObject?


Hi Khanh,
Thanks for your response.
How would i join Process Data, Process Data Audit and Activity Data Audit in one single report.

Thanks,
Pradeep

Im not sure if this is something that may help, but you can try it:


If you are using smartbox or sql, then you just need to find where all that data is stored and create a stored proc (sql) or a composite smartobject (smartbox) and add left joins to them, therefore you can create a list and generate your reports from that.


 

Hi Prineel, K2 stores data in multiple tables and its difficult to find the table names.

Reply