Traer todos los campos de un trámite

PHOTO EMBED

Mon Jul 04 2022 20:25:04 GMT+0000 (UTC)

Saved by @kevintoranzo #sql #mysql

select w2.id,w2.value, w.name from workflowstepfieldexecution w2
         inner join workflowstepfield w on w2.workflowstepfield_id = w.id
         where w.name like '%%' 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 '%002619%' limit 1)));
content_copyCOPY