steampipe plugin install theapsgroup/gitlabsteampipe plugin install theapsgroup/gitlab

Table: gitlab_project_iteration

The gitlab_project_iteration table can be used to query information about iterations for specific projects.

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

Examples

select
  id,
  project_id,
  title,
  description,
  due_date
from
  gitlab_project_iteration
where
  project_id = 14597683;

select
  id,
  iid,
  project_id,
  title,
  description,
  due_date
from
  gitlab_project_iteration
where
  project_id = 14597683
  and iid = 15;

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.
id	bigint		The ID of the iteration.
iid	bigint		The instance ID of the iteration.
project_id	bigint	=	The ID of the project to which this iteration belongs.
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.