Epics without ISSUES IN EPIC

[Fabio Al-barrak]

Hi,

I am trying to set up a filter to identify EPICS that have no issues listed in the section named ISSUES IN EPICS. I usually have issues under type ACTION listed within each EPIC Issue.

I tried the following which worked at the beginning but all of the sudden it started giving 100s of EPICS that do have ACTIONS in them.

project = "ABC" AND reporter = currentUser() AND type = Epic AND (issueFunction not in epicsOf("type in (action)") )

Thanks.

[Craig Nodwell]

Hi @Fabio Al-barrak you can go with 
parent is EMPTY

[carlosughini]

Hi Fabio,

It's not possible to do this without an plugin.

If you have the paid plugin Script runner installed then you can easily do it.

issuetype = Epic and issueFunction not in hasLinkType("Epic-Story Link")

the above JQL will give you all epics in the system which don't have a child story.

Kind regards,

Carlos