From Action Id to Workflow
When a workflow fails the error message typically includes the ID of the offending action, but little indication of where that action is.
This SQL statement uses the Action ID in the WHERE clause to return metadata about the workflow and the action, and a hint at where to find the action in the workflow.
The columns returned are:
| Column |
Notes |
| WorkflowId |
open the workflow editor directly with /Configuration/workflows/edit-workflow/[WorklowId] |
| WorkflowName |
|
| ZeroBasedOrderIndex |
The position of the action in the workflow. Note the first action after the start is 0 |
| ActionId |
(the action Id you supplied in the WHERE clause) |
| ActionType |
|
| Condition |
|
| Description |
The value of the Description field in the Action settings. Note "Title" does not appear to be stored as a column |
| ActionErrorMessage |
|
Add the following SQL statement into the SQL Console Query and Save Query for later use
SELECT
wf.Id AS WorkflowId
, wf.Name AS WorkflowName
, al.OrderIndex AS ZeroBasedOrderIndex
, al.ActionId
,act.ActionType
,act.Condition
,act.Description
,act.ActionErrorMessage
FROM dbo.PlantAnApp_Actions act
INNER JOIN dbo.PlantAnApp_Actions_ActionLists al
ON act.Id = al.ActionId
INNER JOIN dbo.PlantAnApp_Workflows_Workflows wf
ON al.ActionListId = wf.ActionListId
WHERE act.Id = [0] -- enter the ID of the Action returning the error
Example
