Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

How Do I Filter Out a Custom Label

Jessica Cote March 10, 2021

I would like help on how to switch the below query to show  results That DO NOT have labels equal XYZ, the below shows the opposite.

 

I tried the IS NOT fuction which ofc didn't work. I am new to jira too.

 

project = CoolProject AND status = "In Review" AND "Labels[Labels]" = XYZ AND created >= -10w ORDER BY created DESC

1 answer

1 accepted

2 votes
Answer accepted
Trudy Claspill
Community Champion
March 10, 2021

Hello @Jessica Cote 

Welcome to the community.

project = CoolProject AND status = "In Review" AND "Labels[Labels]" not in (XYZ) AND created >= -10w ORDER BY created DESC

If you also need to include issue where there may be no labels at all then...

project = CoolProject AND status = "In Review" AND ("Labels[Labels]" is empty or "Labels[Labels]" not in (XYZ)) AND created >= -10w ORDER BY created DESC

 And in case you have not seen it before, here is a reference for Advanced JQL Searching.

https://support.atlassian.com/jira-software-cloud/docs/advanced-search-reference-jql-functions/

Jessica Cote March 10, 2021

OOO thanks! 

Like • 2 people like this

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS
atlassian, loom, loom for training, loom for teaching, video training, async learning, online education, screen recording, loom tutorials, loom use cases, atlassian learning, team training tools, instructional video, virtual training tools

🛗 Elevate Your Training and Enablement with Loom

Join us June 26, 11am PT for a webinar with Atlassian Champion Robert Hean & Loom’s Brittany Soinski. Hear tips, stories, and get your burning questions answered. Learn how Loom makes training and enablement easier. Don’t miss it!

Register today
AUG Leaders

Atlassian Community Events