Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Arturo Jimenez May 24, 2022 edited

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? 

2 answers

1 accepted

0 votes
Answer accepted
Hannes Obweger - JXL for Jira
Atlassian Partner
May 24, 2022

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

Hannes Obweger - JXL for Jira
Atlassian Partner
May 24, 2022

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:

hierarchy.gif

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.

Best,

Hannes

Like Arturo Jimenez likes this
0 votes
Rahul_RVS
Atlassian Partner
June 2, 2022 edited

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
fields

 

Epic Hierarchy - CHildren.PNG

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
TAGS
AUG Leaders

Atlassian Community Events