Try it free: ☁Cloud 🖥Data Center
| Info |
|---|
The instructions on this page describe how to execute a JQL search using JQL Search Extensions. |
| Table of Contents | ||||||
|---|---|---|---|---|---|---|
|
Subtasks JQL functions
| Info |
|---|
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 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 which parents summary contains text "Test"
| Code Block |
|---|
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
EXAMPLES
Find subtasks which parent is of a "Blocker" priority.
| Code Block |
|---|
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".
| Code Block |
|---|
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 which is "In Progress".
| Code Block |
|---|
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 "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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
EXAMPLES
Find issues with subtasks
| Code Block |
|---|
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
EXAMPLES
Find issues 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
EXAMPLES
Find issues with subtasks which 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
EXAMPLES
Find issues which 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
EXAMPLES
Find issues which have "To Do" status category.
| Code Block |
|---|
subtaskStatusCategory = "To Do" |