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

How do we get the list of all the childs for a project?



We have a jira project called ENB with the initiatives and epics for a product backlog, and other jira projects per scrum team that contain the tasks and user stories, example CRUW and MKT.

I cannot find a way to create a JQL that list all the user stories and tasks for the whole product backlog, ENB.


Any insights? 

2 answers

1 accepted

0 votes
Answer accepted

HI @Arturo Jimenez

JQL isn't too great in retrieving issues "across" hierarchy levels, unfortunately.

A few ideas:

First, if you know the issue keys of all your epics and the number of epics isn't too huge, you can select your stories and tasks like this:

"Epic Link" in (WORK-150, WORK-142)

... where "WORK-150" and "WORK-142" are the issue keys of your epics. You can list many more, but you have to explicitly list each and every one of them.

Second, there's a number of apps from the Atlassian Marketplace that extend JQL by additional features. E.g., JQL Search Extensions has a "issueFromEpicsInQuery" feature that should give you what you need.

Lastly, there's a number of more "hierarchy-focused" apps in the Atlassian Marketplace that can resolve parent/child relationships within a set of issues; not so much via "raw" JQL, but by applying custom logic.

Hope this helps,



Just to add to the last point: In the app that my team is working on - JXL for Jira - you'd simply need to query your epics and any possible child issue (from CRUW and MKT in your example), enable the "hierarchy" feature, and see your issues as shown below:


If you need to, you can export this list to Excel or Google Sheets for further processing.

As for almost any problem, there's a number of Marketplace apps that focus on issue hierarchies, so you likely want to do your own research and evaluations on which one fits the best.



Like Arturo Jimenez likes this
0 votes

Hi @Arturo Jimenez 

If you are fine with a mktplace app, you can have a look at

Issue Hierarchy Reports 

The app shows the child tasks / linked tasks count at each hierarchy level across projects as shown below.
You can also generate insights such as:

- View the full Jira Issue Type hierarchy of Linked issues,
Portfolio/Advanced Roadmaps, Epics, and Subtasks up to 10 levels.

- % complete based on time spent and story points at each hierarchy level

- Sum up Time Spent, Org Estimate, Time Rmng, custom number


Epic Hierarchy - CHildren.PNG

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Jira Software

Upcoming changes to epic fields in company-managed projects

👋 Hi there Jira Community! A few months ago we shared with you plans around renaming epics in your company-managed projects. As part of these changes, we highlighted upcoming changes to epics on...

14,860 views 37 49
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you