JQL Query to find child issues of an Epic

SV August 22, 2019

JQL Query to find child issues of an Epic

3 answers

5 votes
Muhammad Ramzan(Atlassian Certified Master)
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
August 22, 2019

JQL Search Extensions for Jira & reports can help you to get all issues with sub tasks for epic

 

for example

Following query will get all issues and sub tasks related to the epic id "test-24" , please see the attached image.

issue in allIssuesInEpic(test-24)

 

here is the documentation link for all queries.

https://jqlsearchextensions.atlassian.net/wiki/spaces/SEARCH/pages/30497099/JQL+Reference+Server#JQLReference(Server)-LinkedIssueTypeepics.png

4 votes
Jack Brickey
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
August 22, 2019

"Epic Link" = ABC-123

this will give you all stories/tasks associated w/ the specific epic

Paul Matteucci July 8, 2021

Hey Jack,

this doesn't give me the sub-tasks tho. 

Any idea how to get those?

Thanks

Jack Brickey
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
July 8, 2021

You can’t achieve that out of the box. There are many posts in the community discussing this matter. Here is a good example that might help explain options - JQL-Query-Sub-Tasks-Parent-Epic-or-User-Story 

basically you’ll need an add-on to achieve this.

Paul Matteucci July 8, 2021

I found how to do it!

there's a command called parentEpic, it does exactly this:

parentEpic in (EPIC-1, EPIC-2)

it's built into Jira, no need for external add-ons 

Like # people like this
Jack Brickey
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
July 8, 2021

ahhhhhh yes that was added awhile back. if you know the epic id that works well

Evgen Kyselgov June 15, 2023

Maybe it's better to use combination of "Epic Link" and "parent"?

("Epic Link" = YourIssueKey) OR (parent = YourIssueKey)
3 votes
Fanny Rubiño Lavín February 9, 2023
parentEpic in (EPIC-1, EPIC-2)

This just return the epic in the parentheses to me. Not the child issues.

Evgen Kyselgov June 15, 2023

parentEpic is strange function. I don't see it in documentation page From other side there is function "Epic Link" = YourEpicKey that should return list of children issues.
But it returns epic's children only, not sub-tasks if they are present for Epic,

Suggest an answer

Log in or Sign up to answer