turbot/github

steampipe plugin install githubsteampipe plugin install github
On This Page
Get Involved

Table: github_my_issue

GitHub Issues are used to track ideas, enhancements, tasks, or bugs for work on GitHub. The github_my_issue table lists issues that are assigned to you, across all repositories.

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

Examples

List all of the open issues assigned to you

select
repository_full_name,
issue_number,
title,
state,
author_login,
assignee_logins
from
github_my_issue
where
state = 'open';

List your open issues with a given label

select
repository_full_name,
issue_number,
title,
state,
tags
from
github_my_issue
where
state = 'open'
and tags ? 'bug';

List your 10 oldest open issues

select
repository_full_name,
issue_number,
created_at,
age (created_at),
title,
state
from
github_my_issue
where
state = 'open'
order by
created_at
limit 10;

.inspect github_my_issue

GitHub Issues owned by you. GitHub Issues are used to track ideas, enhancements, tasks, or bugs for work on GitHub.

NameTypeDescription
assignee_loginsjsonbAn array of user login names that are assigned to the issue.
author_associationtextThe association of the issue author to the repository (COLLABORATOR,CONTRIBUTOR, etc).
author_logintextThe login name of the user that submitted the PR.
bodytextThe body of the issue text.
closed_attimestamp without time zoneThe timestamp when the issue was closed.
commentsbigintThe number of comments on the issue.
comments_urltextThe API Comments URL.
created_attimestamp without time zoneThe timestamp when the issue was created.
events_urltextThe API Events URL.
html_urltextThe URL of the issue page in GitHub.
idbigintThe unique ID number of the issue.
issue_numberbigintThe issue number.
labelsjsonbAn array of labels associated with this issue.
labels_urltextThe API Labels URL.
lockedbooleanIf true, the issue is locked.
milestone_idbigintThe milestone id this issue is associated with.
milestone_titletextThe title of the milestone this issue is associated with.
node_idtextThe node id of the issue.
reactionsjsonbAn object containing the count of various reactions on the issue.
repository_full_nametextThe full name of the repository (login/repo-name).
repository_urltextThe API Repository URL.
statetextThe state or the issue (open, closed).
tagsjsonbA map of label names associated with this issue, in Steampipe standard format.
titletextThe issue title.
updated_attimestamp without time zoneThe timestamp when the issue was last updated.
urltextThe API URL of the issue.