steampipe plugin install theapsgroup/gitlab

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_date
from
gitlab_epic
where
group_id = 14597683;

Get epics from a specific group and author

select
id,
title,
description,
state,
due_date,
upvotes,
downvotes
from
gitlab_epic
where
group_id = 14597683
and author_id = 469853662;

Schema for gitlab_epic

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
authortextThe username of the author of the epic.
author_idbigint=The ID of the author of the epic.
author_nametextThe display name of the author of the epic.
author_urltextThe url for the authors profile.
closed_attimestamp with time zoneTimestamp of when the epic was closed.
created_attimestamp with time zoneTimestamp of when the epic was created.
descriptiontextThe epics description.
downvotesbigintThe number of down votes for the epic.
due_datetimestamp with time zoneTimestamp indicating the due date of the epic.
end_datetimestamp with time zoneTimestamp indicating the end of the epic.
group_idbigint=The ID of the parent group for this epic.
idbigintThe ID of the epic.
iidbigintThe instance ID of the epic.
labelsjsonbAn array of labels associated with the epic.
parent_idbigintThe ID of the parent for the epic.
start_datetimestamp with time zoneTimestamp indicating the start of the epic.
statetext=The state of the epic.
titletextThe epics title.
updated_attimestamp with time zoneTimestamp of when the epic was last updated.
upvotesbigintThe number of up votes for the epic.
user_notes_countbigintA count of user notes on the epic.
web_urltextThe web url of the epic.