The following query retrieves all RUNNING tasks, the current assignee and other task details.
select * from tb_task TSK
JOIN tb_assignment ASGN ON TSK.current_assignment_id = ASGN.id
JOIN tb_queue Q ON ASGN.queue_id =Q.id
JOIN EDCPRINCIPALUSERENTITY EDC ON Q.workflow_principal_id=EDC.refprincipalid
WHERE TSK.status = 3
You can filter the records if you know either Process Id or Task Id.
Thanks Nith. The query really help!
Can you also provide the query to retrieve RUNNING proceses, the current assignee and other details as well.
Thanks in advance,