How to create a filter which lists issues tied to Epics with a specific Epic Status?

Question

I would like to create a filter that will list all Tasks, which are associated with Epics that have a particular Epic Status.  For example, I would like to do something like:

assignee = currentUser() AND status = Open AND "Epic Status" = "In Progress"   ORDER BY priority DESC

I think perhaps this is not working, because the Task itself has no Epic Status.  It's the associated Epic (the one I specify in "Epic Link") which has this status.  Any thoughts?

Lime Trees · Answer

Hi,

you can have a look at Ultimate Guide for our add-on Epic Finder.

Please take a look at function efIssuesEpics eg.

issue in efIssuesEpics('status=\"In Progress\"') and assignee = currentUser() AND status = Open ORDER BY priority DESC

Regards,

Lime Trees Support Team

Mikael Sandberg · Answer

You would need an app to do nested JQLs, like JQL Tricks (server only) or ScriptRunner. Your JQL using JQL Tricks would would look something like this:

assignee = currentUser() AND status = Open AND issue in issuesWhereEpicIn("status = \"In Progress\"") ORDER BY priority DESC