JQL to retrieve children and grand children of an initiative

[Venky]

All

We use On-Prem version of Jira, and need help with JQL.  We have the hierarchy Initiative --> EPic --> Story.   Is there a way to retrieve not only the children of initiative (that is Epics) but also the stories underneath for each initiative?

[Andreas Haaken _APTIS_]

Hi @Venky , 

with Epic Sum Up (our plugin) we have created a feature called Containers, which allow you to have a more flexible way of stacking issues (compared to initiatives & co.). But we support all hierarchies from Jira Roadmaps, too. 

To support this, we created an JQL that gives back all child issues beyond your selected issue:

issue in childIssuesOfContainer(PESU-4884)

 This works for Jira Hierarchies too:

I hope that helps. If you want to know more, pls let me know.

[Rahul_RVS_Support]

Hi @Venky  

Welcome to the community !!

For a readymade solution to extract your issue hierarchy, we have created an app

Agile Tools - Epic Tree, Links Tree and Time in Status 

You can also view the full Jira Issue Type hierarchy of Linked issues, Portfolio/Advanced Roadmaps, Epics, and Subtasks up to 10 levels.

Key features :

• Hierarchy upto 10 levels deep
• Progress % on "remaining estimate" or "original estimates"
• Edit Issue summary, time estimates, story points and assignee on the tree with real time updates in the progress
• Rolled up percentage completion at all levels
• Ability to add/remove the columns on the report

Along with this there are multiple other features like Time in Status, Worklogs reports etc which the app provides.

Disclaimer: I work for RVS, the vendor for this app, and I am one of the developers of the app

[Venky]

Thank you.