Versions Compared

Old Version 11

changes.mady.by.user Jack Nolddor

Saved on

compared with

New Version Current

changes.mady.by.user Jack Nolddor

Saved on

Key

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

Description:

Excerpt

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.

Expand
titleLet'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:

Code Block
languagesql
themeConfluence
issue NOT IN hasSubtasks()


• Find Stories that have three or more subtasks

Code Block
languagesql
themeConfluence
type = Story AND issue IN hasSubtasks(">= 3")

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

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

Page Tree
rootJQL Function Reference
startDepth2