gitlab_applicationgitlab_branchgitlab_commitgitlab_epicgitlab_groupgitlab_group_access_requestgitlab_group_hookgitlab_group_iterationgitlab_group_membergitlab_group_projectgitlab_group_push_rulegitlab_group_subgroupgitlab_group_variablegitlab_hookgitlab_instance_variablegitlab_issuegitlab_merge_requestgitlab_merge_request_changegitlab_my_eventgitlab_my_issuegitlab_my_projectgitlab_projectgitlab_project_access_requestgitlab_project_container_registrygitlab_project_deploymentgitlab_project_iterationgitlab_project_jobgitlab_project_membergitlab_project_pages_domaingitlab_project_pipelinegitlab_project_pipeline_detailgitlab_project_protected_branchgitlab_project_repositorygitlab_project_repository_filegitlab_project_variablegitlab_settinggitlab_snippetgitlab_usergitlab_user_eventgitlab_version
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;Query examples
Schema for gitlab_my_issue
| Name | Type | Operators | Description |
|---|---|---|---|
| _ctx | jsonb | Steampipe context in JSON form, e.g. connection_name. | |
| assignee | text | The username of the user assigned to the issue - link to `gitlab_user.username` | |
| assignee_id | bigint | The ID of the user assigned to the issue - link to `gitlab_user.id`. | |
| assignees | jsonb | An array of assigned usernames, for when more than one user is assigned. | |
| author | text | The username of the author - link to `gitlab_user.username`. | |
| author_id | bigint | The ID of the author - link to `gitlab_user.id`. | |
| author_name | text | The display name of the author | |
| closed_at | timestamp with time zone | Timestamp of when issue was closed. (null if not closed). | |
| closed_by | text | The username of the user whom closed the issue - link to `gitlab_user.username`. | |
| closed_by_id | bigint | The ID of the user whom closed the issue - link to `gitlab_user.id`. | |
| confidential | boolean | Indicates if the issue is marked as confidential. | |
| created_at | timestamp with time zone | Timestamp of issue creation. | |
| description | text | The description of the Issue. | |
| discussion_locked | boolean | Indicates if the issue has the discussions locked against new input. | |
| downvotes | bigint | Count of down-votes received on the issue. | |
| due_date | timestamp with time zone | Timestamp of due date for the issue to be completed by. | |
| epic_group_id | bigint | The group ID of the associated epic. | |
| epic_id | bigint | The ID of the associated epic. | |
| epic_iid | bigint | The IID of the associated epic. | |
| epic_issue_id | bigint | Epic issue id. | |
| epic_title | text | Title of the associated epic. | |
| epic_url | text | The url of the associated epic. | |
| external_id | text | The external ID of the issue. | |
| full_ref | text | Full reference of the issue. | |
| id | bigint | The ID of the Issue. | |
| iid | bigint | The instance ID of the Issue. | |
| issue_link_id | bigint | Issue link id. | |
| issue_type | text | The type of issue. | |
| labels | jsonb | An array of strings for the textual labels applied to the issue. | |
| merge_requests_count | bigint | Count of merge requests associated with the issue. | |
| milestone_created_at | timestamp with time zone | Timestamp at which the milestone was created. | |
| milestone_description | text | The description of the milestone. | |
| milestone_due_date | timestamp with time zone | Timestamp of due date for the milestone to be completed by. | |
| milestone_expired | boolean | Indicates if the milestone is expired. | |
| milestone_id | bigint | The ID of the milestone the issues is placed into. | |
| milestone_iid | bigint | The instance id of the milestone | |
| milestone_start_date | timestamp with time zone | Timestamp of when the milestone was started. | |
| milestone_state | text | The current state of the milestone. | |
| milestone_title | text | The title of the milestone. | |
| milestone_updated_at | timestamp with time zone | Timestamp at which the milestone was updated. | |
| project_id | bigint | The ID of the project - link to `gitlab_project.id`. | |
| rel_ref | text | Relative reference of the issue. | |
| short_ref | text | Short reference of the issue. | |
| state | text | The state of the Issue (opened, closed, etc). | |
| subscribed | boolean | Indicates if current user is subscribed to the issue. | |
| time_estimate | bigint | Time estimated against the issue. | |
| title | text | The title of the Issue. | |
| total_time_spent | bigint | Total time spent on the issue. | |
| updated_at | timestamp with time zone | Timestamp of last update to the issue. | |
| upvotes | bigint | Count of up-votes received on the issue. | |
| user_notes_count | bigint | Count of user notes on the issue. | |
| web_url | text | The url to access the issue. | |
| weight | bigint | The weight assigned to the issue. |