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

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
description	text		The description of the issue priority.
icon_url	text		The URL of the icon for the issue priority.
id	text	=	The ID of the issue priority.
login_id	text	=, !=, ~~, ~~, !~~, !~~	The unique identifier of the user login.
name	text		The name of the issue priority.
self	text		The URL of the issue priority.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
status_color	text		The color used to indicate the issue priority.
title	text		Title 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