What Process Definitions Have Been Run Against A Record?

Searching for all of the Process Definitions that have run against a specific record can be difficult in the Admin > Process Management utility, but, fear not because there is a way you can do this with an SQL query. This query can also be run as a Custom Query In Advanced Reports.

Here is the query template: 

SELECT pmse_inbox.cas_id AS CAS_ID,
pmse_inbox.date_entered AS Date_Entered,
pmse_inbox.pro_id AS Pro_ID,
pmse_bpmn_process.name AS Process_Name,
pmse_bpmn_process.prj_id AS Process_Record_ID
FROM pmse_bpm_flow
JOIN pmse_inbox ON pmse_bpm_flow.cas_id = pmse_inbox.cas_id
JOIN pmse_bpmn_process ON pmse_bpmn_process.id = pmse_inbox.pro_id
WHERE pmse_bpm_flow.cas_sugar_object_id = '[* RECORD ID *]'
GROUP BY pmse_inbox.cas_id, pmse_inbox.pro_id
ORDER BY pmse_inbox.cas_id ASC;

Replace [* RECORD ID *] with the record’s id field. 

The output looks has these columns:

CAS_ID: This is the “Process Number” in the Process Management utility.

Date_Entered: This is the “Date Created” in the Process Management utility.

Pro_ID: This is the pro_id to which the internal way the Process Definition is referred.

Process_Name: This is the Process Definition that ran.

Process_Record_ID: This is the ID of the Process Definition that ran. You can use this in a URL to find the Process Definition directly like this:

[* Your Instance Address *]/#pmse_Project/[* Process_Record_ID *]