We have created a new group with bulk change authority and we want to add all Project Admins to it. Is there a way to do this without having to manually add them one at a time?
Just closing this out. I was able to run the query and then use excel to parse the users. I then copied and pasted them in to the new group. It took a little bit of manual work but the query to identify everyone was a big help. Thanks, Greg
The fastest way I know of would be as follows:
Hope this helps!
Jason, I see how to do that but it still requires manually adding a few hundred users that I have to identify ahead of time. The User picker does not show any details about the users other than being able to filter by group.
So I'm looking for a query or filter I can run to identify every user that is in a project admin role on any project since our intent is to only allow project admins the ability to do bulk edit.
One hint, I hope that it will help you:
1. Prepare sql statement (I don't have time to prepare it now) to get users from administrator role in all projects. You have to cover two cases to get result:
a.) users entered directly in users column
select * FROM PROJECTROLEACTOR where projectroleid=10002 AND roletype='atlassian-user-role-actor';
(10002 is id for administrator role.)
b.) users entered in Groups column
to get groups..
select * FROM PROJECTROLEACTOR where projectroleid=10002 AND roletype='atlassian-group-role-actor';
You need connect groups from roletypeparameter field with groups in CWD_MEMBERSHIP table and with users in CWD_USER table...
2. Group users from both tables to get unique user values from both tables
3. Use jelly script to add users to groups
You can use excel formulas to multiply sentence "<jira:AddUserToGroup username=
/>" andfill "userX" values with user values from your user table.
We're looking for participants for another workshop at Atlassian! We need Jira admins who have interesting custom workflows, issue views, or boards. Think you have a story to sh...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs