turbot/gitlab_insights

Query: open_merge_request_table

Usage

powerpipe query gitlab_insights.query.open_merge_request_table

SQL

select
p.full_path as "Project",
m.title as "Merge Request",
now()::date - m.created_at::date as "Age in Days",
now()::date - m.updated_at::date as "Days Since Last Update",
author_username as "Author",
m.web_url,
p.web_url as project_url
from
gitlab_my_project p
join gitlab_merge_request m on m.project_id = p.id
where
m.state = 'opened'
order by
"Age in Days" desc;

Dashboards

The query is used in the dashboards: