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.
Try like this,
SELECT U.* FROM projectroleactor P
INNER JOIN cwd_user U
ON U.USER_NAME = P.ROLETYPEPARAMETER
where pid = 'UR PROJECTID'
and projectroleid = 'ROLEID';
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;
The Jira Software Cloud Team has been busy working on a simple, secure, and reliable way to integrate your build and deployment information from Jenkins with Jira Software Cloud. This means you don’t...
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
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events