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, jira product discovery, jpd premium, product management, idea management, product discovery, jira premium, product planning, atlassian community, product development, roadmap planning, product prioritization, feature management

Introducing Jira Product Discovery Premium ✨

Jira Product Discovery Premium is now available! Get more visibility, control, and support to build products at scale.

Learn more
AUG Leaders

Atlassian Community Events