Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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

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.

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

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
Community showcase
Published in Jira

Admins, notify your Jira instance of system-wide changes with the new admin announcement banner

Hi All! We’re excited to share the launch of an announcement banner that lets Jira site administrators communicate directly to their users across their  Jira Cloud instance.  ...

528 views 15 17
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you