turbot/gitlab_insights

Query: open_epic_table

Usage

powerpipe query gitlab_insights.query.open_epic_table

Steampipe Tables

SQL

select
g.full_path as "Group",
title as "Epic",
now() :: date - e.created_at :: date as "Age in Days",
now() :: date - e.updated_at :: date as "Days Since Last Update",
author as "Author",
e.web_url,
g.web_url as group_url
from
gitlab_group g
join gitlab_epic e on e.group_id = g.id
where
e.state = 'opened'
order by
"Age in Days" desc;

Dashboards

The query is used in the dashboards: