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!


Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

JQL to retrieve children and grand children of an initiative


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?


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.

Like Arsenii Al-Vardi likes this
Rahul_RVS_Support Marketplace Partner Jan 18, 2022

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


Links Hierarchy.png

Thank you.

Like Rahul_RVS_Support likes this


Log in or Sign up to comment