How to write query to find assignee who have less one issue?

[Temur Khalilov]

I want to make some schedule notification with automation, I cant write query - how to find assignee who have less 1 issue

[Nic Brough -Adaptavist- · Accepted solution]

You cannot search for things that are not there.  The best you can do is search for something that is there, and infer a negative from the results.

If you were to search for simply "assignee is not empty", save the filter and then use it in a dashboard gadget that groups by assignee, you'll get a list of people with assigned issues, and the numbers.  (I'd refine that, you probably want to exclude resolved issues and limit it to a couple of projects, as the gadgets will not list more than 50 users)

If your user is not named in that list, you know they have zero assignments.

Similarly, run a filter for "assignee = user", and if you get no results, you have an answer.

[Alex Koxaras _Relational_]

Hi @Temur Khalilov 

You can't write such a query out of the box. JQL will bring you only issues. Not assignees or any other variable.

[Tom Zhu]

Hi @Temur Khalilov 

Here is similar question JQL: Can I list users who don't have any issues assigned to them?   ,  you can try to query it by 2 dimensional filter gadget.

Tom Zhu

[Temur Khalilov]

Okey i saw this, can i write query to see assignee with less 2 issues.