Show users without assigned issues

[Colin Breame]

In the issues screen (within project), is there any way of making the "Unresolved: By Assignee" show all users for the project, including those that have no assigned issues?

I have the same question for the Agile board when showing users in swimlanes. i.e. show users without any assigned issues.

Thanks

[Tiago Comasseto · Accepted solution]

Hi Colin,

This is an old feature request and it's not implemented yet, you can see it and add your vote at https://jira.atlassian.com/browse/JRA-13191

Also, you might be able to customize the project screen by editing the SummaryProjectTabPanel.class file. This is where the individual column fragments are created. You can find more details here.

I hope this helps

Cheers

[kyjeon@ea.com]

Hi, I reached to both JIRA-13191 and 'here' links but couldn't find any information.

Could anyone help me on this issue?

I would like to create dashboard to show users without assigned issues.

So group leader can figure out who isn't assigned any issue yet.

Thank you.

[Rene C. [Atlassian Support]]

I would say that the easiest way to get this is to dive in the database. You can use this query to obtain all the users and the number of issues assigned, including the ones with no issues assigned at all. From it you can work around it to shape to your needs:

SELECT au.lower_user_name Username, count(i.*) IssuesAssigned
FROM cwd_user u
INNER JOIN app_user au on au.lower_user_name = u.lower_user_name
LEFT JOIN jiraissue i on i.assignee = au.user_key
GROUP BY 1

[Madhu Mullangi]

Hi @Rene C. [Atlassian Support]

I have ran the above query and i haven't got the result.

Attached the screen shot for your reference.

Thankful, if you help me in getting the output.

[Rene C. [Atlassian Support]]

Hi  Madhu! I'm afraid that the query is not that complex and it should work in any 7+ version. The best advise I can give here is to break down the query and start looking at one table at the time, and verify if there is any table link that is not working for your case.

[Madhu_Mullangi]

@Rene C. [Atlassian Support]I have ran it in my db.

First line itself I am getting an error .Attached the screenshot. Please have a look.

[Rene C. [Atlassian Support]]

The query was written in PostgreSQL, so it seems there is a little syntax difference for MySQL, I think you can change the "count(i.*)" for "count(*)" and it will work in MySQL.