The instructions on this page describe how to execute a JQL search using JQL Search Extensions. |
JQL functions are accessible from Extended Search screen or via Extended Search filters in Jira advanced search. |
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
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
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"
parentSummary ~ "Test" |
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.
parentPriority = Blocker |
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" |
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".
parentStatus = "In Progress" |
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.
parentStatusCategory= "To Do" |
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 |
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"
subtaskSummary ~ "Test" |
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 |
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.
subtaskPriority = Blocker |
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" |
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".
subtaskStatus = "In Progress" |
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.
subtaskStatusCategory = "To Do" |