Skip to main content

Where can I find the database k2 stores for the workflow general smart objects the follwing two in the K2 sql server database.

 

- Actiity instnce destination smart object

- Process instance smart object

 

the smart objects are found under management --> Catagories -->Workflow reports -->Workflow generel

 

please find from the attachment the list of smart objects ,,,

 


14360i4B9E81777B46C049.jpg

Good day B_Abdu,


To find the specific tables in the K2 database for these smart-objects is difficult because these smart-objects are made up of multiple tables and columns across the K2 database which makes up these smart objects for example by querying this table by selecting top 1000 rows "Serverlog.ActInstDest" against your K2 database it will give you partial data of what makes the "Activity instance destination" smart-object on its own furthermore if you would query the "Server.ProcInst" table you will get the results that make up the "Process instance smart object". 


 


Kind regards,


Dumisani 





Hi B_Abdu


 


See the following screenshots below:


 



 


 



 


 


 


Regards


Elvis


Reply