Versions Compared

Key

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

The instructions on this page describe how to execute a JQL search using JQL Search Extensions.

Table of Contents
minLevel1
maxLevel7
excludeTry it free

Subtasks JQL functions

Info

JQL functions are accessible from the Extended Search page or Extended Search filters in Jira advanced search.

ParentsOfSubtasksInQuery

For a given JQL subquery, it finds parents of the resulting subtasks.

Examples:

issue in parentsOfSubtasksInQuery("status='To Do'") and status='Done' finds finished issues that have unfinished subtasks
issue in parentsOfSubtasksInQuery("assignee=currentUser()") finds parents of my subtasks

SubtasksOfParentsInQuery

For a given JQL subquery, it finds subtasks of resulting parent issues.

Examples:

issue in subtasksOfParentsInQuery("status='Done'") and status='To Do' finds subtasks that are in progress and have finished parents
issue in subtasksOfParentsInQuery("assignee=currentUser()") finds subtasks of my issues

Subtasks JQL keywords

ParentSummary

Search for subtasks with a parent's summary containing a particular text. SUPPORTED OPERATORS  

Supported operators

=

!=

~

!~

>

>=

<

<=

IS

IS NOT

IN

NOT IN

WAS

WAS IN

WAS NOT

WAS NOT IN

CHANGED

(error)

(error)

(tick)

(tick)

(error)

(error)

(error)

(error)

(tick)

(tick)

(error)

(error)

(error)

(error)

(error)

(error)

(error)

EXAMPLESExamples: 

Find subtasks where the parent summary contains the text "Test".

Code Block
parentSummary ~ "Test"  

...

ParentPriority

Search for subtasks with a parent that has particular priority.

SUPPORTED OPERATORS  Supported operators

=

!=

~

!~

>

>=

<

<=

IS

IS NOT

IN

NOT IN

WAS

WAS IN

WAS NOT

WAS NOT IN

CHANGED

(tick)

(tick)

(error)

(error)

(error)

(error)

(error)

(error)

(tick)

(tick)

(tick)

(tick)

(error)

(error)

(error)

(error)

(error)

EXAMPLESExamples: 

Find subtasks where the parent has "the Blocker " priority. 

Code Block
parentPriority = Blocker

...

ParentIssueType

Search for subtasks with a parent of a particular issue type.

SUPPORTED OPERATORS  Supported operators

=

!=

~

!~

>

>=

<

<=

IS

IS NOT

IN

NOT IN

WAS

WAS IN

WAS NOT

WAS NOT IN

CHANGED

(tick)

(tick)

(error)

(error)

(error)

(error)

(error)

(error)

(tick)

(tick)

(tick)

(tick)

(error)

(error)

(error)

(error)

(error)

EXAMPLES Examples:  

Find subtasks with a parent of issue type "Test".

Code Block
parentIssueType = "Test"

...

ParentStatus

Search for subtasks with a parent of a particular status.

SUPPORTED OPERATORS  Supported operators

=

!=

~

!~

>

>=

<

<=

IS

IS NOT

IN

NOT IN

WAS

WAS IN

WAS NOT

WAS NOT IN

CHANGED

(tick)

(tick)

(error)

(error)

(error)

(error)

(error)

(error)

(tick)

(tick)

(tick)

(tick)

(error)

(error)

(error)

(error)

(error)

EXAMPLES Examples:  

Find subtasks with a parent that is "the In Progress "status

Code Block
parentStatus = "In Progress"

...

ParentStatusCategory

Search for subtasks with a parent of a particular status category.

SUPPORTED OPERATORS  Supported operators

=

!=

~

!~

>

>=

<

<=

IS

IS NOT

IN

NOT IN

WAS

WAS IN

WAS NOT

WAS NOT IN

CHANGED

(tick)

(tick)

(error)

(error)

(error)

(error)

(error)

(error)

(tick)

(tick)

(tick)

(tick)

(error)

(error)

(error)

(error)

(error)

EXAMPLES Examples:  

Find subtasks with a parent in the " To Do " status category.

Code Block
parentStatusCategory= "To Do"

SubtasksCount

Search for issues that have a particular number of subtasks. 

SUPPORTED OPERATORS 

...

=

...

!=

...

~

...

!~

...

>

...

>=

...

<

...

<=

...

IS

...

IS NOT

...

IN

...

NOT IN

...

WAS

...

WAS IN

...

WAS NOT

...

WAS NOT IN

...

CHANGED

...

(tick)

...

(tick)

...

(error)

...

(error)

...

(tick)

...

(tick)

...

(tick)

...

(tick)

...

(error)

...

(error)

...

(error)

...

(error)

...

(error)

...

(error)

...

(error)

...

(error)

...

(error)

EXAMPLES

Find issues with subtasks.

Code Block
subtasksCount > 0 

 

SubtaskSummary

