Forums

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

Retrieve Combined Result of Multiple JQL statemnts

Abdur Siddiqui
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!
February 8, 2024

I have 2 JQL queries, how can I get the combined result of both JQL queries ?

JQL Query 1: ((Project in (OSHD,COHD) AND (issuetype in ("RevOps - Existing Business Management Fee Changes","RevOps - Deal Desk Requests")))) order by created desc

 

JQL Query 2: ((project = "Global Mobility" and "GM: Primary Applicant Fee Quoted[Number]" != 0 and "GM: Primary Applicant Fee - Invoice issued[Date]" is empty))

2 answers

2 accepted

1 vote
Answer accepted
Aron Gombas _Midori_
Community Champion
February 8, 2024

You can use the OR operator, of course, but please note that the ORDER BY clause should appear at the end of the query!

Something like this:

((Project in (OSHD,COHD) AND (issuetype in ("RevOps - Existing Business Management Fee Changes","RevOps - Deal Desk Requests")))) OR ((project = "Global Mobility" and "GM: Primary Applicant Fee Quoted[Number]" != 0 and "GM: Primary Applicant Fee - Invoice issued[Date]" is empty)) order by created desc

 

1 vote
Answer accepted
Tansu Akdeniz
Community Champion
February 8, 2024

Hi @Abdur Siddiqui 

Welcome to the community.

Just use OR between two queries.

Please note that order by created desc needs to cover both queries.

Sample: ((Project in (OSHD,COHD) AND (issuetype in ("RevOps - Existing Business Management Fee Changes","RevOps - Deal Desk Requests")))) or ((project = "Global Mobility" and "GM: Primary Applicant Fee Quoted[Number]" != 0 and "GM: Primary Applicant Fee - Invoice issued[Date]" is empty)) order by created desc

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
TAGS
AUG Leaders

Atlassian Community Events