Cambiar estado de un tramite (CPIC) a completado

PHOTO EMBED

Mon Apr 25 2022 18:26:33 GMT+0000 (UTC)

Saved by @kevintoranzo #sql

select id from workflowexecution where subject like '%OZLO-0907%';

update workflowexecution set state = 1, enddate = CURRENT_TIMESTAMP where id = 34168;

update workflowdefinitionexecution set state = 1, enddate = CURRENT_TIMESTAMP where workflowexecution_id = (select id from workflowexecution where id = 34168);

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