Incorrect results to similar query

Question

Consider the following query:

assignee = currentUser() AND resolution = unresolved

And the following :

assignee = currentUser() AND resolution = unresolved AND Triage in (Untriaged, Triaged, EMPTY)

Where "Tirage" is a user defined field with three possible values (Untriaged, Triaged, EMPTY)

The two queries yields two different number of records !

Nic Brough -Adaptavist- · Answer

Welcome to the community!

Is your "empty" value here an option name (like untriaged and triaged) or do you mean the search command of empty?

If you are genuinely looking for an empty field (as opposoed to one containing a value called empty), then try

assignee = currentUser() AND resolution = unresolved AND (Triage in (Untriaged, Triaged) or Triage is empty)

Leo_e8op2r · Answer

Hi @Meni Hillel,

Welcome to Community!

Is "EMPTY" value for the field? or you are referring NULL value here?

if that is also an value, there might be issues with NULL values on this field. and the query can as follows

>>assignee = currentUser() AND resolution = unresolved AND (Triage in (Untriaged, Triaged, EMPTY) OR Triage is EMPTY)

Or even if you are referring NULL value, the above query will help you out

Hope this helps

BR,

Leo