Subtasks JQL functions

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

 

Subtasks JQL functions

JQL functions are accessible from Extended Search screen or via Extended Search filters in Jira advanced search.

ParentsOfSubtasksInQuery

For a given JQL subquery it finds parents of 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 Aliases

ParentSummary

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

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

EXAMPLES 

Find subtasks which parents summary contains text "Test"

1 parentSummary ~ "Test"

 

ParentPriority

Search for subtasks with a parent of a particular Priority.

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

EXAMPLES 

Find subtasks which parent is of a "Blocker" priority. 

1 parentPriority = Blocker

 

ParentIssueType

Search for subtasks with a parent of a particular Issue Type.

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

EXAMPLES 

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

1 parentIssueType = "Test"

 

ParentStatus

Search for subtasks with a parent of 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

EXAMPLES 

Find subtasks with a parent which is "In Progress". 

1 parentStatus = "In Progress"

 

ParentStatusCategory

Search for subtasks with a parent of a particular Status Category.

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

EXAMPLES 

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

1 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

=

!=

~

!~

>

>=

<

<=

IS

IS NOT

IN

NOT IN

WAS

WAS IN

WAS NOT

WAS NOT IN

CHANGED

EXAMPLES

Find issues with subtasks

1 subtasksCount > 0 

 

SubtaskSummary

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

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

EXAMPLES 

Find issues which subtasks summary contains text "Test"

1 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

=

!=

~

!~

>

>=

<

<=

IS

IS NOT

IN

NOT IN

WAS

WAS IN

WAS NOT

WAS NOT IN

CHANGED

EXAMPLES 

Find issues with subtask with key ABC-123

1 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

=

!=

~

!~

>

>=

<

<=

IS

IS NOT

IN

NOT IN

WAS

WAS IN

WAS NOT

WAS NOT IN

CHANGED

EXAMPLES 

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

1 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

=

!=

~

!~

>

>=

<

<=

IS

IS NOT

IN

NOT IN

WAS

WAS IN

WAS NOT

WAS NOT IN

CHANGED

EXAMPLES 

Find issues with subtasks of issue type "Test".

1 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

=

!=

~

!~

>

>=

<

<=

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

EXAMPLES 

Find issues which have subtasks "In Progress". 

1 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

=

!=

~

!~

>

>=

<

<=

IS

IS NOT

IN

NOT IN

WAS

WAS IN

WAS NOT

WAS NOT IN

CHANGED

EXAMPLES 

Find issues which have "To Do" status category.

1 subtaskStatusCategory = "To Do"