How can I build a query/filter listing all users & issues assigned per user?

[philippos]

I want a filter which totals all issues assigned per user.

Is this possible?

Thanks.

[Renjith Pillai · Accepted solution]

Use the issue statistics gadget with assignee as the statistics in a dashboard

[C_ Faysal]

yep thats what i suggest too

[C_ Faysal]

sorry didn't read cleary....so i deleted my answer

seems like you're looking for a SQL like query where to use "group"

that's not possible in JQL.

some plugins will help

[ConradR]

JQL:

assignee = username

[C_ Faysal]

yeah that was my first thought too...but he needs a listing of all users & their assigned issues

[ConradR]

Oh, ok. You/OP could save the the following as a filter and use it in the two dimensional filter statistics gadget:

assignee in membersOf(jira-users)

[ConradR]

Hm, thats right. ;)

[C_ Faysal]

that kinda equals

assignee is not EMPTY

still no grouping there :)

[C_ Faysal]

assignee = <username>

is not working?