Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Fred Wass
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
August 11, 2019

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? 

2 answers

0 votes
Roman Kersky
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.
August 12, 2019

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

 

filter in ("filter2") and filter not in ("filter1")
0 votes
Ollie Guan
Community Champion
August 11, 2019

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)

TIM截图20190812121441.png

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events