JQL Filter to find Epics that have no Issues (i.e. empty Epics)

Hi, 

I'd like to know how I can use a JQL query to collect Epics which do not yet have any issues linked to them. 

It seems that I can find issues which have links out to an Epic, but not necessarily the other way round. 

I'm looking for something like:

IssueType = Epic AND HasChildren = No

Please help?

Thanks, 

Glyn

3 answers

This widget could not be displayed.

Hi @Jennifer McVicker

If you are on a Server JIRA you can use the add-on ScriptRunner for JIRA from Adaptavist, to easily create queries around Epics:

issueFunction in hasLinks("is Epic of") - to show all epics that has stories defined

issueFunction not in hasLinks("is Epic of") - well, to show all epics that has no stories defined

Cheers

Hi, I'm aware it can be done with script runner, however it is not part of our installation. Based on the responses I thinking that there's no JQL query that can handle this kind of request...

Awesome!  We do have ScriptRunner installed on our Server instance.  I'll check that out.  Thanks Emanuel!

Is there a way to hide epics without any associated stories given the currently applied quick filters?  That query hides ONLY those epics without ANY associated stories.

I haven't been able to get that to work, @Matt Boerner.  I tried adding this to the end of my quickfilter: 

AND (issuetype != Epic OR issueFunction in linkedIssuesOf("[my quick filter here]", "is epic of"))

But that didn't work.  :(

@Jennifer McVickerdid you get that to work? I can't get it to work :-(

This widget could not be displayed.

"Epic Link" is EMPTY for issues *NOT* linked to an epic

"Epic Link" is not EMPTY for issues linked to an epic

Hi, this doesn't really answer the question. Your first query will show my issues without an epic link. I am trying to find Epics with no stories in them.

I'm looking for this as well finding jQL to find Empty Epics to clean up Agile Board view of epics that are no longer needed and to provide easily readable list to Lead to review before closing.   

This widget could not be displayed.

I'm looking for the answer to this too...or rather, the reverse.  I have created a board that pulls stories and epics from multiple projects, and I want to ONLY pull in epics that contain one or more stories that display on my board.  For instance, an epic may have three stories but those three stories are filtered out by my board filter, so the epic shows up on the backlog screen, but contains no stories on my board.

Suggest an answer

Log in or Sign up to answer
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Posted Wednesday in New to Jira

Are you planning to trial, or are currently trialling Jira Software? - We want to talk to you!

Hello! I'm Rayen, a product manager at Atlassian. My team and I are working hard to improve the trial experience for Jira Software Cloud. We are interested in   talking to 20 people planning t...

262 views 5 0
Join discussion

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you