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 ,,,
Best answer by Dumisani
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".
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".
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.