How Do I Filter Out a Custom Label

[Jessica Cote]

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

[Trudy Claspill · Accepted solution]

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]

OOO thanks!