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

SOLVED!! Issues Filter Exclude Issues with certain Label

Nicole Lubanowski

Update - after posting this question, more suggestions appeared and one of them was just the 'ticket' - https://community.atlassian.com/t5/Jira-Core-questions/JQL-excluding-label-while-keeping-empty-label-issues-in-filter/qaq-p/1220794

Hello! I just completed an issues import via csv. My project is managing two boards - a scrum for one product and a kanban for support and other products. The kanban board is new, and the one for which I imported the issues from an external tool. The imported issues currently have no labels, but all the existing scrum issues do - 'Rewrite'. I'm trying to build the JQL for the Kanban board.

When I run this JQL, I get none of my imported issues: project = "Advisory Products and Trading Apps" AND labels not in ('Rewrite')

and when I run this JQL, I get all of my imported issues: project = "Advisory Products and Trading Apps" AND labels is EMPTY

I'm asking this because the issues may at some point have a label, but regardless of that label, I still care to only exclude the 'Rewrite' label and don't want to have to maintain a JQL that includes all possibilities of labels for the Kanban board - the exclusion of the Scrum issues is easier.

Accepted answers

jeremiah_landi

To copy that answer over:

"project = TT AND (labels is EMPTY OR labels not in (label1, label2)) ORDER BY status ASC"

Sauce which is linked above.

All comments

Brant Schroeder

@Nicole Lubanowski - Thanks for posting the solution.

Dave Mathijs

@Nicole Lubanowski This question helped me solve a similar request, thank you!

jeremiah_landi

To copy that answer over:

"project = TT AND (labels is EMPTY OR labels not in (label1, label2)) ORDER BY status ASC"

Sauce which is linked above.

Andrii Piatnytskyi_u2yxvg

Many thanks, it helped!

Pranav Parab

Thanks, this worked exactly how I wanted

Jan Magne Viko_1hpam9

This helped me solve a similar problem, where after migration our Queue from onprem to cloud, that was filtering out a specific label would only work on migrated tickets, not new ones coming in, in the cloud i had to add showing empty labels in addition to filtering out tickets with specific label. on onprem, you only had to filter out the specific label in the query.

So you could say this was made more complicated in cloud.

resolution = Unresolved AND (labels is EMPTY OR labels != labeltofilterout) AND assignee in (EMPTY) ORDER BY key DESC, cf[10052] DESC, "Time to resolution" DESC

That was the query that worked for me when i want a custom queue that shows unassigned cases that has not been given one specific label.

If you have any automation that adds labels on ticket creation, you would probably have to add those labels in the query as ones to show in addition to the empty ones.

This feels a bit like a bug. You should be able to do it like onprem as below. it would be much simpler.

resolution = Unresolved AND labels != labeltofilterout AND assignee in (EMPTY) ORDER BY key DESC, cf[10052] DESC, "Time to resolution" DESC

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

atl-gruland

label