Skip to content

Add endpoint with standard roles and members count for self-managed

Jarka Košanová requested to merge 472745-role-countes-selfm into master

What does this MR do and why?

Id adds an endpoint with standard roles and members count for self-managed.

MR acceptance checklist

Please evaluate this MR against the MR acceptance checklist. It helps you analyze changes to reduce risks in quality, performance, reliability, security, and maintainability.

Database

New SQL query

Member.count_by_role

This query will not run on SaaS, only on self-managed. For Saas, we will filter by group or group hierarchy (follow-up MR will come, task: #472745 (closed)).

Query plans

How to set up and validate locally

Run the following graphQL query

{
  standardRoles {
    nodes {
      accessLevel
      name
      membersCount
    }
  }
}
Expected response
{
  "data": {
    "standardRoles": {
      "nodes": [
        {
          "accessLevel": 5,
          "name": "Minimal Access",
          "membersCount": 0
        },
        {
          "accessLevel": 10,
          "name": "Guest",
          "membersCount": 27
        },
        {
          "accessLevel": 20,
          "name": "Reporter",
          "membersCount": 41
        },
        {
          "accessLevel": 30,
          "name": "Developer",
          "membersCount": 34
        },
        {
          "accessLevel": 40,
          "name": "Maintainer",
          "membersCount": 40
        },
        {
          "accessLevel": 50,
          "name": "Owner",
          "membersCount": 85
        }
      ]
    }
  }
}

Related to #472745 (closed)

Edited by Jarka Košanová

Merge request reports

Loading