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...

(error) 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"

(tick) 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


SyntaxepicsOf(subquery)
Available sincev1.7.0-RELEASE
Supported fieldsIssue
Supported operatorsIN , 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