Expand my Community achievements bar.

SOLVED

How can I find all the workflows in execution in ACS

Avatar

Level 5

Dear all,

 

I want to find all the workflows in execution, but stop them through a query, could that be possible.

 

thanks for your help,

 

Kind regards,

celia 

1 Accepted Solution

Avatar

Correct answer by
Level 1

Hi Celia, 

I believe you can query the Workflow table in a query to find all workflows with Status(state) equal to Started:

 

Query for all running workflows (query activity):

suggo_0-1717116138905.png


You may want to filter out any important workflows to ensure they continue running. Then use an Update Data activity to set the Workflow status to Finished (the value for finished is 20), this will set all workflows to a finished state, and they will stop running. 

 

Update workflow state (update data activity):

suggo_2-1717116605198.png

 

suggo_1-1717116590432.png

 


Thanks

View solution in original post

1 Reply

Avatar

Correct answer by
Level 1

Hi Celia, 

I believe you can query the Workflow table in a query to find all workflows with Status(state) equal to Started:

 

Query for all running workflows (query activity):

suggo_0-1717116138905.png


You may want to filter out any important workflows to ensure they continue running. Then use an Update Data activity to set the Workflow status to Finished (the value for finished is 20), this will set all workflows to a finished state, and they will stop running. 

 

Update workflow state (update data activity):

suggo_2-1717116605198.png

 

suggo_1-1717116590432.png

 


Thanks