[AgentFlow]工作已損毀導致代辦工作有誤

–先備份一下

SELECT * INTO TASK_20200623 FROM TASK

 

–查詢屬於已被刪除流程工作的 Task

SELECT TskID, ProID FROM Task WHERE

( (ProID NOT IN (SELECT ProID FROM Pro_GenInf ) AND ProID LIKE 'PRO%') OR

(ProID NOT IN (SELECT ProID FROM Iap_GenInf ) AND ProID LIKE 'IAP%')OR

(ProID NOT IN (SELECT SignID FROM Sign_GenInf ) AND ProID LIKE 'SGN%') )

AND State<>'complete'

AND State<>'dead'

 

–將這些工作狀態都改成 dead 待辦就不會出現警告(修改前請先備份)

UPDATE Task SET STATE = 'dead' WHERE

( (ProID NOT IN (SELECT ProID FROM Pro_GenInf ) AND ProID LIKE 'PRO%') OR

(ProID NOT IN (SELECT ProID FROM Iap_GenInf ) AND ProID LIKE 'IAP%')OR

(ProID NOT IN (SELECT SignID FROM Sign_GenInf ) AND ProID LIKE 'SGN%') )

AND State<>'complete'

AND State<>'dead'