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_epic
The gitlab_epic
table can be used to query information about epics associated with a specific group.
However, you must specify a group_id
in the where or join clause.
Examples
List all epics for a specific group
select id, title, description, state, author, due_datefrom gitlab_epicwhere group_id = 14597683;
Get epics from a specific group and author
select id, title, description, state, due_date, upvotes, downvotesfrom gitlab_epicwhere group_id = 14597683 and author_id = 469853662;
Query examples
Schema for gitlab_epic
Name | Type | Operators | Description |
---|---|---|---|
_ctx | jsonb | Steampipe context in JSON form, e.g. connection_name. | |
author | text | The username of the author of the epic. | |
author_id | bigint | = | The ID of the author of the epic. |
author_name | text | The display name of the author of the epic. | |
author_url | text | The url for the authors profile. | |
closed_at | timestamp with time zone | Timestamp of when the epic was closed. | |
created_at | timestamp with time zone | Timestamp of when the epic was created. | |
description | text | The epics description. | |
downvotes | bigint | The number of down votes for the epic. | |
due_date | timestamp with time zone | Timestamp indicating the due date of the epic. | |
end_date | timestamp with time zone | Timestamp indicating the end of the epic. | |
group_id | bigint | = | The ID of the parent group for this epic. |
id | bigint | The ID of the epic. | |
iid | bigint | The instance ID of the epic. | |
labels | jsonb | An array of labels associated with the epic. | |
parent_id | bigint | The ID of the parent for the epic. | |
start_date | timestamp with time zone | Timestamp indicating the start of the epic. | |
state | text | = | The state of the epic. |
title | text | The epics title. | |
updated_at | timestamp with time zone | Timestamp of when the epic was last updated. | |
upvotes | bigint | The number of up votes for the epic. | |
user_notes_count | bigint | A count of user notes on the epic. | |
web_url | text | The web url of the epic. |