How to get List of Tasks and subtaks in an Epic through JQL

[Ankela Pavani]

Need a JQL to get all the issues like tasks,sub tasks in Epic

[Aron Gombas _Midori_]

You can just a run the CQL:

"Epic Link" = FOOBAR-123

It returns all issues in the epic FOOBAR-123. 

[Trudy Claspill]

Hello @Ankela Pavani 

Welcome to the Atlassian community.

Are you using Jira Server or Jira Data Center?

What version of the product are you using? The version information can be found at the bottom of many screens, including the Dashboard screens.

Do you have access to any third party plugins that extend the search/filter capabilities of Jira?

[Ankela Pavani]

Hi @Trudy Claspill  ,

I'm using Jira server ,

Jira version is v9.4.7

Yes I have the filter capability of Jira.

Thanks

[Trudy Claspill]

I'm not asking if you have access to the filtering capability.

I'm asking if any third party plugins (like ScriptRunner or JQL Tricks) have been added to your instance so that the filtering functionality has been extended with capabilities that are not part of the native Jira functionality.

[Ankela Pavani]

Hi ,

I don't have any access to third party plugins.

Thanks

[Trudy Claspill]

With only Jira Server and no third party plugins to extend the filtering capabilities, the only way to get child issues and their subtasks for an Epic is to first get the list of child stories:

"Epic Link" = <issue key for the Epic>

From those results, manually extract the list of issue keys.

Then you have to create another filter to retrieve the subtasks for all those issues:

Parent in (<comma separated list of Epic's child task issue keys>)