Incorrect results to similar query

[Meni Hillel]

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-]

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]

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