Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root


1 badge earned


Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!


Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.


Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!


Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

NOT in Filter Criteria

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`


2 answers

1 accepted

0 votes
Answer accepted
Hermance NDounga
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
May 03, 2023

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

♥️ Thanks for adding it to the wishlist!

1 vote
Bill Sheboy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
May 02, 2023

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:

Kind regards,

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.

Like Bill Sheboy likes this

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).

Like Hermance NDounga likes this

Suggest an answer

Log in or Sign up to answer
AUG Leaders

Atlassian Community Events