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

JQL filter: "get stuff" and labels not in (XXX) also filters "EMPTY"

Yokai-FTW

I have a query that is something like this:

project in (X, Y) AND component in (A,B,C,...) AND labels not in ("stuff")

This filter returns less than expected. It filters the things with label "stuff", but also filters things with label = "EMPTY"

We fixed by changing the label stuff to: (labels != "stuff" OR labels is EMPTY)

However, it doesn't make sense to me that things without a label need to be specifically selected since "EMPTY" should not equate to "not stuff".

Am I missing something or is this a bug (or a feature)?

Accepted answers

Mikael Sandberg

This is expected behavior. When you are searching on label != X it will only search on issues that have the labels set to something, and that is why you have to include labels is EMPTY as well. Same thing if you would have a search that excludes a component, you would then have to include the empty ones as well.

All comments

Mikael Sandberg

Yokai-FTW

OK, expected maybe, but weird IMHO. Thanks!

Nic Brough -Adaptavist-

It's not weird, it's logical. Computers are logical engines, you have to be precise with them. Humans are not, we can make assumptions!

Yokai-FTW

We agree on the end of your statement, but not the beginning. Computers are not so much logical as logic engines that have actions programmed by humans based on requirements. In this case, it's a database engine with a rudimentary programming language, JQL.

To illustrate my expectations, here's how I think of the problem: If I have a set of 10 marbles, some are swirled with the color blue, some red, and some just clear. If I ask you to "please give me all the marbles that are not blue", I'd expect you to give me the clear and red marbles, not just the red marbles.

However, I can also see how the programmer might have thought differently. Perhaps their design grabs all the things with labels and then returns the ones without the label I don't want. That might have been the requirement they worked to or it's a bug (I favor the latter).

Anyway, if I assume the former requirement, then it explains the results.

Keith Robertson_v7t0ep

Instead of

labels != stuff

labels not in (stuff, the_void)

use

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

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

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

These avoid having to check whether labels IS EMPTY.

Note: labels != stuff excludes when labels IS EMPTY, but NOT (labels = stuff) includes it!

Scott Hajek

I just tested it in my Jira instance, and `NOT (labels = stuff)` does actually exclude issues where labels is EMPTY. Seems like the only way is to do an OR, like `(labels!=stuff OR 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

server

jira

jira-server

label