epicsOf()

Description:

Searches for epics that belong to issues that match the given subquery
See also: issuesInEpics()

Note:
Since you need to enclose the provided subquery using doble quotes, you must to escape any doble quotes using in the subquery by preceding a backslash after the double quotes, alternatively you can use a single quote in some cases.

Let's see an example...

This will not work

issue IN epicsOf("resolution = "Won't Do" AND status = Closed")

^{Searches for epics that belong to closed issues in which}^{their resolution have been set to "Won't Do"}

This will work perfectly

issue IN epicsOf("resolution = \"Won't Do\" AND status = Closed")

^{Searches for epics that belong to closed issues in which}^{their resolution have been set to "Won't Do"}

issue IN epicsOf("status = 'In Progress' AND reporter = currentUser()")

^{Searches for epics that belong to in progress issues reportered by me}

Syntax	epicsOf(subquery)
Available since	v1.7.0-RELEASE
Supported fields	Issue
Supported operators	`IN , NOT IN`
Unsupported operators	`=` `,` `!=` `,` `~` `,` `!~` `,` `>` `,` `>=` `,` `<` `,` `<=` `IS` `,` `IS NOT` `,` `WAS` `,` `WAS IN` `,` `WAS NOT` `,` `WAS NOT IN` `,` `CHANGED`

Examples:

• Find epics that belong to 'Open' issues:

issue IN epicsOf('status = Open AND "Epic Link" IS NOT EMPTY')

• Find epics without any issues in it

type = Epic and issue NOT IN epicsOf('"Epic Link" IS NOT EMPTY')

• Find resolved Epics that belong to not 'Closed' issues

issue IN epicsOf('status != Closed AND "Epic Link" IS NOT EMPTY') AND resolution IS NOT EMPTY

• Find not unresolved Epics in which all their associated issues have been resolved

type = Epic AND resolution is EMPTY AND issueLinkType = 'is Epic of' 
AND issue NOT IN epicsOf('resolution IS EMPTY AND "Epic Link" IS NOT EMPTY')

Real World Use Cases:

· JQL to show epics of stories fixed in a release (by wendy cotter at ATLASSIAN Community).
· How do I filter epics with all stories done? (by Alesh Dulal at ATLASSIAN Community).
· JQL - Epics associated with set of Stories (by Kelley Cooper at ATLASSIAN Community).
· JRASERVER-40839 - Allow JQL search for epics based on issues within them (by MicahF)

JQL Function Reference