steampipe plugin install jira

Table: jira_workflow - Query Jira Workflows using SQL

Jira Workflows is a feature within Atlassian's Jira software that enables teams to manage and track the lifecycle of tasks and issues. It provides a visual representation of the process an issue goes through from creation to completion, allowing teams to customize and control how their work flows. Jira Workflows helps in determining the steps an issue needs to go through to reach resolution, setting permissions for who can move issues between steps, and automating these transitions.

Table Usage Guide

The jira_workflow table provides a detailed view of Jira Workflows within a Jira software instance. As a project manager or a team lead, leverage this table to gain insights into the steps, transitions, and status categories of each workflow. Utilize it to manage and optimize your team's work process, understand the lifecycle of tasks, and identify bottlenecks in your project's workflow.

Examples

Basic info

Analyze the settings to understand the default workflows in your Jira system, enabling you to better manage your project processes and prioritize tasks. This is particularly useful for project managers who need to assess the elements within their workflows and identify areas for improvement or customization.

select
name,
entity_id,
description,
is_default
from
jira_workflow;
select
name,
entity_id,
description,
is_default
from
jira_workflow;

List workflows that are not default

Uncover the details of workflows in Jira that have been customized and are not set as default. This can be beneficial for administrators to understand the unique workflows in their system and make necessary adjustments or improvements.

select
name,
entity_id,
description,
is_default
from
jira_workflow
where
not is_default;
select
name,
entity_id,
description,
is_default
from
jira_workflow
where
is_default = 0;

List workflows that are not associated with entity id

Discover workflows that lack an associated entity ID, which could indicate incomplete or misconfigured processes within your Jira workflow system. This can be useful to identify and rectify potential issues, ensuring smoother operations.

select
name,
entity_id,
description,
is_default
from
jira_workflow
where
entity_id = '';
select
name,
entity_id,
description,
is_default
from
jira_workflow
where
entity_id = '';

Schema for jira_workflow

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
descriptiontextThe description of the workflow.
entity_idtextThe entity ID of the workflow.
is_defaultbooleanWhether this is the default workflow.
login_idtext=, !=, ~~, ~~*, !~~, !~~*The unique identifier of the user login.
nametext=The name of the workflow.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
statusesjsonbThe statuses of the workflow.
titletextTitle of the resource.
transitionsjsonbThe transitions of the workflow.

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_workflow