Failed to Find Workflow AX 2012
Select a.RECID
from
SYSWORKFLOWMESSAGETABLE a
Where a.ROOTCORRELATIONID not
in
(Select b.ROOTCORRELATIONID
from SYSWORKFLOWTABLE b)
and a.MESSAGELIFECYCLESTATE =
1
SELECT * FROM
SYSWORKFLOWMESSAGETABLE AS A
WHERE A.RECID = 5650958646
Update SYSWORKFLOWMESSAGETABLE Set MESSAGELIFECYCLESTATE = 2 where RECID =5650958646
0 comments:
Post a Comment