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,365,175
Community Members
 
Community Events
168
Community Groups

How to find epics with no stories

I'm not sure if it is possible to have an epic without any associated stories. In order to prove if this is true or not, I am trying to write a query using built-in jql functions as well as the Scriptrunner plugin.

Can epics exist with no stories? If so, has anyone already tried to implement this?

4 answers

1 accepted

7 votes
Answer accepted

Hi,

It is possible to have epics without stories associated. We have scenarios like this and it can be made visible using below JQL.

issueFunction not in linkedIssuesOf("project = eai and type = story", "has Epic") and project = eai and type = epic

I use script runner issuefunction to get the epics that does not have a link to epic and then filter the epics for that project.

Regards,

Vijay.

above JQL is not 100% correct. it works on some EPICs. i don't know why

Following JQL works:

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

Like IT Platforms likes this
Ste Community Leader Mar 07, 2019

This also works I think for a shorter query:

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

Like IT Platforms likes this

Hi,

how will I rephrase the above if I have more than one project . For example if I have Project=X, Y

 

appreciate your help.

Ste Community Leader Sep 09, 2021 • edited

Hi @Raj Reddy 

You can change the operator to accomodate this - "=" is for one project, whilst "IN" is for multiple. 

So for example...

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

Ste

Thank you Ste. It works.

Like Ste likes this
5 votes
Deleted user Oct 21, 2015

Is there a way to do this without the script runner plugin?

3 votes
Deleted user Feb 04, 2016

Is there a way to do this in Atlassian Cloud.

Regards

Ron

project = XXX and issuetype = Story and "Epic Link" is EMPTY

 

None of the others work; issueFunction and hasLinkType are not available in the cloud version

Like Abed Islam likes this
Ste Community Leader Mar 13, 2019

Are you sure John? I've got little experience with Scriptrunner in Cloud but it seems to suggest there is Scriptrunner Enhanced Search and JQL aliases to get around some of the limitations in Cloud.

These do have some issue link searches you can use.

The search above shows stories with no epic - not epics with no stories below them.

Ste

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

Suggest an answer

Log in or Sign up to answer
TAGS

Atlassian Community Events