Trying to create a filter to extract all the child issues for all the epics in Jira Cloud.

[Vishnuvardhan Reddy]

Hi

Trying to create a filter to extract all the child issues for all the epics present in a single or multiple projects in Jira Cloud?

Tried few JQL functions but able to filter only particular epic child issues but need a function or query to filter to extract all the child issues of all the epics present in a single or multiple projects in Jira Cloud.

Thanks in Advance.

Regards

Vishnuvardhan

[Els Bassant]

Hi @Vishnuvardhan Reddy

"Epic Link" is not EMPTY  would return all issues that have an Epic Link (and thus are part of an Epic). You can add more JQL functions to that to refine the search if needed.

But be aware that this only returns issues that are in an Epic. If any of those issues have subtasks those won't be included in the results.

Hope this helps!

[Imdad KP (Jira Admin)]

Hi @Vishnuvardhan Reddy

Try this
parentEpic in (ABC-123. XYZ-678)
This will give all the child issues of Project Epic mentioned in the query from multiple projects. You can add a parent column to the view with the epic link.

[mauricio.groth]

Hi @Vishnuvardhan Reddy 

I’m Maurício, a support engineer at Appfire and I’m here to help you.

Unfortunately, using JQL of Jira, 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 find all your children of epics.

issue in childrenOfEpicsInQuery("")

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

We’ll be happy to help you!
Best regards,
Maurício

[Mikael Sandberg]

Hi @Vishnuvardhan Reddy,

Welcome to Atlassian Community!

Ou-tof-the-box JQL cannot be used to create a nested query to get the result you are looking for. You would need an app that extends JQL in order to do it. If you check the Marketplace there are multiple apps that can do this, I have used both JQL Tricks and Scriptrunner/Enhanced search in the past to do this search.

[David Blank]

Hi @Vishnuvardhan Reddy and welcome to the Atlassian Community!

Would you mind sharing the queries you've tried including the ones that worked and didn't work?