nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

!= to exclude values also excludes the empty value

Cosmin Moldoveanu

I am trying to create a JQL that excludes a value for a field, but I want the empty value as well for the same very field, how can I do this beside
(field != value or field = empty)

And why does it automatically exclude the empty values when I exclude only one value?

Accepted answers

Bill Sheboy

Hi @Cosmin Moldoveanu -- Welcome to the Atlassian Community!

Please consider trying IS EMPTY rather than = EMPTY?

Also, JQL is not really a SQL, ISO compliant variant. It has some common syntax elements but not all of them.

Best regards,

Bill

All comments

Bill Sheboy

Hi @Cosmin Moldoveanu -- Welcome to the Atlassian Community!

Please consider trying IS EMPTY rather than = EMPTY?

Also, JQL is not really a SQL, ISO compliant variant. It has some common syntax elements but not all of them.

Best regards,

Bill

Cosmin Moldoveanu

Hi Bill, thanks for your answer and time.

It is indeed working your way as well, no difference in the bug count when I try both = or IS.

I am still looking forward to understand why is this happening if someone can explain it.

Thanks in advance!

Bill Sheboy

Thanks for that info... Some fields behave differently with different JQL syntax. If you post your full JQL statement, perhaps that will help the community offer ideas.

__Bill

Cosmin Moldoveanu

What I was trying to look for initially was
labels not in (value1,value2)
and it would automatically exclude the tickets that were empty on this field, this is mainly my question, trying to understand why would it exclude the empty tickets when I excluded only two user input values.