I’m working with Jira Server 9.12 and I’m trying to create a JQL query that shows all the issues and their subtasks within a particular epic. Our epic has lots of issues, each with its own set of subtasks.
I’ve looked around for solutions, but most of them seem to work only for Jira Cloud. I need something that works specifically for Jira Server.
The end goal is to save this query as a filter and use it to make a dashboard. This way, I can easily keep tabs on all the work happening in the epic.
Has anyone tackled this before? Any tips or tricks would be super helpful!
I’ve dealt with this exact scenario in Jira Server. Here’s a JQL query that should work for you:
‘parent in (issue in epicLink(EPIC-KEY)) OR issue in epicLink(EPIC-KEY)’
Replace EPIC-KEY with your actual epic’s key. This query fetches all issues directly linked to the epic, plus their subtasks. It works well with Jira Server 9.x and assumes your subtasks are set up as child issues. If you have multiple levels of subtasks, you might need to adjust the query accordingly. Once the query retrieves all necessary tasks, you can save it as a filter and integrate it into your dashboard to monitor progress across complex epics.
‘issuefunction in linkedIssuesOf(“epic = EPIC-KEY”)’
replace EPIC-KEY with ur epic’s actual key. this grabs all linked issues, including subtasks. it’s worked gr8 for me on jira server 9.x. hope it helps!
As someone who’s been using Jira Server for years, I can share a trick that’s worked wonders for me. Instead of relying solely on JQL, I’ve found that combining it with a scripted JQL function gives the best results. Here’s what I do:
First, I create a custom scripted JQL function called ‘allIssuesInEpic’. This function recursively fetches all issues and subtasks within an epic. Then, I use it in my JQL like this:
issue in allIssuesInEpic(EPIC-KEY)
This approach is more flexible and can handle multiple levels of subtasks if needed. It’s a bit more setup initially, but it’s saved me countless hours in the long run, especially when dealing with complex epics.
Remember to replace EPIC-KEY with your actual epic key. Once you’ve got this set up, you can easily save it as a filter and add it to your dashboard. It’s been a game-changer for my team’s epic tracking.