Confluence User •

11 Nov, 2020 •

confluenceUser •

•

confluenceUser •

Hi there,

The mismatch of "a.id= sact.ProcessId" is due to changes done in DX as a security enhancement. See here: Joget v6 to DX Upgrade Notes#ImportantNoteAboutJogetDXNewProcessRecordIDUsingUUID

The linkage of the record GUID with its associated Process ID can be found in the database table "wf_process_link".

Try out the fixed query below and see:

SELECT a.*, sact.Name AS activityName, GROUP_CONCAT(DISTINCT sass.ResourceId SEPARATOR ', ') AS assignee
FROM app_fd_j_expense_claim a
JOIN SHKActivities sact on a.id = (SELECT parentProcessId FROM wf_process_link WHERE processId = sact.ProcessId)
JOIN SHKActivityStates ssta ON ssta.oid = sact.State
INNER JOIN SHKAssignmentsTable sass ON sact.Id = sass.ActivityId
WHERE ssta.KeyValue = 'open.not_running.not_started'
GROUP BY a.id

1

CSV | Excel | XML | PDF