Versions Compared

Old Version 12

changes.mady.by.user Jack Nolddor

Saved on

compared with

New Version 13

changes.mady.by.user Jack Nolddor

Saved on

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 AND "Epic Link" IS NOT EMPTY')

• 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 "Epic Link" IS NOT EMPTY') 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 "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

Page Tree
rootJQL Function Reference
startDepth2