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))
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.