Jira- can you send me a query that show where role and group users are in on a specific project

André Filipe Melo

I would like the query show the results as:

Project Name | Role | Group | UserName

Payne

Give this a whirl - 

SELECT project.pname as project,projectrole.NAME as role,
CASE WHEN projectroleactor.ROLETYPE = 'atlassian-group-role-actor' THEN projectroleactor.ROLETYPEPARAMETER ELSE cwd_user.display_name END AS 'user-group name'
FROM project
LEFT JOIN projectroleactor on projectroleactor.PID = project.ID
LEFT JOIN projectrole on projectrole.ID = projectroleactor.PROJECTROLEID
LEFT JOIN app_user ON app_user.user_key = projectroleactor.ROLETYPEPARAMETER
LEFT OUTER JOIN cwd_user ON cwd_user.user_name = app_user.lower_user_name
ORDER BY project.pname,projectrole.name,CASE WHEN projectroleactor.ROLETYPE = 'atlassian-group-role-actor' THEN 0 ELSE 1 END,name