hasSubtasks()

Description:

Searches issues with / without subtasks, additionally you can further refine your query by using a number expression.

Note:

A 'number expression' is made of an optional operator representing by its mathematical symbol and a (prositive/negative) number.

 Let's see the allowed symbols...
OperatorSymbol
Equals to=
Not equals to!=
Greater than>
Greater than or equals to>=
Less than<
Less than or equals to<=

(warning) By default, this function only includes issues with at least one subtask even if you use the '<' or '<=' operator.
   You must explicity add 'issues NOT IN hasSubtasks()' clause to your query, if you also want to search for issues without subtasks.


Syntax

hasSubtasks()
hasSubtasks(numberExpression)

Available sincev2.0.0-RELEASE
Supported fieldsIssue
Supported operatorsIN , NOT IN
Unsupported operators

= , != , ~ , !~ , > , >= , < , <=

IS , IS NOT , WAS , WAS IN , WAS NOT , WAS NOT IN , CHANGED

Examples:

• Find issues without subtasks:

issue NOT IN hasSubtasks()

• Find Stories that have three or more subtasks

type = Story AND issue IN hasSubtasks(">= 3")

• Find issues within the EMEA project having less than 2 subtasks or with no subtasks at all.

project = EMEA AND (issue IN hasSubtasks("< 2") OR issue NOT IN hasSubtasks())

Real World Use Cases:

· JRASERVER-24973 - Ability to Show Only Issues Without Subtasks (by Alyson Reis [Atlassian])
·
JQL filter for Stories without Subtasks? (without plugin) (by Mike Shkolnik at ATLASSIAN Community)
·
I need to find issues that has no subtask (by Jurgen Sërbo at ATLASSIAN Community)

JQL Function Reference