Bulk Edit Groups in Jira

Still need help?

The Atlassian Community is here for you.

Ask the community


When managing group membership directly from the group rather than through the User Browser, there is a system limitation on the number of users you can add to a group at a time of 100, which limits the amount of users that can be edited at one time. To add more than 100 members into the group at once, they need to be extracted from the database with SQL.


  1. Identify the User Directory the users belong to:

    SELECT id, directory_name FROM cwd_directory
  2. Select all the users from that directory:

    SELECT user_name FROM cwd_user where directory_id = <id from the previous query>
  3. Comma separate them then copy and paste into the User Box:
  4. Press the  button.

(info) Please see  JRA-12844 - Getting issue details... STATUS  for further information on the 100 user limitation.

Last modified on Nov 19, 2021

Was this helpful?

Provide feedback about this article
Powered by Confluence and Scroll Viewport.