The instructions on this page describe how to execute a JQL search using JQL Search Extensions.
Subtasks JQL functions
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 subtasksissue 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 parentsissue 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
EXAMPLES
Find subtasks where the parent summary contains the text "Test".
parentSummary ~ "Test"
ParentPriority
Search for subtasks with a parent that has particular priority.
SUPPORTED OPERATORS
= | != | ~ | !~ | > | >= | < | <= | IS | IS NOT | IN | NOT IN | WAS | WAS IN | WAS NOT | WAS NOT IN | CHANGED |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
EXAMPLES
Find subtasks where parent has "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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
EXAMPLES
Find subtasks with a parent that is "In Progress".
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
EXAMPLES
Find subtasks with a parent in the "To Do" status category.
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
EXAMPLES
Find issues with subtasks.
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
EXAMPLES
Find issues in which subtasks summary contains text "Test".
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
EXAMPLES
Find issues with subtask with key ABC-123.
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
EXAMPLES
Find issues with subtasks that have a "Blocker" priority.
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
EXAMPLES
Find issues with subtasks of issue type "Test".
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
EXAMPLES
Find issues that have subtasks "In Progress".
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
EXAMPLES
Find issues that have "To Do" status category.
subtaskStatusCategory = "To Do"