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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.