WorkflowSchemes

Handles the configuration of workflow schemes that assign workflows to issue types across projects.

Table-Specific Information

SELECT

The add-in uses the Jira API to process filters based on the Id column. The add-in processes all other filters client-side.

For example, the following queries are processed server-side:

SELECT * FROM WorkflowSchemes WHERE Id = 10400;

INSERT

Insert a workflow scheme by specifying the Name column.

INSERT INTO WorkflowSchemes (Name, Description, DefaultWorkflow, IssueTypeMappingsAggregate) VALUES('Jira Service Management IT Support Workflow', 'Incident Management workflow for Jira Service Management.', 'jira', '{"10201": "jira"}');

UPDATE

Update a workflow scheme by specifying the Id and the columns to update.

UPDATE WorkflowSchemes SET Name = 'Jira Updated Service Management IT Support Workflow', Description = 'Updated incident Management workflow for Jira Service Management.' WHERE Id = 11526;

DELETE

Delete a workflow scheme by specifying the Id.

DELETE FROM WorkflowSchemes WHERE Id = 11526;

Columns


Name	Type	ReadOnly	References	SupportedOperators	Description
Id [KEY]	Integer	True		=	The unique identifier of the workflow scheme. This ID is used to manage and reference the scheme in Jira operations.
Name	String	False			The user-defined name of the workflow scheme. Workflow schemes define how issues transition through workflows based on their issue types.
Description	String	False			An optional description that explains the purpose or usage of the workflow scheme. Useful for distinguishing between multiple schemes.
IssueTypeMappingsAggregate	String	False			A JavaScript Object Notation (JSON)-style aggregate listing mappings between issue types and workflows. Each mapping pairs an issue type ID with the name of its assigned workflow.
DefaultWorkflow	String	False			The name of the workflow used for issue types not explicitly mapped in the scheme. Acts as a fallback when no direct mapping is available.
Self	String	True			A REST API URL pointing to the workflow scheme resource. Useful for retrieving or updating the scheme programmatically.