Filter Epics with no issues

Bryony Youngs1

How can I create a filter to show all the Epics which have no child issues?

Contact Kintosoft

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