This site is moving soon to become part of an integrated Appfire documentation and information site for our apps. This site will remain available during the transition to our new and improved site. Once this site is moved over, this banner will be updated with the new site link for easy access.

Take a look here! If you have any questions please email support@appfire.com

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"

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. 

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".

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". 

 

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.

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

 

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"

 

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

 

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. 

 

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".

 

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