turbot/jira

steampipe plugin install jirasteampipe plugin install jira

Table: jira_issue_type

Issue types distinguish different types of work in unique ways, and helps to identify, categorize, and report on the team’s work across the Jira site.

Examples

Basic info

select
id,
name,
description,
avatar_id
from
jira_issue_type;

List issue types for a specific project

select
id,
name,
description,
avatar_id,
scope
from
jira_issue_type
where
scope -> 'project' ->> 'id' = '10000';

List issue types associated with sub-task creation

select
id,
name,
description,
avatar_id,
subtask
from
jira_issue_type
where
subtask;

List issue types with hierarchy level 0 (Base)

select
id,
name,
description,
avatar_id,
hierarchy_level
from
jira_issue_type
where
hierarchy_level = '0';

.inspect jira_issue_type

Issue types distinguish different types of work in unique ways, and help you identify, categorize, and report on your team’s work across your Jira site.

NameTypeDescription
avatar_idbigintThe ID of the issue type's avatar.
descriptiontextThe description of the issue type.
entity_idbigintUnique ID for next-gen projects.
hierarchy_levelbigintHierarchy level of the issue type.
icon_urltextThe URL of the issue type's avatar.
idtextThe ID of the issue type.
nametextThe name of the issue type.
scopejsonbDetails of the next-gen projects the issue type is available in.
selftextThe URL of the issue type details.
subtaskbooleanWhether this issue type is used to create subtasks.
titletextTitle of the resource.