Combining two jql queries

Question

Hello Team,

Any suggestions on below JQL ?

JQL query 1 :

project = md AND issuetype in (Bug, “Change Request”) AND status not in (Closed, “Additional Requestor Information”, “Waiting For Release Management”, “Release Management In Process”, “Regression Testing In Process”, “Waiting on Dependency”) AND (BA is not EMPTY OR SE is not EMPTY OR QE is not EMPTY) AND cf[10206] != “Data Engine” AND resolution = Unresolved

Result is 115 tickets

JQL query 2 :

project = MD AND issuetype in (Bug, “Change Request”) AND (labels in (APAC-PSTC) OR component in (form-calculation, form-network-sourcing, single-qual, multiple-qual, extra-records, “Future Batch”))

Result is 15 tickets

When I combine them it cuts down to 62 tickets, but should really be 100 tickets (115 - 15) : 100.

Here is the combined query I was trying: Trying to add "not in" in both components and labels. There is "in" second query, when combing both adding "not in"

project = md AND issuetype in (Bug, “Change Request”) AND status not in (Closed, “Additional Requestor Information”, “Waiting For Release Management”, “Release Management In Process”, “Regression Testing In Process”, “Waiting on Dependency”) AND (labels not in (APAC-PSTC) OR component not in (form-calculation, form-network-sourcing, single-qual, multiple-qual, extra-records, “Future Batch”)) AND (BA is not EMPTY OR SE is not EMPTY OR QE is not EMPTY) AND cf[10206] != “Data Engine” AND resolution = Unresolved

Gustavo Félix_5ziaxu · Answer

Something that I just saw is that empty labels or empty components dont show when you do the "not in" .

I had 40 issues without components, 1 with label 'A' and 1 with label 'B'. 
If I execute labels not in A, the number of issues is 1.

Can you check if you have a similar case?

jira_admin_cu · Answer

Hi @Gustavo Félix ,

First query : 116

Second query : 41

but the combined query is not giving 116 -41 = 75. it reducing to 55.

I am really sorry for giving the mathematical calculations.   I don’t fully understand that. I know it’s combining with the ‘status not in’ piece but I still don’t understand why that greatly reduces the # of tickets.

---------------

and trying with this also

(project = md AND issuetype in (Bug, "Change Request") AND status not in (Closed, "Additional Requestor Information", "Waiting For Release Management", "Release Management In Process", "Regression Testing In Process", "Waiting on Dependency") AND (BA is not EMPTY OR SE is not EMPTY OR QE is not EMPTY) AND cf[10206] != "Data Engine" AND resolution = Unresolved) AND NOT filter = query2

---------

tried this also, saved the first filter with query1 and second with query2.

filter in (query1) AND NOT filter in (query2)

Gustavo Félix_5ziaxu · Answer

Hi @jira_admin_cu 
Just for curiosity, how many tickets does the second query with a "not in" shows you?
Something like:

project = MD AND issuetype in (Bug, “Change Request”) AND (labels not in (APAC-PSTC) OR component not in (form-calculation, form-network-sourcing, single-qual, multiple-qual, extra-records, “Future Batch”))