Uploaded image for project: 'SonarQube'
  1. SonarQube
  2. SONAR-12666

Groups with permission are no more at the top when large number of groups

    Details

    • Edition:
      Community
    • Production Notes:
      None

      Description

      Description

      In Global Permissions page, Groups/Users with permissions should be listed on top of the list.
      However, when there's a high number of groups, this is not working anymore.

      How to reproduce

      • From an empty database
      • Create a project
      • Create a high number of groups (100 is enough)
      • On the project, associate a permission to each group.
      • In Global Permissions page, set a permission to group that do not appear in the first page)
      • Refresh
        => The group with the permission does not appear in the first page of list.

      (This script can be used to create 100 groups and update default template to set one permission on each group :

      for i in `seq 1 100`; do curl -u admin:admin -X POST  "http://localhost:9000/api/user_groups/create?name=sonarqube-group$i" ; for perm in admin codeviewer issueadmin securityhotspotadmin scan user; do curl -u admin:admin -X POST  "http://localhost:9000/api/permissions/add_group_to_template?groupName=sonarqube-group$i&permission=$perm&templateName=Default%20Template"; done  ; done
      

      )

      Technical considerations

      This issue seems to come from GroupPermissionDao#selectGroupNamesByQuery.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                julien.lancelot Julien Lancelot
                Reporter:
                julien.lancelot Julien Lancelot
              • Votes:
                1 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Due:
                  Created:
                  Updated:
                  Resolved: