| Info |
|---|
The instructions examples on this page describe how to execute build a JQL search using JQL Search Extensions. |
On this page:
|
|---|
Subtasks JQL functions
| Info |
|---|
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
When using functions, the issues returned are based on the subquery defined in parentheses. |
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
...
keywords
ParentSummary
Search for subtasks with a parent's summary containing a particular text. SUPPORTED OPERATORS
Supported operators
= | != | ~ | !~ | > | >= | < | <= | IS | IS NOT | IN | NOT IN | WAS | WAS IN | WAS NOT | WAS NOT IN | CHANGED |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
EXAMPLESExamples:
Find subtasks where the parent summary contains the text "Test".
| Code Block |
|---|
parentSummary ~ "Test" |
...
ParentPriority
Search for subtasks with a parent that has particular priority.
SUPPORTED OPERATORS Supported operators
= | != | ~ | !~ | > | >= | < | <= | IS | IS NOT | IN | NOT IN | WAS | WAS IN | WAS NOT | WAS NOT IN | CHANGED |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
EXAMPLES Examples
Find subtasks where the parent has "the Blocker " priority.
| Code Block |
|---|
parentPriority = Blocker |
...
ParentIssueType
Search for subtasks with a parent of a particular issue type.
SUPPORTED OPERATORS Supported operators
= | != | ~ | !~ | > | >= | < | <= | IS | IS NOT | IN | NOT IN | WAS | WAS IN | WAS NOT | WAS NOT IN | CHANGED |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
EXAMPLES 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 Supported operators
= | != | ~ | !~ | > | >= | < | <= | IS | IS NOT | IN | NOT IN | WAS | WAS IN | WAS NOT | WAS NOT IN | CHANGED |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
EXAMPLES Examples
Find subtasks with a parent that is "the In Progress "status.
| Code Block |
|---|
parentStatus = "In Progress" |
ParentStatusCategory
Search for subtasks with a parent of a particular status category.
SUPPORTED OPERATORS Supported operators
= | != | ~ | !~ | > | >= | < | <= | IS | IS NOT | IN | NOT IN | WAS | WAS IN | WAS NOT | WAS NOT IN | CHANGED |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
EXAMPLESExamples
Find subtasks with a parent in the " 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 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".
| 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 that 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 that 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 that have "To Do" status category.
| Code Block |
|---|
subtaskStatusCategory = "To Do" |