Retrieve Combined Result of Multiple JQL statemnts

Question

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))

Tansu Akdeniz · Accepted Answer

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

Aron Gombas _Midori_ · Accepted Answer

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