Issue with JQL query

[priym]

Hi Team,

We are using one JQL query which is not giving correct result. This is the JQL

project = QSAUDIT AND issuetype = QSAudit AND "Planned Quarter" in (2022-Q1, 2022-Q2, 2022-Q3, 2022-Q4, 2023-Q1, 2020-Q1, 2023-Q2) AND status not in ("Audit Cancelled") AND Locations ~ Jakarta OR Locations ~ Bangkok AND Functions = "Platform Foundation [Platform Foundation]" AND "Org/Customer" = "HERE (Internal Audit)"

But query is returned incorrect result which included other functions ticket as well. I am attaching snap for reference

[Frederik Vantroys · Accepted solution]

Hi @priym , 

Maybe the OR statement needs to be with (   ) to make the query work.

Try :

project = QSAUDIT AND issuetype = QSAudit AND "Planned Quarter" in (2022-Q1, 2022-Q2, 2022-Q3, 2022-Q4, 2023-Q1, 2020-Q1, 2023-Q2) AND status not in ("Audit Cancelled") AND (Locations ~ Jakarta OR Locations ~ Bangkok) AND Functions = "Platform Foundation [Platform Foundation]" AND "Org/Customer" = "HERE (Internal Audit)"

[priym]

Hi @Frederik Vantroys ,

Thank you! It is working now.