Выполняющиеся активити ContractApproveActivity, у которых нет выполняющихся задач, т.е. все пользователи выполнили.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 |
SELECT s.id, s.DOCUMENT_ID, s.STATE, s.STATE_TITLE, t.ID, t.ACTIVITY_NAME, t.MODIFIED, t.STATUS, CASE t.STATUS WHEN 0 THEN 'Running' WHEN 1 THEN 'CompleteYes' WHEN 2 THEN 'CompleteNo' WHEN 3 THEN 'CompleteOk' WHEN 4 THEN 'Timeout' END AS STATUS_TITLE, u.USER_ID, u.STATUS AS USER_STATUS, CASE u.STATUS WHEN 0 THEN 'Waiting' WHEN 1 THEN 'Yes' WHEN 2 THEN 'No' WHEN 3 THEN 'Ok' END AS USER_STATUS_TITLE, u.DATE_UPDATE, u.ORIGINAL_USER_ID FROM b_bp_workflow_state s INNER JOIN b_bp_task t ON s.ID = t.WORKFLOW_ID INNER JOIN b_bp_task_user u ON t.ID = u.task_ID WHERE 1=1 AND t.ACTIVITY = 'ContractApproveActivity' AND t.STATUS = 0 #AND s.DOCUMENT_ID = 194817 AND NOT EXISTS (SELECT 1 FROM b_bp_task_user u2 WHERE u2.TASK_ID = t.id AND u2.STATUS = 0) ORDER BY s.ID, t.ID ; |