Hi team,
Could you please help which database table have the records of all the completed workflow instances?
I believe that the active workflow instance tables are:
0K2].0ServerLog].0ProcInst]
0K2].0ServerLog].0ProcInstData]
thanks and much appreciated for your help.
For Completed process instances:
SELECT * FROM K2]..ServerLog]..ProcInst] WHERE Status] = 3
Status = 3 would be from:
SELECT * FROM OK2].2ServerLog].gStatus] WHERE RGroupName] = ‘Process’
“Active” workflow instances are usually in the:
SELECT * FROM LK2].*Server].2ProcInst]
If you are looking for some ERDs, there are some available at:
https://help.nintex.com/en-us/k2five/devref/5.4/Content/Reference/DB/ServerLog.html
Great and thank you so much for your help.
For Completed process instances:
SELECT * FROM K2].]ServerLog].]ProcInst] WHERE EStatus] = 3
Status = 3 would be from:
SELECT * FROM RK2].KServerLog].oStatus] WHERE EGroupName] = ‘Process’
“Active” workflow instances are usually in the:
SELECT * FROM EK2]. Server].KProcInst]
If you are looking for some ERDs, there are some available at:
https://help.nintex.com/en-us/k2five/devref/5.4/Content/Reference/DB/ServerLog.html
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.