Using != in JQL with Labels

[Whitney Bell]

I created a custom JQL query/filter to use with a Kanban. This appears to work in the sense that any issues with the label 'Workflows' does not show up on that board (or in the filter results), BUT, issues with NO label also do not show up on that board. How do I adjust my JQL so that issues with no label that are attached to the 'WMT' component will show on my WMT board. Query below: 

project = AZTB AND component = WMT AND labels != Workflows ORDER BY labels DESC, created DESC

[John Funk · Accepted solution]

Hi Whitney - Welcome to the Atlassian Community!

If that is working for you so far, try this:

project = AZTB AND component = WMT AND (labels != Workflows or labels is empty) ORDER BY labels DESC, created DESC

[John Funk]

Great! Glad that worked for you! Can you click on the Accept Answer button so we can close this out? Thanks!

[Jose Luis Gaitan · Accepted solution]

Hello, @Whitney Bell ;

If you want to show issues with no labels, you could try to probe something like that:

project = AZTB AND component = WMT AND (labels is EMPTY OR labels != Workflows ) ORDER BY labels DESC, created DESC

[Keith Robertson]

Instead of

labels != Workflows

labels not in (Workflows, API)

use

# Select ticket if missing the named label.
NOT (labels = Workflows)

# Select ticket if missing ANY of the named labels.
NOT (labels = Workflows AND labels = API)

# Select ticket only if missing ALL of the named labels.
NOT (labels in (Workflows, API))

These avoid having to check whether labels IS EMPTY.

[Whitney Bell]

You guys are the bomb.com - this worked! THANK YOU :) 

[Jose Luis Gaitan]

thanks to you and I hope you enjoy our Community.

:)