Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Description:

Excerpt

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.

Expand
titleLet's see an example...


Panel

(error) This will not work

Code Block
languagesql
themeConfluence
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

Code Block
languagesql
themeConfluence
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"

Code Block
languagesql
themeConfluence
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:

Code Block
languagesql
themeConfluence
issue IN epicsOf("status = Open")

• Find epics without any issues in it

Code Block
languagesql
themeConfluence
type = Epic and issue not in epicsOf('"Epic Link" IS NOT EMPTY')

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

Code Block
languagesql
themeConfluence
issue IN epicsOf("status != Closed") AND resolution IS NOT EMPTY

• Find not Closed epics in which all their associated issues have been resolved

Code Block
languagesql
themeConfluence
status != Closed AND issue IN epicsOf("resolution IS NOT EMPTY") AND issue NOT IN epicsOf("resolution IS 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

Page Tree
rootJQL Function Reference
startDepth2