JQL for (component does not equal "" but includes all other components, as well as empty)

[Samantha]

I know that "!=" is the trigger for "not equal". However, in my instance, I want the JQL to reflect all tickets, except those that are populated with component A or B. So in essence. I want all tickets that are populated with any other component or tickets that do not have the component field populated to reflect.

[Nic Brough -Adaptavist- · Accepted solution]

Welcome to the Atlassian Community!

Yes, you need to account for empty fields.  Not equal to does not include empty fields (the logic, though it sounds wrong to humans, is correct - empty fields don't have anything to compare, so you can't equate "not equal to" with them)

Try

component not in (A,B) or component is empty

[Samantha]

Worked like a dream. Thank you.

[Dave Mathijs · Accepted solution]

Hi @Samantha welcome to the Atlassian Community!

Try the following JQL:

component != "A" OR component != "B" OR component is EMPTY

[Craig Nodwell · Accepted solution]

Hi @Samantha welcome to the community.

Try
component not in(A,B) OR component is EMPTY

[Nic Brough -Adaptavist-]

I think there's a spelling mistake in there?  "and" should be "or"?

With and, that query will never return any issues, because an issue's component needs to be empty AND have a value of not A or B at the same time.

[Craig Nodwell]

Agree, and it was an OR and then I edited my answer ... it's been one of those kinds of days ugghh