Skip to content

Instantly share code, notes, and snippets.

@sween
Created October 2, 2019 19:18
Show Gist options
  • Save sween/4de61e617afb1df6909633142c6aec06 to your computer and use it in GitHub Desktop.
Save sween/4de61e617afb1df6909633142c6aec06 to your computer and use it in GitHub Desktop.
WorkflowPurge
s c=0
&sql(DECLARE tieCursor CURSOR FOR
SELECT
ID into :ID
FROM EnsLib_Workflow.TaskResponse)
&sql(OPEN tieCursor)
FOR
{
&sql(FETCH tieCursor)
Quit:SQLCODE
w !,ID
s c=$G(c)+1
s tTask=##class(EnsLib.Workflow.TaskResponse).%OpenId(ID)
set tSC = ##class(EnsLib.Workflow.Engine).CompleteTask(tTask)
}
&sql(CLOSE tieCursor)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment