Instantly share code, notes, and snippets.

Embed
What would you like to do?
-- Get Process Name by Process Instance ID
USE K2 -- Adjust your K2 DB name if necessarry
DECLARE @PInstID INT
DECLARE @ProcID INT
SET @PInstID=1 -- Specify your Process Instance ID Here
SET @ProcID = (SELECT ProcID FROM Server.ProcInst WHERE ID=@PInstID)
SELECT [Name] FROM Server.[ProcSet] WHERE ID = (SELECT ProcSetID FROM Server.[Proc] WHERE ID=@ProcID)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment