Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Filter or JQL to get all child and sub child

Vishwanathan Rangaswamy
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
February 14, 2023

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. 

 

4 answers

1 vote
Peter Cselotei - Lupus Consulting Zrt_
Contributor
June 26, 2024

Hello, use 

issue in portfolioChildIssuesOf("ABC-1234")

 Needs premium plan to work. 

 

Have a nice day!

1 vote
Rahul_RVS
Atlassian Partner
February 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

1 vote
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.
February 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,
Maurício

Vishwanathan Rangaswamy
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
February 14, 2023

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
Atlassian Partner
February 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:

5-level-hierarchy.gif

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,

Best,

Hannes

John Williams
Contributor
July 6, 2023

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?

Suggest an answer

Log in or Sign up to answer