nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Accepted answers

Tiago Comasseto

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

All comments

Tiago Comasseto

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

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_nqfyjl

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.

Query result in DB.PNG

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.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

user