You are able to get it with the SQL for JIRA plugin.
select i.key from issues i inner join issuecustomfields cf on cf.issueid=i.id where jql='type=Epic' and cf.epic_name not in ( select distinct cf.epic_link from issues i inner join issuecustomfields cf on cf.issueid = i.id where jql=' "Epic Link" in sql("select key from issues where jql=''type=Epic'' ") ' )
I've tried it on my testing environment and it worked fine
See how to use Jira on the go! Demo Den Episode 5 is here: meet Jira Mobile with Jira Product Manager Rayen Magpantay. Demo Den is in our monthly series where a Jira PM demonstrates...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events