IssueTypes

Query the available Issue Types in Jira.

Select

The add-in uses the Jira API to process some of the filters.

The add-in processes other filters within the add-in.

SELECT * FROM IssueTypes WHERE Id = 3

Name is required to insert. The following query creates a new issue type:

INSERT INTO IssueTypes (Name, Description, Subtask) VALUES ('Issue type name 3', 'test description', false)

You can update by specifying the issue type Id:

UPDATE IssueTypes SET Name = 'Updated Name 3', Description = 'Updated description' WHERE Id = 10306

Delete an issue type by specifying the issue type Id:

DELETE FROM IssueTypes WHERE Id = 10306


Name	Type	ReadOnly	References	SupportedOperators	Platform	Description
Id [KEY]	String	True		=	Common	The Id of the issue type.
Name	String	False			Common	The name of the issue type.
Description	String	False			Common	The description of the issue type.
Subtask	Boolean	False			Common	The subtask of the issue type. Not applicable for update.
IconUrl	String	True			Common	The icon URL of the issue type.