How to filter epics without stories by using JQL?

[Muskan Shaikh]

I want Epics which don't have any story attached.

[Ganesh Babu · Accepted solution]

Hi @Muskan Shaikh 

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

or

project = X and issuetype = Epic and issueFunction not in epicsOf("project = X")

issuefunction is something that might be available with scriptrunner plugin and you might need a scriptrunner plugin to achieve this

[Muskan Shaikh]

it shows like: Field 'issueFunction' does not exist or you do not have permission to view it.

[Ganesh Babu]

Yea issueFunction is available only with scriptrunner plugin.

so you might need that in order to achieve this.

I am not sure how to search with plain jira

[Muskan Shaikh]

Ok Thanks!

[Shaun Rucker]

This worked perfect, thank you!!

 issuetype = Epic and issueFunction not in epicsOf("project = X") 

[Ganesh Babu]

Hi @Shaun Rucker 

cool...!!!

[Raj Reddy]

What if I have 2 projects like Project =X  and Y.

appreciate your help.

im looking for features which donot have stories in projects X , Y And Z

[Krasimir BOEV]

@Raj Reddy 

 issuetype = Epic and issueFunction not in epicsOf("project in (X,Y)") 

[Jack Nolddor [Sweet Bananas]]

Hi Muskan,

Sadly you cannot achieve the desired search using standard features on Jira, you must go for a third-party app instead. Using i.e. JQL Booster Pack you can type the following:

Search all Epics without Stories

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

Using this app you can also query other issues relations, check:

• epicsOf()
• hasSubtasks()
• issuesInEpics()
• linkedIssuesOf()
• parentsOf()
• portfolioChildOf()
• portfolioParentOf()
• subtasksOf()

References:

• Official documentation

Hope this helps you to create awesome queries <3

Kind regards