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