nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to find epics with no stories

Cassandra Chan

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?

Accepted answers

Vijay Khacharia

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.

All comments

Vijay Khacharia

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.

unknown

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

unknown

Is there a way to do this in Atlassian Cloud.

Regards

Ron

Adeel Nazir_jpslj7

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

Adeel Nazir_jpslj7

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")

Inactive Stephen

This also works I think for a shorter query:

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

John Drury

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

Inactive Stephen

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

Raj Reddy_68bgwb

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.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

jira-development

adaptavist