steampipe plugin install jira

Table: jira_priority - Query Jira Priorities using SQL

Jira is a project management tool used for issue tracking, bug tracking, and agile project management. The priority of an issue in Jira signifies its importance in relation to other issues. It is an attribute that can be set by the user when creating or editing issues.

Table Usage Guide

The jira_priority table provides insights into the priority levels assigned to different issues within a Jira project. As a project manager or agile team member, explore priority-specific details through this table, including descriptions, icons, and associated metadata. Utilize it to uncover information about priorities, such as their relative importance, to help in effective issue management and resolution.

Examples

Basic info

Explore the priorities set in your Jira project management tool. This can help you understand how tasks are being prioritized, assisting in better project management and resource allocation.

select
name,
id,
description
from
jira_priority;
select
name,
id,
description
from
jira_priority;

List issues with high priority

Discover the segments that have been assigned high priority issues in order to prioritize your team's workflow and address critical tasks more efficiently.

select
id as issue_no,
description as issue_description,
assignee_display_name as assigned_to
from
jira_issue
where
priority = 'High';
select
id as issue_no,
description as issue_description,
assignee_display_name as assigned_to
from
jira_issue
where
priority = 'High';

Count of issues per priority

Determine the distribution of issues across different priority levels to better understand where the majority of concerns lie. This can help in prioritizing resources and efforts for issue resolution.

select
p.name as priority,
count(i.id) as issue_count
from
jira_priority as p
left join jira_issue as i on i.priority = p.name
group by
p.name;
select
p.name as priority,
count(i.id) as issue_count
from
jira_priority as p
left join jira_issue as i on i.priority = p.name
group by
p.name;

Schema for jira_priority

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
descriptiontextThe description of the issue priority.
icon_urltextThe URL of the icon for the issue priority.
idtext=The ID of the issue priority.
login_idtext=, !=, ~~, ~~*, !~~, !~~*The unique identifier of the user login.
nametextThe name of the issue priority.
selftextThe URL of the issue priority.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
status_colortextThe color used to indicate the issue priority.
titletextTitle of the resource.

Export

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- jira

You can pass the configuration to the command with the --config argument:

steampipe_export_jira --config '<your_config>' jira_priority