Find all Child Issues of a filter / list of issues with children

Question

Hi Guys,

i wanted to check if it is possible to find all child issues from a list of dynamical issues. So i have a filter with say 50 issues and I want to find all children of these 50 issues.

With chilIssuesOf("") i can only hardcopy one issues by its issueKey and find the children of exactly these issues.

Thanks a lot

Rahul_RVS · Answer

Hi @Thomas

Welcome to the community !!

If you are open to try out an alternate mktplace solution to roll up progress in your Issue hierarchy in a tree view, take a look at

Issue Hierarchy

The app allows you to view your issues in a tree view along with the linked issues shown as child issue. Also you can filter your child issues as shown below.

In the hierarchy view you can view the % progress of your child issues as well. The app sums up the time spent / story points at each parent level. You can also view "%Completed" at each parent level based on status of child issues as per your requirement.

Do give it a try.

Disclaimer : I am one of the app team member

Thiago Wenceslau -Appfire- · Answer

Hi @Thomas

I’m Thiago, a support engineer at Appfire.

If you are considering third-party apps, JQL Search Extensions (JQLSE) supports issue hierarchy and nested searches by default..

Just apply the function childrenOfIssuesInQuery to a JQL of the issues you want to fetch the children for, like the example below:

issue in childrenOfIssuesInQuery("project='ABCD' and type=Epic")

Or, you could save a filter and simplify the query further:

issue in childrenOfIssuesInQuery("filter = YourCustomFilter")

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

Best regards, Appfire support team.

Arkadiusz Wroblewski · Answer

Hello and Welcome @Thomas

This is really where you start running into the native limitations of JQL.

If the logic cannot be expressed cleanly in a single query, the usual workaround is either to export the results from two separate JQL searches and combine them outside Jira, or to use an app that offers more advanced query/reporting capabilities.