How-to-find all active flow on all inactive sc_req_item

[Kifrez]

I have inactive sc_request, sc_req_item, sc_task items with "active" flow in sc_req_item.

When I performed data fix on sc_task or sc_req_item, the flow triggers to the next step and made the record active again.

How could I find all flows on inactive records and then cancel them?

Thanks and much appreciated for your assistance.

Regards,

[Tony Chatfield1]

Hi, active flows can be found in the sys_flow_context table, but as there is no direct way to map 'inactive' tasks I think your easiest solution is to run a script on your task table with a query to identify the records you are targeting, you should then be able to loop through the results and cancel any flows for the records involved using flow api cancel() method.

https://developer.servicenow.com/dev.do#!/reference/api/utah/server/sn_fd-namespace/ScriptableFlowAP...