Report creation

[Leary Stewart]

How can i create a report showing me all users and list of issues assign to them all together

[Diego Zarpelon [Atlassian]]

Hey Leary.

You can use an SQL query on your database to accomplish this, note that i'm using MySQL on this example so some features ( as CONCAT) may not work on your db server.

Basically the query would be something like this:

select ASSIGNEE,project.pname,concat(project.pkey,"-",issuenum) from jiradb.jiraissue  join jiradb.project on jiraissue.PROJECT=project.id;

Hope this helps!