JIRA Project wise User list

[laknath]

Want to extract a report from JIRA with the total project-wise user list. I tried with the below query. But all projects are not displayed. Please kindly assist. 

SELECT p.pname as Project, pr.NAME as Role, u.display_name as User_Name
FROM projectroleactor pra
INNER JOIN projectrole pr ON pr.ID = pra.PROJECTROLEID
INNER JOIN project p ON p.ID = pra.PID
INNER JOIN app_user au ON au.user_key = pra.ROLETYPEPARAMETER
INNER JOIN cwd_user u ON u.lower_user_name = au.lower_user_name;

[Girish Shenoy]

Hi,

I tried the above query and it returned all the projects for me. This is the correct query.

Did you run query to find list of projects?

What is the no of rows you get when you run following query.

SELECT * from project