JIRA Filtering: Can I report zeroes or project members without assignments?

[j_belousek]

So I'm trying to create a query that will show me who doesn't have anything assigned to them but the JQL is eluding me. Another acceptable answer would be a filter that displays EVERYONE in the project and their number of assignments including zeroes?

Specifically, I'm trying to get this into a gadget.

[Deleted user]

Can you try the "workload pie chart"? It will kinda help you.

[Nicolas Bourdages]

Well, a JQL query will always return you issues, not people.

That sounds like a job for Excel .

OR

for a SQL query straight from the database. Which you would set in a datatable custom field, using the database custom field plugin

Not sure what gadget could display that on your dashboard though, but you'd be a good way along. Hope you're using Server and not Cloud!

Good luck!

[j_belousek]

Currently, I am handling this process through Excel: Column 1 = Roster, Column 2 = JQL query results of assignees within the project. Which is a process that needs to be maintained and creates room for error. Thanks for the link and the SQL suggestion!