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?
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.
...ollected feedback from users around the lack of shortcuts, and we’re here to address that: In next-gen projects, I miss the keyboard shortcuts badly. This is particularly true on the Board, but also i...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event