+1Hi 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:
[K2].[ServerLog].[ProcInst]
[K2].[ServerLog].[ProcInstData]
thanks and much appreciated for your help.
Best answer by TinTex
For Completed process instances:
SELECT * FROM [K2].[ServerLog].[ProcInst] WHERE [Status] = 3
Status = 3 would be from:
SELECT * FROM [K2].[ServerLog].[Status] WHERE [GroupName] = ‘Process’
“Active” workflow instances are usually in the:
SELECT * FROM [K2].[Server].[ProcInst]
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
For Completed process instances:
SELECT * FROM [K2].[ServerLog].[ProcInst] WHERE [Status] = 3
Status = 3 would be from:
SELECT * FROM [K2].[ServerLog].[Status] WHERE [GroupName] = ‘Process’
“Active” workflow instances are usually in the:
SELECT * FROM [K2].[Server].[ProcInst]
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
+1Great and thank you so much for your help.
For Completed process instances:
SELECT * FROM [K2].[ServerLog].[ProcInst] WHERE [Status] = 3
Status = 3 would be from:
SELECT * FROM [K2].[ServerLog].[Status] WHERE [GroupName] = ‘Process’
“Active” workflow instances are usually in the:
SELECT * FROM [K2].[Server].[ProcInst]
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.
