Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
  • Subtasks JQL Functions

    • parentsOfSubtasksInQuery()

    • subtasksOfParentsInQuery()

  • Subtasks JQL Keywords

    • parentSummary

    • parentPriority

    • parentIssueType

    • parentStatus

    • parentStatusCategory

    • subtasksCount

    • subtaskSummary

    • subtaskKey

    • subtaskPriority

    • subtaskIssueType

    • subtaskStatus

    • subtaskStatusCategory

Subtasks JQL Functions

parentsOfSubtasksInQuery()

Retrieves the parent issues of subtasks that match a specified JQL subquery.

Examples:

issue in parentsOfSubtasksInQuery("status='To Do'") and status='Done' finds completed issues that have subtasks still in ‘To Do’ status.
issue in parentsOfSubtasksInQuery("assignee=currentUser()") retrieves parent issues of your subtasks.

subtasksOfParentsInQuery()

Finds subtasks of parent issues that match a given JQL subquery.

Examples:

issue in subtasksOfParentsInQuery("status='Done'") and status='To Do' identifies subtasks that are in ‘To Do’ status with parents that are completed.
issue in subtasksOfParentsInQuery("assignee=currentUser()") retrieves subtasks of issues assigned to you.

Subtasks JQL Keywords

ParentSummary

Searches for subtasks whose parent summaries contain specific 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 

Finds subtasks where the parent’s summary includes the word “Test”.

Code Block
parentSummary ~ "Test"

ParentPriority

Finds subtasks whose parents have 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 

Retrieves subtasks with parents set to “Blocker” priority.

Code Block
parentPriority = Blocker

ParentIssueType

Locates subtasks with parents of a specific 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 

Finds subtasks whose parents are of the issue type “Test”.

Code Block
parentIssueType = "Test"

ParentStatus

Searches for subtasks whose parents are in a certain status.

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 

Identifies subtasks with parents currently in “In Progress” status.

Code Block
parentStatus = "In Progress"

ParentStatusCategory

Finds subtasks whose parents belong to a specific 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 

Retrieves subtasks with parents in the “To Do” status category.

Code Block
parentStatusCategory= "To Do"

SubtasksCount

Searches for issues based on the number of their 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

Finds issues that have one or more subtasks.

Code Block
subtasksCount > 0 

SubtaskSummary

Locates issues that have subtasks containing particular text in their summaries.

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 

Finds issues whose subtasks’ summaries include the word “Test”.

Code Block
subtaskSummary ~ "Test"  

SubtaskKey

Finds issues that have subtasks with a specific issue 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 

Retrieves issues containing a subtask with the key “TEST-1”.

Code Block
subtaskKey = TEST-1

SubtaskPriority

Searches for issues with subtasks of 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 

Finds issues that have subtasks marked as “Blocker” priority.

Code Block
subtaskPriority = Blocker

SubtaskIssueType

Identifies issues with subtasks of a specific 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 

Retrieves issues that have subtasks of the issue type “Test”.

Code Block
subtaskIssueType = "Test"

SubtaskStatus

Finds issues that have subtasks in a certain status.

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 

Identifies issues with subtasks currently in “In Progress” status.

Code Block
subtaskStatus = "In Progress"

SubtaskStatusCategory

Searches for issues with subtasks belonging to a specific 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 

Retrieves issues that have subtasks in the “To Do” status category.

Code Block
subtaskStatusCategory = "To Do"