Trying to write jql where results will show me tickets that are in one filter, but not another

Question

So, I have two filters that have some tickets that overlap.

I'm trying to build a jql that will only show me tickets that are in Filter #2, but not in Filter #1.

Example:

Let's assume Filter #1 has the following tickets:

PROJ-1

PROJ-2

PROJ-3

PROJ-4

Let's assume Filter #2 has the following tickets:

PROJ-1

PROJ-4

PROJ-6

PROJ-7

I want to write a jql that shows me the tickets from Filter #2 that are not in Filter #1.

In this case, the output of this query would just list:

PROJ-6

PROJ-7

Is there a way to write such a query?

Roman Kersky · Answer

Hi, you need to save filters and use this jql:

filter in ("filter2") and filter not in ("filter1")

Ollie Guan · Answer

Hi @Fred Wass ,

Like this one?

key not in (ong-1,ong-2,ong-3,ong-4) and key in (ong-1,ong-4,ong-5,ong-6)