turbot/jira

steampipe plugin install jirasteampipe plugin install jira

Table: jira_issue

Issues are the building blocks of any Jira project. An issue could represent a story, a bug, a task, or another issue type in your project.

Examples

Basic info

select
key,
project_key,
created,
creator_display_name,
status,
summary
from
jira_issue;

List issues for a specific project

select
id,
key,
project_key,
created,
creator_display_name,
assignee_display_name,
status,
summary
from
jira_issue
where
project_key = 'TEST';

List all issues assigned to a specific user

select
id,
key,
summary,
project_key,
status,
assignee_display_name,
assignee_account_id
from
jira_issue
where
assignee_display_name = 'Lalit Bhardwaj';

List issues due in the next week

select
id,
key,
summary,
project_key,
status,
assignee_display_name,
assignee_account_id,
duedate
from
jira_issue
where
duedate > current_date
and duedate <= (current_date + interval '7' day);

Get issues belonging to a sprint

select
id,
key,
summary,
project_key,
status,
assignee_display_name,
assignee_account_id,
duedate
from
jira_issue
where
sprint_ids @> '2';

.inspect jira_issue

Issues help manage code, estimate workload, and keep track of team.

NameTypeDescription
assignee_account_idtextAccount Id the user/application that the issue is assigned to work.
assignee_display_nametextDisplay name the user/application that the issue is assigned to work.
componentsjsonbList of components associated with the issue.
createdtimestamp without time zoneTime when the issue was created.
creator_account_idtextAccount Id of the user/application that created the issue.
creator_display_nametextDisplay name of the user/application that created the issue.
descriptiontextDescription of the issue.
duedatetimestamp without time zoneTime by which the issue is expected to be completed.
epic_keytextThe key of the epic to which issue belongs.
fieldsjsonbJson object containing important subfields of the issue.
idtextThe ID of the issue.
keytextThe key of the issue.
labelsjsonbA list of labels applied to the issue.
prioritytextPriority assigned to the issue.
project_idtextA friendly key that identifies the project.
project_keytextA friendly key that identifies the project.
project_nametextName of the project to that issue belongs.
reporter_account_idtextAccount Id of the user/application issue is reported.
reporter_display_nametextDisplay name of the user/application issue is reported.
selftextThe URL of the issue details.
sprint_idsjsonbThe list of ids of the sprint to which issue belongs.
sprint_namesjsonbThe list of names of the sprint to which issue belongs.
statustextJson object containing important subfields info the issue.
summarytextDetails of the user/application that created the issue.
tagsjsonbA map of label names associated with this issue, in Steampipe standard format.
titletextTitle of the resource.
typetextThe name of the issue type.
updatedtimestamp without time zoneTime when the issue was last updated.