Could someone help with a query to extract all the users in a particular role in a Jira project. Also help me with the extract of all the users in a group. Can I get the Full Name and the user name in the output.
can you try this Database query
select u.user_name , u.display_name, u.email_address from
cwd_user u inner join cwd_membership g
on u.id = g.child_id
where g.parent_id = XXXX
order by u.user_name;
XXXX - replace with the group id you wanted to list, you can get the id of the group from the below (cwd_group) table.
cwd_group will contain the Group Id and info about the group,
cwd_membership table will contain the User and group mapping.
cwd_user will contain the list of users created in jira
The Jira Marketing team is putting together an ebook on migrating to Data Center. We're looking for pro tips on how you staffed your project team and organized your Proof of Concept. Share yo...
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