Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root


1 badge earned


Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!


Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.


Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!


Filter or JQL to get all child and sub child

I am trying to get the list of child and all sub child for the parent. For example if the hierarchy is EPIC -> Task -> Story -> Sub-Task, if I provide an epic or list of epics, would need the all the tasks under epics, all the stories under each task and sub tasks under each story. 

tried with “issue in linkedIssues()” and it gives only the immediate child but not the sub child. Is it possible with JIRA filter or JQL and share the details? It would be helpful and much appreciated. 


3 answers

1 vote
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.
Feb 14, 2023

Hi @Vishwanathan Rangaswamy 

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

Unfortunately, using JQL of Jira, you’ll not be able to do it.

In the app where my team works, JQL Search Extensions for Jira, we have the function ChildrenOfIssuesInQueryRecursive for a given JQL subquery it finds issues in the hierarchy below the resulting issues up to an optional depth. It supports Advanced Roadmaps “Parent Link” and a standard Jira hierarchy Epic → Story → Subtask. For example, you can use the query below to find all children(Task -> Story -> Sub-Task) in Epics in project ACME.

issue in childrenOfIssuesInQueryRecursive("type=Epic")

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

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

Thanks for the solution @mauricio.groth . Let me review other options and also check internally to see if I can purchase this plugin.

Like mauricio.groth likes this
0 votes
Hannes Obweger - JXL for Jira
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
Feb 15, 2023

Hi @Vishwanathan Rangaswamy

another option is to go with one of the more hierarchy-focused apps from the Marketplace. These apps typically have their own ways of figuring out parent/child relationships between issues, and provide more powerful ways of viewing and working with issue hierarchies. I can only speak for the app that my team is working on - JXL for Jira - but here, your use case should be trivial to solve:

JXL is a full-fledged spreadsheet/table view that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also supports issue hierarchies: Either based on Jira's built-in parent/child relationships, or based on issue links. 

This is how it looks in action for a 5-level hierarchy - but you can configure any hierarchy you want:


It's worth noting that JXL can do much more than that: From support for configurable sum-ups, to conditional formatting, to exporting to Excel or CSV with just one click.

Any questions just let me know,



Trying your JXL add-on, but it doesn't seem like you can use filters created in ScriptRunner enhanced search?    If not, does you tool offer similar JQL functions?

0 votes
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
Feb 15, 2023

Hi @Vishwanathan Rangaswamy 

If you are fine with a mktplace app for a readymade solution, you can try out our add-on.

Issue Hierarchy Reports 

The app will show you the default Epic Hierarchy and also let your filter on the child issue statuses.

Disclaimer : I work for the vendor who built this app

Epic Hierarchy - Gadget - Summary.PNG

Suggest an answer

Log in or Sign up to answer