Advanced Search for finding all issues related to an Epic

[Linda Marshall]

I have an Epic that has several stories and tasks, that, in turn have sub-tasks.

Is it possible to write a JQL to find all of the stories, tasks and sub-tasks that are tied to an Epic in Jira? 

So far I've only been able to retrieve the stories and tasks using "Epic Link" = epic ref.

Cheers

Linda

[Muhammad Ramzan(Atlassian Certified Master) · Accepted solution]

@Linda Marshall  you can use  JQL Search Extensions for Jira & reports, it have amazing built in queries which solve almost all reporting issues.  

For your case you can use the following query 

issue in allIssuesInEpic(EPIC ID)

It will get all issues belongs to the epic you provided along with any sub tasks.

[Alexey Matveev · Accepted solution]

Hello,

You can not do it out of the box. You would need an app for it like Power Scripts, ScriptRunner, JQL Extensions for Jira, J-tricks and so on.

If you want to use the Power Scripts app, then you could write a JQL query like this:

"Epic Link" = your epic or key in subtasksOf("\"Epic Link\" = your epic ")

[Thomas Magny-Garcia]

Hi @Linda Marshall 
If you want to use ScriptRunner, you could write a JQL query using issuesInEpics like :

You can go the other way, e.g. find all stories for open epics in a project

issueFunction in issuesInEpics("key = your epic")

 Hope it helps !