turbot/gitlab_insights

Query: open_issue_table

Usage

powerpipe query gitlab_insights.query.open_issue_table

SQL

select
p.full_path as "Project",
title as "Issue",
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_project p
join gitlab_issue i on i.project_id = p.id
where
i.state = 'opened'
order by
"Age in Days" desc;

Dashboards

The query is used in the dashboards: