Advanced Searching - Left outer join?

[Teressa Reed]

I need to create a left outer join query that pulls all epics and service requests - regardless of whether linked issues exist - and include any issuelinktype = blockers that do exist. 

Is this possible through issue search?

[Nic Brough -Adaptavist-]

JQL is not SQL and it does not need joins as it sees every issue as a blob of data, as though there were only one table.

To get all the Epics and Service requests, you can use almost exactly what you've said -

issuetype in (Epic, "Service Request")

I'm not sure whether you mean you want the issues on the other end of a link, or just to be told that there is a link of type blocker.  JQL returns issues when you search though.