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.
Can you try the "workload pie chart"? It will kinda help you.
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!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.