steampipe plugin install theapsgroup/gitlab

Table: gitlab_group_iteration

The gitlab_group_iteration table can be used to query information about iterations for specific groups.

However, you must specify a group_id in the where or join clause.

Examples

List all iterations for a specific group

select
id,
group_id,
title,
description,
due_date
from
gitlab_group_iteration
where
group_id = 14597683;

Get a specific iteration by iid

select
id,
iid,
group_id,
title,
description,
due_date
from
gitlab_group_iteration
where
group_id = 14597683
and iid = 15;

Schema for gitlab_group_iteration

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
created_attimestamp with time zoneTimestamp of when the iteration was created.
descriptiontextThe description of the iteration.
due_datetimestamp with time zoneTimestamp indicating the due date of the iteration.
group_idbigint=The ID of the group to which this iteration belongs.
idbigintThe ID of the iteration.
iidbigintThe instance ID of the iteration.
sequencebigintThe sequence number of the iteration.
start_datetimestamp with time zoneTimestamp indicating the start of the iteration.
statebigintThe state of the iteration.
titletextThe title of the iteration.
updated_attimestamp with time zoneTimestamp of when the iteration was last updated.
web_urltextThe web url of the iteration.