Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,367,095
Community Members
 
Community Events
168
Community Groups

How to filter epics without stories by using JQL?

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

2 answers

5 votes

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

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

Like Jay Smith likes this
Ganesh Babu Community Leader Jan 27, 2020

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

This worked perfect, thank you!!

 

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

Like Ganesh Babu likes this
Ganesh Babu Community Leader Jul 09, 2020

Hi @Shaun Rucker 

cool...!!!

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

@Raj Reddy 

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

3 votes

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:

 

References:

 

Hope this helps you to create awesome queries <3

Kind regards

Suggest an answer

Log in or Sign up to answer
TAGS

Atlassian Community Events