How can I compare the difference between 2 filters.

[Thomas Fritzen]

in JQL I have Filter 1 with 630 results.  I make a change to the filter to create a new filter 2.  This filter produces 530 results.  How can see what the difference are?  

thomas 

[Jack Brickey · Accepted solution]

I suspect you would want to creat a third JQL that show the delta.

If you could share your filters I might be able to offer an exact solution.

[Thomas Fritzen]

This is the first.  

project = FD AND issuetype in (Bug, Defect) AND created >= 2021-01-01 AND created <= 2021-12-31 ORDER BY created DESC

This bring back 632

project = FD AND issuetype in (Bug, Defect) AND created >= 2021-01-01 AND created <= 2021-12-31 AND labels != ETL ORDER BY created DESC 

Brings back 532 and I know there is not 100 marked with ETL.  

Thomas 

[Jack Brickey]

Please note that your second filter will return any issues where the labels field is empty as well. Maybe you want your second filter to look like  below?

project = FD AND issuetype in (Bug, Defect) AND created >= 2021-01-01 AND created <= 2021-12-31 AND (labels != ETL OR labels is not Empty) ORDER BY created DESC 

[Thomas Fritzen]

Your query brings back the same amount as my first query.  632.  I am trying to show how many bugs we found in Production but some that are labeled with ETL are not true bugs so I want them pulled out to show a lower number. 

Thomas 

[Jack Brickey]

What does this yield…

project = FD AND issuetype in (Bug, Defect) AND created >= 2021-01-01 AND created <= 2021-12-31 AND labels = ETL

then this one…

project = FD AND issuetype in (Bug, Defect) AND created >= 2021-01-01 AND created <= 2021-12-31 AND labels is empty

[Thomas Fritzen]

Thanks that worked.