Workflows
Manages the available workflows in Jira, which define the sequence of statuses and transitions for issues.
Table-Specific Information
SELECT
The add-in uses the Jira API to process filters based on the Name, IsActive, and Query columns. The add-in processes all other filters client-side.For example, the following queries are processed server-side:
SELECT * FROM Workflows WHERE Name = 'abc';
SELECT * FROM Workflows WHERE Name IN ('abc', 'def', 'ghi');
SELECT * FROM Workflows WHERE IsActive = true AND Query = 'flow';
INSERT
The Scope, Statuses, and Workflows columns accept aggregate values and are only used for inserting into and updating Workflows.INSERT INTO Workflows(Scope, Statuses, Workflows) VALUES ('{"type":"GLOBAL"}', '[{"description":"","name":"To Do #2","statusCategory":"TODO","statusReference":"f0b24de5-25e7-4fab-ab94-63d81db6c0c0"}]', '[{"description":"","name":"Software workflow 1","startPointLayout":{"x":-100.00030899047852,"y":-153.00020599365235},"statuses":[{"layout":{"x":114.99993896484375,"y":-16},"properties":{},"statusReference":"f0b24de5-25e7-4fab-ab94-63d81db6c0c0"}],"transitions":[{"actions":[],"description":"","from":[],"id":"1","name":"Create","properties":{},"to":{"statusReference":"f0b24de5-25e7-4fab-ab94-63d81db6c0c0"},"triggers":[],"type":"INITIAL","validators":[]}]}]');
NOTE: This statement is supported only for Jira Cloud instances.
UPDATE
Update a workflow by specifying the Id and the columns to update. The Description and CanEdit columns can be updated directly. The Scope, Statuses, and Workflows aggregate columns can also be used to update the workflow configuration.UPDATE Workflows SET Description = 'Updated workflow description' WHERE Id = 'e07175e4-f1c0-482f-a02c-50e966985eb8';
NOTE: This statement is supported only for Jira Cloud instances.
DELETE
Delete a workflow by specifying the Id.DELETE FROM Workflows WHERE Id = 'e07175e4-f1c0-482f-a02c-50e966985eb8';
NOTE: This statement is supported only for Jira Cloud instances.
Columns
| Name | Type | ReadOnly | References | SupportedOperators | Platform | Description |
| Id | String | False | Cloud |
The unique identifier of the workflow within Jira. This ID is used internally and in API operations to reference the workflow. | ||
| Name | String | False | =,LIKE | Common |
The name assigned to the workflow, which typically reflects the process or team it supports (for example, 'Software Development Workflow'). | |
| Description | String | False | Common |
A user-defined explanation of what the workflow represents or how it should be used. Helpful for distinguishing between similar workflows. | ||
| Created | String | True | Cloud |
The timestamp indicating when the workflow was initially created. | ||
| Updated | String | True | Common |
The date when the workflow was last modified. On the Server platform, this value is returned as a human-readable string (for example, '20 minutes ago' or '10/Oct/25 9:53 AM'). On the Cloud platform, this value is returned as a standard date string. | ||
| UpdatedBy | String | True | Server |
The display name of the user who most recently updated the workflow. Useful for auditing purposes to identify who last made changes to the workflow configuration or metadata. | ||
| IsDefault | Boolean | False | Server |
Indicates whether the workflow is currently designated as the default workflow for its associated issue type or project. | ||
| Steps | Integer | True | Server |
The total number of steps defined in the workflow. Each step represents a status that an issue can occupy, and transitions between steps represent actions that move issues through the process. | ||
| CanEdit | Boolean | False | Cloud |
If the value is 'true', the workflow can be edited. This can be restricted based on permissions or if the workflow is active. | ||
| Version | String | False | Cloud |
A JavaScript Object Notation (JSON) object containing the version of the workflow, used for optimistic locking during updates. This field is required when submitting workflow updates. | ||
| Statuses | String | False | Cloud |
A JavaScript Object Notation (JSON) array of statuses associated with the workflow. This value is returned in SELECT results. On INSERT, it specifies the statuses to include in the new workflow. On UPDATE, it specifies the top-level statuses submitted alongside the workflow update. | ||
| Scope | String | False | = | Cloud |
A JavaScript Object Notation (JSON) object defining the scope of the workflow, such as whether it is global or limited to specific projects. This value is returned in SELECT results and can be set on INSERT. The update endpoint does not accept a new scope. Accepted filter values are GLOBAL and PROJECT. | |
| Transitions | String | False | Cloud |
A JavaScript Object Notation (JSON) array describing the transitions defined in the workflow. Each entry specifies the source status, target status, and conditions that govern the transition. This value is returned in SELECT results and is required when submitting workflow updates. |
Pseudocolumns
Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.
| Name | Type | Description |
| IsActive | Boolean |
If the value is 'true', the workflow is currently in use by one or more projects. Active workflows can be subject to restrictions for modification or deletion. |
| Workflows | String |
A JSON object containing the full workflow configuration. Used for bulk creation or update of workflows and not returned in SELECT queries. |