Actualizar campo matrícula en trámite

PHOTO EMBED

Mon Jul 04 2022 18:56:51 GMT+0000 (Coordinated Universal Time)

Saved by @kevintoranzo #sql #mysql

select w2.id,w2.value from workflowstepfieldexecution w2
         inner join workflowstepfield w on w2.workflowstepfield_id = w.id
         where w.name like '%MATRICULA%' AND
        workflowstepexecution_id in
        (select id from workflowstepexecution where workflowdefinitionexecution_id in  (select id from workflowdefinitionexecution
         where workflowexecution_id = (select id from workflowexecution where ordernumber like '%010598%' limit 1)));
content_copyCOPY