steampipe plugin install github

Table: github_my_issue - Query GitHub Issues using SQL

GitHub Issues is a feature in GitHub that provides a platform to track bugs, enhancements, or other requests. It allows users to collaborate on tasks, discuss project details, and manage project timelines. Issues are a great way to keep track of tasks, improvements, and bugs for your projects.

Table Usage Guide

The github_my_issue table provides insights into personal issues within GitHub. As a project manager or developer, explore issue-specific details through this table, including the issue title, state, assignee, and associated metadata. Utilize it to manage and track tasks, improvements, and bugs for your projects.

Important Notes

  • To view all the issues belonging to a repository, use the github_issue table.

Examples

List all of the open issues assigned to you

Explore which open issues are currently assigned to you on GitHub. This is useful for managing your workload and prioritizing tasks.

select
repository_full_name,
number,
title,
state,
author_login,
author_login
from
github_my_issue
where
state = 'OPEN';
select
repository_full_name,
number,
title,
state,
author_login,
author_login
from
github_my_issue
where
state = 'OPEN';

List your 10 oldest open issues

Explore which of your open issues have been unresolved the longest to help prioritize your workflow and manage your project effectively.

select
repository_full_name,
number,
created_at,
age(created_at),
title,
state
from
github_my_issue
where
state = 'OPEN'
order by
created_at
limit
10;
select
repository_full_name,
number,
created_at,
julianday('now') - julianday(created_at) as age,
title,
state
from
github_my_issue
where
state = 'OPEN'
order by
created_at
limit
10;

Schema for github_my_issue

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
active_lock_reasontextReason that the conversation was locked.
assigneesjsonbA list of Users assigned to the issue.
assignees_total_countbigintCount of assignees on the issue.
authorjsonbThe actor who authored the issue.
author_associationtextAuthor's association with the subject of the issue.
author_logintextThe login of the issue author.
bodytextIdentifies the body of the issue.
body_urltextURL for this issue body.
closedbooleanIf true, issue is closed.
closed_attimestamp with time zoneTimestamp when issue was closed.
comments_total_countbigintCount of comments on the issue.
created_attimestamp with time zoneTimestamp when issue was created.
created_via_emailbooleanIf true, issue was created via email.
editorjsonbThe actor who edited the issue.
full_database_idbigintIdentifies the primary key from the database as a BigInt.
idbigintThe ID of the issue.
includes_created_editbooleanIf true, issue was edited and includes an edit with the creation data.
is_pinnedbooleanif true, this issue is currently pinned to the repository issues list.
is_read_by_userbooleanif true, this issue has been read by the user.
labelsjsonbA map of labels for the issue.
labels_srcjsonbThe first 100 labels associated to the issue.
labels_total_countbigintCount of labels on the issue.
last_edited_attimestamp with time zoneTimestamp when issue was last edited.
lockedbooleanIf true, issue is locked.
login_idtext=, !=, ~~, ~~*, !~~, !~~*Unique identifier for the user login.
milestonejsonbThe milestone associated with the issue.
node_idtextThe node ID of the issue.
numberbigintThe issue number.
published_attimestamp with time zoneTimestamp when issue was published.
repository_full_nametextThe full name of the repository (login/repo-name).
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
statetext=The state of the issue.
state_reasontextThe reason for the issue state.
titletextThe title of the issue.
updated_attimestamp with time zone>, >=Timestamp when issue was last updated.
urltextURL for the issue.
user_can_closebooleanIf true, user can close the issue.
user_can_reactbooleanIf true, user can react on the issue.
user_can_reopenbooleanIf true, user can reopen the issue.
user_can_subscribebooleanIf true, user can subscribe to the issue.
user_can_updatebooleanIf true, user can update the issue,
user_cannot_update_reasonsjsonbA list of reason why user cannot update the issue.
user_did_authorbooleanIf true, user authored the issue.
user_subscriptiontextSubscription state of the user to 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)" -- github

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

steampipe_export_github --config '<your_config>' github_my_issue