Page Comparison

Description:

Excerpt

Searches issues which any of their subtasks satisfies the provided subquery.
See also: subtasksOf()

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

title	Let's see an example...

Panel

This will not work

Code Block

language	sql
theme	Confluence

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

^{Searches issues which any of their subtasks are}^{closed and their resolution have been set to "Won't Do"}

This will work perfectly

Code Block

language	sql
theme	Confluence

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

^{Searches issues which any of their subtasks are}^{closed and their resolution have been set to "Won't Do"}

Code Block

language	sql
theme	Confluence

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

^{Searches issues which any of their subtasks are in proress and have been reportered by me}

Syntax	parentsOf(subquery)
Available since	v1.2.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 issues which any of their subtasks are 'Open':

Code Block

language	sql
theme	Confluence

issue IN parentsOf("status = Open")

• Find 'Unresolved' issues which any of their subtasks are 'Closed' and their resolution have been set to 'Won't Do'

Code Block

language	sql
theme	Confluence

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

• Find issues which all their subtasks have been resolved

Code Block

language	sql
theme	Confluence

issue IN parentsOf("resolution IS NOT EMPTY") AND issue NOT IN parentsOf("resolution IS EMPTY")

Real World Use Cases:

· JQL to find parents where all subtasks are resolved (by Gianni Pucciani at ATLASSIAN Community).
· JQL: Find all open issues of type "Issue Tracker" where all subtasks are closed or resolved (by Normann P. Nielsen at ATLASSIAN Community).

JQL Function Reference

Page Tree

root	JQL Function Reference
startDepth	2

Versions Compared

Old Version 21

New Version Current

Key

Description:

Examples:

Real World Use Cases: