how to find epic without stories ?

[Kagithala Babu Anvesh]

We have a requirement , that have to show the epics which don't have stories in it.

[Jack Nolddor [Sweet Bananas] · Accepted solution]

Hello all,

What about to use JQL Booster Pack (FREE) and type the following?

type = Epic and issue not in epicsOf('"Epic Link" IS NOT EMPTY')

Regards

[Kagithala Babu Anvesh]

Hi , will check and update to you

[Kagithala Babu Anvesh]

Thank you @Jack Nolddor [Sweet Bananas]  . it's working fine. Thank you So much

[Mohamed Benziane · Accepted solution]

Hello,

It seems that it's not possible without a paid plugin like scriptrunner.

If you have this plugin you can use this :

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

Hope this helps 

[Kagithala Babu Anvesh]

hi  thanks for the reply.

any other option without going for a plugin 

[Deleted user]

I don't find anything, what is the problem here?

[Kagithala Babu Anvesh]

Do you have script runner add-on in jira

[Mohamed Benziane]

You need the scriptrunner plugin to use this jql syntax

[Deleted user]

Yes, I have the scriptrunner plugin installed.

[Mohamed Benziane]

Hello Ulrika,

You're looking for epic without stories ? If so please try this :

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

[Deleted user]

No difference, same result. Could not find linktype.

[Mohamed Benziane]

Ok i think i found the issue. you have a duplicate issuetype name.

You have Epic-Story Link in double. You can check in this page 

JIRA-URL/secure/admin/ViewLinkTypes!default.jspa

You need to change the name of one of them

Hope this helps