Skip to main content
Nintex Community Menu Bar
Solved

what are Activity instance destination and process instance smart objects database k2 stores

  • August 13, 2019
  • 2 replies
  • 177 views
  • Translate

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

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". 


 


Kind regards,


Dumisani 




View original
Did this topic help you find an answer to your question?

2 replies

  • 151 replies
  • Answer
  • August 13, 2019

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 




Translate

Forum|alt.badge.img+9

Hi B_Abdu


 


See the following screenshots below:


 



 


 



 


 


 


Regards


Elvis

Translate

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie Settings