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

[Thomas]

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

[Rik de Valk _Brainboss_]

Hi @Thomas , 

Without Marketplace apps it is not possible to make queries that take another query as input. 

You can search on the Marketplace for apps that provide 'advanced search'. 

A famous one is Enhanced Search for Jira (Adaptavist). But there are many alternatives available. 

Have a nice day. 

Rik 

[Rahul_RVS]

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-]

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]

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.