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
use this query for that,
SELECT * FROM `projectroleactor`
where pid = 'XXX'
and projectroleid = 'yyy';
u can get the pid (project id) from the below table.
SELECT * FROM `project`;
projectroleid u can get from
select * from projectrole;
Atlassian Summit is an excellent opportunity for in-person support, training, and networking.Learn more
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