Parents Without Children

[adam.clifford3]

Hello,

I am looking for a filter / dashboard / report anything that allows me to find all epics without any children. 

Thanks Adam

[Trudy Claspill]

Hello @adam.clifford3 

There is not a native Jira issue filtering method for doing that.

You could create an Advanced Roadmap Plan that includes all the projects of concern as sources, and then you could visually assess the Epics list for Epics that have no expander icon - indicating they have no children.

Alternately you could create an Automation Rule to get a list of Epics and then add steps to check if they have child issues and send an email for the ones that do not.

Or you could consider a third party app that extends JQL filtering capabilities, such as ScriptRunner Enhanced search or GO!JQL:  Essential JQL Functions. You can find other apps that extend JQL capabilities here:

https://marketplace.atlassian.com/search?hosting=cloud&product=jira&query=jql

[adam.clifford3]

Hello Trudy,

Thanks for coming back
I have been using the advanced roadmap and it is long and painful.

I have also tried alternative filters in Script Runner but have not got any luck on the outcome. Do you have any idea what the filter may look like?

I will also give the automation a go.

Thanks Adam

[Trudy Claspill]

You could use something like this:

issuetype=Epic and not issueFunction in epicsOf("issuetype in standardIssueTypes()")

This gets you all the Epics for any standard level issue:

issueFunction in epicsOf("issuetype in standardIssueTypes()")

Adding "not" in front of it says you want everything that is not in that list, which would be all standard level issues, subtasks, and Epics that have no children.

This gets you every Epic:

issuetype=Epic

Combine the two and you get all the Epics that have no children.

You can refine the filter to limit it to specific projects.