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.
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.
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
👋 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...
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