turbot/gitlab_insights

Query: my_open_issue_table

Usage

powerpipe query gitlab_insights.query.my_open_issue_table

SQL

select
i.title as "Issue",
p.full_path as "Project",
now()::date - i.created_at::date as "Age in Days",
now()::date - i.updated_at::date as "Days Since Last Update",
author as "Author",
i.web_url,
p.web_url as project_url
from
gitlab_my_issue i
inner join gitlab_project p on i.project_id = p.id
where
i.state = 'opened'
order by
"Age in Days" desc;

Dashboards

The query is used in the dashboards: