branch_1_year_countbranch_24_hours_countbranch_30_90_days_countbranch_30_days_countbranch_90_365_days_countbranch_countbranch_protected_countbranch_protection_tablebranch_tablebranch_unprotected_countgroup_2fa_disabled_countgroup_2fa_enabled_countgroup_2fa_tablegroup_access_request_countgroup_access_request_tablegroup_countgroup_expiring_member_1_year_countgroup_expiring_member_24_hours_countgroup_expiring_member_30_90_days_countgroup_expiring_member_30_days_countgroup_expiring_member_90_365_days_countgroup_expiring_member_tablegroup_internal_countgroup_private_countgroup_public_countgroup_visibility_tablemy_open_issue_1_year_countmy_open_issue_24_hours_countmy_open_issue_30_90_days_countmy_open_issue_30_days_countmy_open_issue_90_365_days_countmy_open_issue_countmy_open_issue_tableopen_epic_1_year_countopen_epic_24_hours_countopen_epic_30_90_days_countopen_epic_30_days_countopen_epic_90_365_days_countopen_epic_countopen_epic_tableopen_issue_1_year_countopen_issue_24_hours_countopen_issue_30_90_days_countopen_issue_30_days_countopen_issue_90_365_days_countopen_issue_countopen_issue_tableopen_merge_request_1_year_countopen_merge_request_24_hours_countopen_merge_request_30_90_days_countopen_merge_request_30_days_countopen_merge_request_90_365_days_countopen_merge_request_countopen_merge_request_tableproject_101_500_stars_countproject_1_100_stars_countproject_501_1000_stars_countproject_access_request_countproject_access_request_tableproject_countproject_expiring_member_1_year_countproject_expiring_member_24_hours_countproject_expiring_member_30_90_days_countproject_expiring_member_30_days_countproject_expiring_member_90_365_days_countproject_expiring_member_tableproject_failed_pipeline_countproject_failed_pipeline_tableproject_internal_countproject_license_tableproject_other_license_countproject_over_1000_stars_countproject_permissive_license_countproject_popular_copyleft_license_countproject_private_countproject_public_countproject_star_tableproject_unstarred_countproject_visibility_tableproject_weak_copyleft_license_countproject_without_license_count
Query: open_merge_request_count
Usage
powerpipe query gitlab_insights.query.open_merge_request_count
Steampipe Tables
SQL
select count(m.*) as value, 'Open Merge Requests' as labelfrom gitlab_my_project p join gitlab_merge_request m on m.project_id = p.idwhere m.state = 'opened';
Dashboards
The query is used in the dashboards: