NOT in Filter Criteria

[Pete Crocker]

Hey JPD team and community, is there a way to do a NOT filter in a list? For example, I want to show all ideas that don't have a specific label assigned to them:

• Status = `123`
• Label DOES NOT INCLUDE `XYZ`

Thanks!

[Hermance NDounga · Accepted solution]

Hi Pete! The answer from Bill is the best to achieve this at the moment - unfortunately the NOT operator cannot be expressed in the JPD UI at the moment ... but we are planning to improve it so you won't need to switch to the advance search to do such filtering ;) 

[Pete Crocker]

♥️ Thanks for adding it to the wishlist!

[Bill Sheboy]

Hi @Pete Crocker 

Yes, there is...If you want to check for EMPTY or not "XYZ" you could use this:

project = myProjectName AND ( labels IS EMPTY OR labels NOT IN (XYZ) )

If you want there to always be a label, and just not XYZ, you could use this:

project = myProjectName AND labels IS NOT EMPTY AND labels NOT IN (XYZ)

To learn more about JQL for queries like this, please look here: https://support.atlassian.com/jira-software-cloud/docs/use-advanced-search-with-jira-query-language-jql/

Kind regards,
Bill

[Pete Crocker]

Thanks @Bill Sheboy Ah! Don't ask me why I didn't just do a JQL query for it.... I was trying to stay in the JPD UI framework since it's a great view of the data when I'm running through lists on calls with the team. 

So for @Tanguy Crusson minor feature request to add to the list: allow NOT options in the JPD UI filter criteria, though I've got an easy workaround via JQL.

[Pete Crocker]

Also figured out I can't sort a JQL query on JPD Score, so another reason it would be handy in JPD UI (or I could ORDER BY "Score" in JQL).