How to exclude a set of tickets from a filter

[Saquif]

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?

[Aron Gombas _Midori_ · Accepted solution]

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)

[Saquif]

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

[Saquif · Accepted solution]

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

AND labels != YOURLABEL

Manual, but works out.

[Serhii Kibitkin_SAASJet_]

Hello Saquif

How about creating JQL visually with help of Dynamic Filters: JQL Replacer?

in this case, your JQL query will look like this set of filters: