Filter or JQL to get all child and sub child

[Vishwanathan Rangaswamy]

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. 

[Peter Cselotei - Lupus Consulting Zrt_]

Hello, use 

issue in portfolioChildIssuesOf("ABC-1234")

---

 Needs premium plan to work. 

Have a nice day!

[Rahul_RVS]

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

[mauricio.groth]

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]

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

[Hannes Obweger - JXL for Jira]

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,

Best,

Hannes

[John Williams]

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?