steampipe plugin install jira

Table: jira_issue_comment - Query Jira Issue Comments using SQL

Jira is a project management tool that aids in issue tracking and agile project management. It is widely used by software development teams for planning, tracking progress, and releasing software. Issue comments in Jira serve as a communication medium on the platform, allowing users to discuss, provide updates, and track changes regarding specific issues.

Table Usage Guide

The jira_issue_comment table provides insights into the comments made on issues within the Jira platform. As a project manager or a team member, you can explore comment-specific details through this table, including the author of the comment, creation date, and the issue the comment is associated with. Utilize it to track communication, understand the context of discussions, and monitor the progress of issues.

Examples

Basic info

Explore the comments on different issues in Jira by identifying their unique identifiers and authors. This can be useful in understanding who is actively participating in discussions and contributing to issue resolutions.

select
id,
self,
issue_id,
author
from
jira_issue_comment;
select
id,
self,
issue_id,
author
from
jira_issue_comment;

List comments that are hidden in Service Desk

Discover the segments that contain hidden comments in the Service Desk to gain insights into user feedback or issues that may not be publicly visible. This can be useful in understanding customer concerns and improving service quality.

select
id,
self,
issue_id,
body,
created,
jsd_public
from
jira_issue_comment
where
jsd_public;
select
id,
self,
issue_id,
body,
created,
jsd_public
from
jira_issue_comment
where
jsd_public;

List comments posted in the last 5 days for a particular issues

Explore recent feedback or updates on a specific issue by identifying comments posted in the last five days. This can help in tracking the progress of issue resolution and understanding the current discussion around it.

select
id,
issue_id,
body,
created
from
jira_issue_comment
where
created >= now() - interval '5' day
and issue_id = '10021';
select
id,
issue_id,
body,
created
from
jira_issue_comment
where
created >= datetime('now', '-5 days')
and issue_id = '10021';

List comments that were updated in last 2 hours

Explore recent activity by identifying comments that have been updated in the past two hours. This is useful for staying informed about ongoing discussions or changes in your Jira issues.

select
id,
issue_id,
body,
created,
updated
from
jira_issue_comment
where
updated >= now() - interval '2' hour;
select
id,
issue_id,
body,
created,
updated
from
jira_issue_comment
where
updated >= datetime('now', '-2 hours');

Get author information of a particular issue comment

Explore the identity of the individual who commented on a specific issue. This can be beneficial for understanding who is contributing to the discussion or if any particular individual's input requires further attention.

select
id,
issue_id,
author ->> 'accountId' as author_account_id,
author ->> 'accountType' as author_account_type,
author ->> 'displayName' as author_name,
author ->> 'emailAddress' as author_email_address,
author ->> 'timeZone' as author_time_zone
from
jira_issue_comment
where
id = '10015';
select
id,
issue_id,
json_extract(author, '$.accountId') as author_account_id,
json_extract(author, '$.accountType') as author_account_type,
json_extract(author, '$.displayName') as author_name,
json_extract(author, '$.emailAddress') as author_email_address,
json_extract(author, '$.timeZone') as author_time_zone
from
jira_issue_comment
where
id = '10015';

Schema for jira_issue_comment

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
authorjsonbThe user information who added the issue comment.
bodytextThe content of the issue comment.
createdtimestamp with time zoneTime when the issue comment was created.
idtext=The ID of the issue comment.
issue_idtext=The ID of the issue.
jsd_publicbooleanJsdPublic set to false does not hide comments in Service Desk projects.
login_idtext=, !=, ~~, ~~*, !~~, !~~*The unique identifier of the user login.
selftextThe URL of the issue comment.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
titletextTitle of the resource.
update_authorjsonbThe user information who updated the issue comment.
updatedtimestamp with time zoneTime when the issue comment was last updated.

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_issue_comment