Can I search two project groups

Adrian Papahatzis March 19, 2017

The below is what I have so far - I am trying to look for all Lease renewals (in LGMT project) that have linked inspections (in INSP Project) that are required?

(project = LMGT AND issuetype = "Lease Renewal" AND status = "Awaiting CIC Inspection"  AND HMC in (NOWRA, SYDNEY) AND "Lease Expiry Date" <= 365d) AND (project = INSP AND issuetype = Inspection AND HMC in (NOWRA, SYDNEY) AND "Inspection Process" = PCC AND "PCC Type" = "Lease Renewal" AND status = "Inspection Required")

 

 

1 answer

0 votes
Niclas Sandstroem
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 19, 2017

You will not be able to do a join like in SQL. With links I assume your talking about issue links and if these exists you could evaluate plugins that would make it possible for you utilize more advanced JQL functions.

Example,

https://scriptrunner.adaptavist.com/latest/jira/

https://scriptrunner.adaptavist.com/latest/jira/jql-functions.html#_issue_links

Br, Niclas

Suggest an answer

Log in or Sign up to answer