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 Closed epics in which all their associated issues have been resolved

status != Closed AND issue IN epicsOf('resolution IS NOT EMPTY AND "Epic Link" IS NOT EMPTY') 
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