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 to exclude specific labels? 🙏

Kollgaard, Nicholas

Hi,

I have the following query and wish to add a filter to exclude 2x specific labels from the view.

Let's call the two labels "label1" and "label2".

So I want the query to return all issues that match the rest of the query, including EMPTY, but EXCLUDING ANY issues assigned either "label1" and "label2"

This is my query so far:

project IN ("Project X") AND type IN (Task,Story) AND status IN ("To Be Refined","In Refine") AND component in ("Launchpad") ORDER BY Rank

Any ideas?

Thanks,

Accepted answers

David Blank

HI @Kollgaard, Nicholas !

Could the following work?

labels NOT IN (label1, label2)

Like:

project IN ("Project X") AND type IN (Task,Story) AND status IN ("To Be Refined","In Refine") AND component in ("Launchpad") AND labels NOT IN (label1, label2) ORDER BY Rank

All comments

David Blank

HI @Kollgaard, Nicholas !

Could the following work?

labels NOT IN (label1, label2)

Like:

project IN ("Project X") AND type IN (Task,Story) AND status IN ("To Be Refined","In Refine") AND component in ("Launchpad") AND labels NOT IN (label1, label2) ORDER BY Rank

Kollgaard, Nicholas

HI @David Blank - Thanks for your suggestion, but unfortunately, no such luck.

Here's my query after adjusting it to consider your suggestion:

project in ("Project1") AND type in (Task, Story) AND status in ("To Be Refined", "In Refine") AND component in (Launchpad) AND labels NOT IN (Label1, Label2) ORDER BY Rank

The query seems to be successfully excluding "label1" and "label2", however, it is ignoring (i.e. not returning) issues where the label field is empty...

In other words, the query is only returning issues that have labels, where the labels are not "label1" or "label2"..

David Blank

Hi @Kollgaard, Nicholas could you try adding: OR labels IS EMPTY?

You will want to put both of your labels filters in parenthesis I think if you do it that way.

Like:

project in ("Project1") AND type in (Task, Story) AND status in ("To Be Refined", "In Refine") AND component in (Launchpad) AND (labels NOT IN (Label1, Label2) OR labels IS EMPTY) ORDER BY Rank

Kollgaard, Nicholas

Nailed it! Thank you so much!!

Welcome!

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

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud