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_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_datefrom gitlab_group_iterationwhere group_id = 14597683;
Get a specific iteration by iid
select id, iid, group_id, title, description, due_datefrom gitlab_group_iterationwhere group_id = 14597683 and iid = 15;
Schema for gitlab_group_iteration
Name | Type | Operators | Description |
---|---|---|---|
_ctx | jsonb | Steampipe context in JSON form, e.g. connection_name. | |
created_at | timestamp with time zone | Timestamp of when the iteration was created. | |
description | text | The description of the iteration. | |
due_date | timestamp with time zone | Timestamp indicating the due date of the iteration. | |
group_id | bigint | = | The ID of the group to which this iteration belongs. |
id | bigint | The ID of the iteration. | |
iid | bigint | The instance ID of the iteration. | |
sequence | bigint | The sequence number of the iteration. | |
start_date | timestamp with time zone | Timestamp indicating the start of the iteration. | |
state | bigint | The state of the iteration. | |
title | text | The title of the iteration. | |
updated_at | timestamp with time zone | Timestamp of when the iteration was last updated. | |
web_url | text | The web url of the iteration. |