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

Note: This table is available only in the Jira Cloud version.

Select

The add-in will use the Jira API to process filters that refer to Id while the rest of the filter is executed client side within the add-in. The Jira APIs support filters using the equals (=) operator with Id.

For example, the below queries are processed server side.

Retrieve all the available workflow schemes:

SELECT * FROM WorkflowSchemes

Retrieve a specific workflow scheme by Id:

SELECT * FROM WorkflowSchemes WHERE Id = 10400

Insert

Name is required to insert. The following query creates a new workflow scheme:

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

You can update by specifying the workflow scheme Id:

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 workflow scheme Id:

DELETE WorkflowSchemes WHERE Id=11526

Columns