Displays issue types configured for each project, including standard and custom issue types.

View-Specific Information

SELECT

The add-in applies filters server-side only when supported for the specific column and operator, as documented in the Columns section. All other filters are processed client-side.

Jira Cloud

The Jira Cloud API supports both the = and IN operators for the ProjectId column.

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

SELECT * FROM ProjectsIssueTypes WHERE ProjectId = 10000;
SELECT * FROM ProjectsIssueTypes WHERE ProjectId IN (10000, 10100, 10200);

Jira Data Center

The Jira Data Center API supports the = operator for the ProjectId column. For example, the following queries are processed server-side:

SELECT * FROM ProjectsIssueTypes WHERE ProjectId = 10000;

When connected to Jira Data Center, if ProjectId is not specified, the add-in automatically queries the Projects table to retrieve the ProjectId values. This may result in increased query times.

Columns

Name	Type	References	SupportedOperators	Platform	Description
Id [KEY]	String				A unique identifier for the issue type within Jira. This ID is used internally and in API requests to refer to the specific issue type.
ProjectId [KEY]	Int	Projects.Id	=,IN		The numeric ID of the project associated with this issue type. Each project has its own set of available issue types.
ProjectName	String	Projects.Name			The display name of the project that includes this issue type. Useful for identifying which project a particular issue type is configured under.
Name	String				The name of the issue type as seen in the Jira user interface. Examples include 'Bug', 'Task', 'Story', or any custom issue type.
Description	String				A short description that defines the purpose or use case for the issue type. This helps users understand when to use this issue type in the project.
Subtask	Boolean				Indicates whether the issue type is a subtask. Subtasks are used to break down parent issues into smaller, manageable units of work.
IconUrl	String				The URL of the icon representing the issue type in the Jira interface. This visual element helps users quickly identify different issue types.
AvatarId	String				The internal ID of the avatar (icon image) associated with the issue type. This is used for display in the Jira UI alongside issue names.