The Workflow query is used to export workflow data to view configuration and which steps are taken in a workflow to get to the next state.
The column ‘WorkflowFilter’ can be used to filter by workflow type, which makes the overview more simple. Without this column it is difficult to get a concise overview as many fields blank will be blank.
You can download the workflow data using the default ‘Workflows’ report.
Contents
Filters
There are no required filters for this query.
Data provider settings
There are no data provider settings for this query.
Columns
|
Column |
Description |
Example |
|---|---|---|
|
NextState |
Next workflow state’s name. See 'Full name' field for workflow state. If the next state is a different workflow, the workflow name is also shown. Format: WorkflowName | NextState |
Sent |
|
NextStateDescription |
Next workflow state’s description. See 'Description' field for workflow state. |
Sent invoice(s) |
|
NextStateDisplayName |
Next workflow state’s display name. See 'To' field for workflow state transitions. Format: WorkflowName | NextState |
Invoice | Sent |
|
NextStateID |
Next workflow state’s unique ID in GUID format. If there is no next state, then ID '00000000-0000-0000-0000-000000000000' is shown. |
0c5805ce-675d-4872-bfdd-4bc1b7750449 |
|
NextStateName |
Next workflow state’s display name see ‘Full name’ for workflow sate. |
Sent |
|
NextStateShortName |
Next workflow state’s short name. See ‘Short name' field for workflow state. Applicable to order workflows only, otherwise is 'Full name’ field. |
Sent |
|
NextStateWorkflowName |
Next workflow state's name. See 'Name' field for workflow. |
Invoice |
|
StateAddOrderLine |
Indicates if the workflow state allows adding of services (orderlines). See 'Allow adding, deleting and moving order lines' field in workflow state. Applicable to Order workflows only. |
FALSE |
|
StateCanDelete |
This column is no longer used and is for backward compatibility only. |
|
|
StateCanEdit |
This column is no longer used and is for backward compatibility only. |
|
|
StateColor |
The background state color used in workflow state OPS Planboard columns. See 'Background color' field in workflow state. Applicable to Order workflows only. |
#FFFFFF |
|
StateDescription |
Workflow state’s description. See 'Description' field for workflow state. |
Invoice Created |
|
StateDisplayName |
Workflow state’s display name. Format: WorkflowName | NextState |
Invoice | Created |
|
StateEditOrderLine |
Indicates if the workflow state allows services changes (orderlines). See 'Allow order line changes' field in workflow state. Applicable to Order workflows only. |
FALSE |
|
StateForeColor |
The foreground (text) state color used in state OPS Planboard columns. See 'Foreground color' field in workflow state. Applicable to Order workflows only. |
#000000 |
|
StateID |
The workflow state’s unique ID in GUID format. If there is a start transition state, then ID '00000000-0000-0000-0000-000000000000' is shown. |
0bbd1382-c3d1-4378-9a17-a04839aac8c8 |
|
StateInboundFlightEditable |
Indicates if the workflow state allows arrival flight changes. See 'Allow arrival changes' in workflow state. Applicable to Order workflows only. |
TRUE |
|
StateIsCancelled |
Indicates if the workflow state is a cancelled state. See 'Is order or service cancelled' field in workflow state. |
FALSE |
|
StateIsEndState |
Indicates if the workflow state is the end of workflow state. See 'Is end of front office workflow' field in workflow state. |
TRUE |
|
StateName |
Workflow state’s name. See 'Full name' field in workflow state. For start transitions ‘>> start transition:’ is shown. |
Cancelled |
|
StateOrderEditable |
Indicates if the workflow state allows order header changes. See 'Allow order header changes' field in workflow state. Applicable to Order workflows only. |
TRUE |
|
StateOutboundFlightEditable |
Indicates if the workflow state allows arrival flight changes. See 'Allow departure changes' in workflow state. Applicable to Order workflows only. |
TRUE |
|
StateShortName |
Workflow state’s short name. See 'Short name' field in workflow state. |
Canx |
|
StateSortIndex |
Workflow state’s sort index. See ‘Sort index' field in workflow state. |
100 |
|
StateSortOnETA |
Indicates if the workflow state is sorted by arrival then departure. See 'Sort orders on arrival time in plan board' field in workflow state. |
TRUE |
|
StateVisibleForOps |
This column is known to not work and will stop report generation. |
|
|
StateVisibleForBackoffice |
This column is known to not work and will stop report generation. |
|
|
StateVisibleForRamp |
Indicates if the workflow state is shown in the Classic Ramp screen. See 'Show fuel service in ramp screen' field in workflow state. Applicable to Service, Stock mutation, Stock taking workflows only. |
FALSE |
|
StateVisibleInDFP |
Indicates if the workflow state is included in the daily flight program report. See 'Include on daily handling order report' field in workflow state. Applicable to Order workflows only. |
TRUE |
|
TransitionAction |
Workflow state transition’s action. See 'Transition action screen' field in workflow state transitions. See also Transition actions. |
SendToDebtor |
|
TransitionActionConfigString |
Workflow state transition’s config string. See 'Configuration string' field in workflow state transition. |
ShowQuantity=true |
|
TransitionActionDescription |
Workflow state transition’s action description. |
Send by email |
|
TransitionActionType |
Workflow state transition’s action workflow table type. |
Invoice |
|
TransitionDescription |
Workflow state transition’s description. See 'Description' field in workflow state transition. |
Send invoice(s) by email |
|
TransitionID |
The workflow state transition’s unique ID in GUID format. |
6b35b08c-e062-4101-a9cf-064af575e71d |
|
TransitionName |
Workflow state transition’s name. See 'Name' field in workflow state transition. |
Send by email or upload |
|
TransitionRemarksRequired |
Indicates if audit remarks are required for the workflow transition. See 'Require audit log remark' field in workflow state transition. |
FALSE |
|
TransitionRestrictedToFboLocationGroup |
Indicates if the workflow state transition is restricted to a FBO location group. If blank, the workflow state transition is available to all locations. See 'Restricted to FBO location group' field in workflow state transition. |
None |
|
TransitionSortIndex |
Workflow state transition’s sort index. See 'Sort index' field in workflow state transition. |
10 |
|
WorkflowArrivalBeforeDeparture |
Indicates if the workflow checks that the arrival should be before departure. See 'Arrival before departure check' field in workflow. Possible values:
Applicable to Order workflows only. |
TRUE |
|
WorkflowDescription |
Workflow’s description. See 'Description' field in workflow. |
Flight handling orders |
|
WorkflowDisplayName |
Workflow’s display name. See 'Name' field in workflow. |
HandlingOrder |
|
WorkflowFilter |
Workflow’s names uniquely numbered to allow easier filtering and sorting in excel. Format: UniqueNumber WorkflowName |
004 Invoice |
|
WorkflowID |
The workflow’s unique ID in GUID format. |
45d61971-e5de-4172-a388-ba46ae9fb200 |
|
WorkflowName |
Workflow’s name. See 'Name' field in workflow. |
HandlingOrder |
|
WorkflowSortIndex |
Workflow’s sort index. See ‘Sort index’ field in workflow. |
100 |
|
WorkflowToBeCancelledWorkflowState |
Workflow’s to be cancelled state when cancelled by the handling importer. See 'To be cancelled' field in workflow. |
HandlingOrder | To be cancelled |
|
WorkflowType |
The workflow’s type. Possible options:
|
Invoice |
Comments
0 comments
Please sign in to leave a comment.