A filter that only shows epics that have tasks

Question

We have placeholder epics, meaning epics that will have tasks, but currently sit empty. When filling the backlog I don't want these epics to be included in the list.

To achieve this I will make a board based on a filter. This filter needs to exclude all epics without tasks. What would such a filter look like.

I found

issue in portfolioChildIssuesOf("EPIC-123")

but this needs me to specify all epics I want on the board.

Charlotte Santos -Appfire- · Answer

Hi @Adam Bang

I’m Charlotte, a support engineer at Appfire and I’m here to help you.

Unfortunately, natively, you’ll not be able to do it dynamically.

In the app where my team works, JQL Search Extensions for Jira, you can use this query to see only epics that have tasks as children:

issue in epicsOfChildrenInQuery("type = task")

Please contact our support if you have any other questions about this query.

We’ll be happy to help you!

Varsha Joshi · Answer

I do not think backlog has epic's listed in them. All issues created whether they have an epic link or not should show in the backlog.

Marc -Devoteam- · Answer

Hi @Adam Bang

You described the option available.

If you want this otherwise, you will need to purchase an JQL extensions app from the marketplace.

Natively there is an automation option for this.

"Adds  specific label to Epics with no children.

The trigger can we scheduled to run once a day, or just when someone creates an issue.

The automation does the following:

* Remove the label "thisEpicHas0Children" from all tickets that has this (reset)
* Find all Epics in a project.
* Use a "Related issues condition" to find all Epics with 0 children.
* Add the label "thisEpicHas0Children" to those

You can now make a JQL query that searches for all tickets with this label.