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

Vishnuvardhan Reddy September 5, 2023

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

5 answers

1 vote
Els Bassant
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 5, 2023

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!

0 votes
Imdad Kottapparamban March 8, 2024

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.

0 votes
mauricio.groth
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 8, 2023

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

0 votes
Mikael Sandberg
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
September 5, 2023

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.

0 votes
David Blank
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 5, 2023

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?

Suggest an answer

Log in or Sign up to answer