Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

How to exclude a set of tickets from a filter

Currently, I am getting a list of issues with this JQL:

 

project = "id" AND issuetype = Bug AND status in ("Code Review", "In Progress", "In Review", "Product Review", "Re Open", "To Do") AND "SLA Deadline" <= 0d

 

But, this gives me a few tickets that I don't consider part of my result set (old issues, or issues that are not prioritized).

 

Lets say, I have a list of issues like: DTM-57454, DTM-8745, DTM-7854 etc.

 

How can I write the query to exclude these issues from the result set?

 

2 answers

2 accepted

0 votes
Answer accepted

If you know the issue keys to exclude and don't want to add labels to the issues, you can just:

project = "id" AND issuetype = Bug AND status in ("Code Review", "In Progress", "In Review", "Product Review", "Re Open", "To Do") AND "SLA Deadline" <= 0d AND key NOT IN (DTM-57454, DTM-8745, DTM-7854)

Don't want to pollute the label space either so this is fantastic.

0 votes
Answer accepted

Figured out that I can simply attach a label to those tickets and then append: 

 

AND labels != YOURLABEL

 

Manual, but works out.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you