How do I create JQL filter that excludes certain values in a field, but includes "blank" values?

Question

Trying to create a JQL query that excludes specific values in a field.  When the query runs, it also excludes records with "none" in the field.  These should be included in the query result, since the field is not required, so sometimes not populated.

Query Excerpt:     AND labels not in ("workflow", "report")

Results exclude any record with "workflow" or "report" in the label, but also excludes records where label = [none]

John Funk · Accepted Answer

Hi Mandy - try adding something on the end like:

OR labels is empty

AND labels not in ("workflow", "report") OR labels is empty

Kristján Geir Mathiesen · Accepted Answer

Hi @Mandy Ernst

AND labels not in ("workflow", "report") OR labels is null

These empty/null values can be tricky...

HTH,
KGM