Cambiar estado de un tramite (CPIC) a anulado

PHOTO EMBED

Mon Apr 25 2022 18:35:28 GMT+0000 (Coordinated Universal Time)

Saved by @kevintoranzo #sql #mysql

select id from workflowexecution where subject like '%FOZG-069338%';

update workflowexecution set state = 4, cancellationDate=CURRENT_TIMESTAMP where id = 34470;

update workflowdefinitionexecution set state = 4 , cancellationDate=CURRENT_TIMESTAMP where workflowexecution_id = (select id from workflowexecution where id = 34470);

update workflowstepexecution set state = 4 where workflowdefinitionexecution_id in (select id from workflowdefinitionexecution where workflowexecution_id = (select id from workflowexecution where id = 34470));
content_copyCOPY