Search for issues that have subtasks where the summary contains particular text. 

SUPPORTED OPERATORS  

...

=

...

!=

...

~

...

!~

...

>

...

>=

...

<

...

<=

...

IS

...

IS NOT

...

IN

...

NOT IN

...

WAS

...

WAS IN

...

WAS NOT

...

WAS NOT IN

...

CHANGED

...

(error)

...

(error)

...

(tick)

...

(tick)

...

(error)

...

(error)

...

(error)

...

(error)

...

(tick)

...

(tick)

...

(error)

...

(error)

...

(error)

...

(error)

...

(error)

...

(error)

...

(error)

EXAMPLES 

Find issues in which subtasks summary contains text "Test".

Code Block
subtaskSummary ~ "Test"  

 

SubtaskKey

Search for issues that have subtasks with a particular key. 

SUPPORTED OPERATORS  

...

=

...

!=

...

~

...

!~

...

>

...

>=

...

<

...

<=

...

IS

...

IS NOT

...

IN

...

NOT IN

...

WAS

...

WAS IN

...

WAS NOT

...

WAS NOT IN

...

CHANGED

...

(tick)

...

(tick)

...

(error)

...

(error)

...

(error)

...

(error)

...

(error)

...

(error)

...

(tick)

...

(tick)

...

(tick)

...

(tick)

...

(error)

...

(error)

...

(error)

...

(error)

...

(error)

EXAMPLES 

Find issues with subtask with key ABC-123.

Code Block
subtaskKey = ABC-123

 

SubtaskPriority

Search for issues that have subtasks with a particular priority.

SUPPORTED OPERATORS  

...

=

...

!=

...

~

...

!~

...

>

...

>=

...

<

...

<=

...

IS

...

IS NOT

...

IN

...

NOT IN

...

WAS

...

WAS IN

...

WAS NOT

...

WAS NOT IN

...

CHANGED

...

(tick)

...

(tick)

...

(error)

...

(error)

...

(error)

...

(error)

...

(error)

...

(error)

...

(tick)

...

(tick)

...

(tick)

...

(tick)

...

(error)

...

(error)

...

(error)

...

(error)

...

(error)

EXAMPLES 

Find issues with subtasks that have a "Blocker" priority. 

Code Block
subtaskPriority = Blocker

 

SubtaskIssueType

Search for issues that have subtasks with a particular issue type.

SUPPORTED OPERATORS  

...

=

...

!=

...

~

...

!~

...

>

...

>=

...

<

...

<=

...

IS

...

IS NOT

...

IN

...

NOT IN

...

WAS

...

WAS IN

...

WAS NOT

...

WAS NOT IN

...

CHANGED

...

(tick)

...

(tick)

...

(error)

...

(error)

...

(error)

...

(error)

...

(error)

...

(error)

...

(tick)

...

(tick)

...

(tick)

...

(tick)

...

(error)

...

(error)

...

(error)

...

(error)

...

(error)

EXAMPLES 

Find issues with subtasks of issue type "Test".

Code Block
subtaskIssueType = "Test"

 

SubtaskStatus

Search for issues that have subtasks with a particular status.

SUPPORTED OPERATORS  

...

=

...

!=

...

~

...

!~

...

>

...

>=

...

<

...

<=

...

IS

...

IS NOT

...

IN

...

NOT IN

...

WAS

...

WAS IN

...

WAS NOT

...

WAS NOT IN

...

CHANGED

...

=

...

!=

...

~

...

!~

...

>

...

>=

...

<

...

<=

...

IS

...

IS NOT

...

IN

...

NOT IN

...

WAS

...

WAS IN

...

WAS NOT

...

WAS NOT IN

...

CHANGED

...

(tick)

...

(tick)

...

(error)

...

(error)

...

(error)

...

(error)

...

(error)

...

(error)

...

(tick)

...

(tick)

...

(tick)

...

(tick)

...

(error)

...

(error)

...

(error)

...

(error)

...

(error)

EXAMPLES 

Find issues that have subtasks "In Progress". 

Code Block
subtaskStatus = "In Progress"

 

SubtaskStatusCategory

Search for issues that have subtasks with a particular status category.

SUPPORTED OPERATORS  

...

=

...

!=

...

~

...

!~

...

>

...

>=

...

<

...

<=

...

IS

...

IS NOT

...

IN

...

NOT IN

...

WAS

...

WAS IN

...

WAS NOT

...

WAS NOT IN

...

CHANGED

...

(tick)

...

(tick)

...

(error)

...

(error)

...

(error)

...

(error)

...

(error)

...

(error)

...

(tick)

...

(tick)

...

(tick)

...

(tick)

...

(error)

...

(error)

...

(error)

...

(error)

...

(error)

EXAMPLES 

Find issues that have "To Do" status category.

Code Block
subtaskStatusCategory = "To Do"