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?
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
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.
Best,
Hannes
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
If you are fine with a mktplace app, you can have a look at
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.