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; } } }

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

Accepted answers

John Funk

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

Jose Luis Gaitan

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

All comments

John Funk

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

Jose Luis Gaitan

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

Whitney Bell

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

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

thanks to you and I hope you enjoy our Community.

Keith Robertson_v7t0ep

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.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud

jql