Thursday, 10 February 2022

how to stop all instances of a workflow in bulk

How to stop bulk workflow like all PO workflow's etc........


UPDATE MAXIMO.WFINSTANCE SET ACTIVE = 0
WHERE OWNERTABLE = 'PO' and active=1

UPDATE MAXIMO.WFASSIGNMENT SET ASSIGNSTATUS = 'INACTIVE'
WHERE OWNERTABLE = 'PO'  and ASSIGNSTATUS = 'INACTIVE'
 
UPDATE MAXIMO.WFCALLSTACK SET ACTIVE = 0
WHERE ACTIVE=1 AND WFID IN (SELECT WFID FROM  MAXIMO.WFINSTANCE WHERE ACTIVE = 1
AND OWNERTABLE = 'PO') AND PROCESSNAME LIKE '%PO%'

another way is escalation using oob action class (recommended way) check IBM notes...

No comments:

Post a Comment