Table: jira_project - Query Jira Projects using SQL

Jira is a popular project management tool used by software development teams to plan, track, and release software. It offers a range of features including bug tracking, issue tracking, and project management functionalities. Jira Projects are the primary containers in Jira where issues are created and tracked.

Table Usage Guide

The jira_project table provides insights into Projects within Jira. As a Project Manager or a Scrum Master, you can explore project-specific details through this table, including project key, project type, project lead, and project category. Use it to uncover information about projects, such as the project's status, the lead responsible for the project, and the category the project belongs to.

Examples

Basic info

Explore the different projects within your Jira environment, gaining insights into key aspects like the project's name, ID, key, lead display name, category, and description. This can be useful for understanding the scope and management of your projects.

select
  name,
  id,
  key,
  lead_display_name,
  project_category,
  description
from
  jira_project;

select
  name,
  id,
  key,
  lead_display_name,
  project_category,
  description
from
  jira_project;

List all issues in a project

Explore the status and details of all issues within a specific project. This can be useful for project management, allowing you to assess the workload and track the progress of tasks.

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

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

Schema for jira_project

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
component_ids	jsonb		List of the components contained in the project.
description	text		A brief description of the project.
email	text		An email address associated with the project.
id	text	=	The ID of the project.
issue_types	jsonb		List of the issue types available in the project.
key	text	=	The key of the project.
lead_account_id	text		The user account id of the project lead.
lead_display_name	text		The user display name of the project lead.
login_id	text	=, !=, ~~, ~~, !~~, !~~	The unique identifier of the user login.
name	text		The name of the project.
project_category	jsonb		The category the project belongs to.
project_type_key	text	=	The project type of the project. Valid values are software, service_desk and business.
properties	jsonb		This resource represents project properties, which provide for storing custom data against a project.
self	text		The URL of the project details.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
title	text		Title of the resource.
url	text		A link to information about this project, such as project documentation.

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_project