How can I find all issues within an epic thats "in progress"

[Toby Moore]

Hi guys, we've create an epic board to make sure that our epics are always in the correct status.

Now i'm looking for a query that will allow me to find all issues within the epics that are in progress but I cant seem to get it to work, any ideas?

Thanks

[NT · Accepted solution]

Its simple:

"Epic Link" = <Enter your epic key> and status ="In Progress"

In case you have multiple epics

"Epic Link" in (<Enter all epic keys separated by comma>) and status ="In Progress"

[Toby Moore]

thanks for the answer, but I dont want to have to sit there and go through my epic board and type in the issue key for the 20 in progress epics every time, I just want to be able to execute a query to find all these epics

[NT]

You want epics or issues linked to those epics?

[Toby Moore]

issues linked to those epics

[NT]

There is no direct way. You have to go for a plugin. Below are some suggestions

1. Script runner has some advance function like which allow you to write subquery as well.

2. JQL Search Extensions for Jira

3. JQL Tricks Plugin

[Toby Moore]

I was worried that would be the outcome, thanks for the advice anyway, I will try some of those!