turbot/bitbucket
steampipe plugin install bitbucket

Table: bitbucket_issue - Query Bitbucket Issues using SQL

Bitbucket Issues is a feature within Bitbucket that allows you to track and manage tasks, enhancements, and bugs for your projects. It provides a centralized platform to manage issues for various Bitbucket repositories, including details such as issue ID, title, type, priority, status, and assignee. Bitbucket Issues helps you stay informed about the progress and distribution of tasks within your project.

Table Usage Guide

The bitbucket_issue table provides insights into issue management within Bitbucket. As a project manager or developer, explore issue-specific details through this table, including issue type, priority, status, and assignee. Utilize it to uncover information about issues, such as their distribution among team members, the status of various tasks, and the prioritization of enhancements and bugs.

Important Notes

  • You must specify the repository_full_name in the where clause in order to query this table.

Examples

List the issues in a repository

Explore which issues are currently present in a specific project repository. This is useful for project managers who need to assess the status and assignment of issues for effective project management.

select
repository_full_name,
id,
title,
state,
assignee_display_name,
assignee_uuid
from
bitbucket_issue
where
repository_full_name = 'gamesaucer/mono-ui';
select
repository_full_name,
id,
title,
state,
assignee_display_name,
assignee_uuid
from
bitbucket_issue
where
repository_full_name = 'gamesaucer/mono-ui';

List the unassigned open issues in a repository

Explore which open issues in a specific repository have not been assigned yet, enabling efficient task allocation and workload management.

select
repository_full_name,
id,
title,
state,
assignee_display_name,
assignee_uuid
from
bitbucket_issue
where
repository_full_name = 'LalitFort/steampipe-plugin-bitbucket'
and assignee_uuid is null
and state in ('new', 'open');
select
repository_full_name,
id,
title,
state,
assignee_display_name,
assignee_uuid
from
bitbucket_issue
where
repository_full_name = 'LalitFort/steampipe-plugin-bitbucket'
and assignee_uuid is null
and state in ('new', 'open');

List the open issues in a repository assigned to a specific user

Explore which open issues in a specific repository are assigned to a particular user. This can be useful for project managers to track individual workloads and identify any potential bottlenecks in project progression.

select
repository_full_name,
id,
title,
state,
assignee_display_name,
assignee_uuid
from
bitbucket_issue
where
repository_full_name = 'LalitFort/steampipe-plugin-bitbucket'
and assignee_display_name = 'Lalit Bhardwaj'
and state in ('new', 'open');
select
repository_full_name,
id,
title,
state,
assignee_display_name,
assignee_uuid
from
bitbucket_issue
where
repository_full_name = 'LalitFort/steampipe-plugin-bitbucket'
and assignee_display_name = 'Lalit Bhardwaj'
and state in ('new', 'open');

Report of the number issues in a repository by author

Analyze the distribution of issues in a specific repository based on the author to understand their individual contributions and identify any patterns or anomalies.

select
assignee_display_name,
assignee_uuid,
count(*) as num_issues
from
bitbucket_issue
where
repository_full_name = 'LalitFort/steampipe-plugin-bitbucket'
group by
assignee_uuid,
assignee_display_name
order by
num_issues desc;
select
assignee_display_name,
assignee_uuid,
count(*) as num_issues
from
bitbucket_issue
where
repository_full_name = 'LalitFort/steampipe-plugin-bitbucket'
group by
assignee_uuid,
assignee_display_name
order by
num_issues desc;

List the unassigned open issues in your repositories

Explore the open issues in your repositories that have not been assigned to anyone. This is useful in identifying areas that need attention or tasks that are yet to be allocated to team members.

select
i.repository_full_name,
i.id,
i.title,
i.state,
i.assignee_display_name,
i.assignee_uuid
from
bitbucket_issue as i,
bitbucket_my_repository as r
where
repository_full_name = r.full_name
and assignee_uuid is null
and state in ('new', 'open');
Error: The corresponding SQLite query is unavailable.

Schema for bitbucket_issue

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
assignee_display_nametextDisplay name of the assignee of this issue.
assignee_uuidtextUUID of the assignee of this issue.
componentjsonbContent object of the issue with the rendering type details.
contentjsonbVersion is a point in project or product timeline.
createdtimestamp with time zoneTimestamp when issue was created.
editedtimestamp with time zoneTimestamp when project was last edited.
idbigint=The issues's immutable id.
kindtextThe kind of the issue. Can be one of "bug", "enhancement", "proposal", and "task".
milestonejsonbA milestone is a subset of a version. It is a point that a development team works towards.
prioritytextThe priority of the issue. Can be one of "trivial", "minor", "major", "critical", and "blocker".
reporter_display_nametextDisplay name of the user issue is reported.
reporter_uuidtextUUID of the user issue is reported.
repository_full_nametext=The repository's full name.
self_linktextA self link to this issue.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
statetextA current state of the issue. Can we one of "new", "open", "resolved","on hold", "invalid", "duplicate", "wontfix" and "closed".
titletextTitle of the resource.
typetextType of the Bitbucket resource. It will be always "issue".
updatedtimestamp with time zoneTimestamp when issue was last updated.
versionjsonbVersion is a point in project or product timeline.
votesbigintNumber of the upvotes on the issue.
watchesbigintNo of the watchers on the issue.

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)" -- bitbucket

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

steampipe_export_bitbucket --config '<your_config>' bitbucket_issue