How to see which Deliverables don't have an Epic attached to them?

[Sofie Palacios]

Like the title says. I'm trying query for all deliverables that don't have an Epic underneath them. It looks like Jira counts Open Epics as the deliverable not having an Epic? I tried to filter those out, but I'm still being shown deliverables with open Epics. This is what my query looks like. 

issuetype = Deliverable AND status = "Ready for Dev" AND ("Epic Link" is EMPTY OR ("Epic Link" is not EMPTY AND status != Open))

Any help would be very appreciated! 

[Laurie Sciutti]

Hi @Sofie Palacios ~ try this:

issuetype = Deliverable AND status = "Ready for Dev" AND NOT issueFunction in portfolioParentsOf("issuetype = Epic")