nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Arturo Jimenez_rtelep

Hi,

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?

Accepted answers

Hannes Obweger - JXL for Jira

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,

Best,

Hannes

All comments

Hannes Obweger - JXL for Jira

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.

Hope this helps,

Best,

Hannes

Hannes Obweger - JXL for Jira

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.