How can I search for a null value?

Ryan Eames (Admin)

As the subject states, I would like to search for tickets that have a null value in a particular field.  For example, I want to find all tickets that have no labels, or no fix version, etc.

 

In the particular case I was using it, I have a search that will find all tickets without 3 specific labels, but when it returns a result, it is basically every other ticket that has a label, just not those three.  This is only partially correct in the result I want, but I also need to see all the tickets that have no label to make my result truely complete.

Nic Brough -Adaptavist-

For a simple null value in a field, try

• labels is empty
• fix version is empty

and so-on.

The question about "not label" is a bit more of a faff, because of the way humans tend not to be precise in their logic.  "Label is not X" does not mean the same as "label is empty", it means "there is a label on the issue, but it is not X"

When you are looking for your issues that do not have 3 specific label, you need to say "Label not in ( x, y, z ) or label is empty"