theapsgroup/gitlab

steampipe plugin install theapsgroup/gitlabsteampipe plugin install theapsgroup/gitlab

Table: gitlab_my_issue

Issues are used to track bugs, feature requests, tasks, etc on GitLab.

The gitlab_my_issue table can be used to query information against issues created by or assigned to the authenticated user in the GitLab instance.

Examples

Obtain all your issues

select
*
from
gitlab_my_issue;

.inspect gitlab_my_issue

GitLab Issues that are Created By or Assigned To the authenticated user.

NameTypeDescription
assigneetextThe username of the user assigned to the issue - link to `gitlab_user.username`
assignee_idbigintThe ID of the user assigned to the issue - link to `gitlab_user.id`.
assigneesjsonbAn array of assigned usernames, for when more than one user is assigned.
authortextThe username of the author - link to `gitlab_user.username`.
author_idbigintThe ID of the author - link to `gitlab_user.id`.
closed_attimestamp without time zoneTimestamp of when issue was closed. (null if not closed).
closed_bytextThe username of the user whom closed the issue - link to `gitlab_user.username`.
closed_by_idbigintThe ID of the user whom closed the issue - link to `gitlab_user.id`.
confidentialbooleanIndicates if the issue is marked as confidential.
created_attimestamp without time zoneTimestamp of issue creation.
descriptiontextThe description of the Issue.
discussion_lockedbooleanIndicates if the issue has the discussions locked against new input.
downvotesbigintCount of down-votes received on the issue.
due_datetimestamp without time zoneTimestamp of due date for the issue to be completed by.
external_idtextThe external ID of the issue.
idbigintThe ID of the Issue.
project_idbigintThe ID of the project - link to `gitlab_project.id`.
statetextThe state of the Issue (opened, closed, etc).
titletextThe title of the Issue.
updated_attimestamp without time zoneTimestamp of last update to the issue.
upvotesbigintCount of up-votes received on the issue.
web_urltextThe url to access the issue.