The instructions on this page describe how to execute a JQL search using JQL Search Extensions.

1 Subtasks JQL functions
- 1.1 ParentsOfSubtasksInQuery
- 1.2 SubtasksOfParentsInQuery
2 Subtasks JQL Keywords
- 2.1 ParentSummary
- 2.2 ParentPriority
- 2.3 ParentIssueType
- 2.4 ParentStatus
- 2.5 ParentStatusCategory
- 2.6 SubtasksCount
- 2.7 SubtaskSummary
- 2.8 SubtaskKey
- 2.9 SubtaskPriority
- 2.10 SubtaskIssueType
- 2.11 SubtaskStatus
- 2.12 SubtaskStatusCategory

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 subtasks
issue 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 parents
issue 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

=	!=	~	!~	>	>=	<	<=	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 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

=	!=	~	!~	>	>=	<	<=	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

=	!=	~	!~	>	>=	<	<=	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

=	!=	~	!~	>	>=	<	<=	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".

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

=	!=	~	!~	>	>=	<	<=	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.

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

=	!=	~	!~	>	>=	<	<=	IS	IS NOT	IN	NOT IN	WAS	WAS IN	WAS NOT	WAS NOT IN	CHANGED

EXAMPLES

Find issues with subtasks.

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

=	!=	~	!~	>	>=	<	<=	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".

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

=	!=	~	!~	>	>=	<	<=	IS	IS NOT	IN	NOT IN	WAS	WAS IN	WAS NOT	WAS NOT IN	CHANGED

EXAMPLES

Find issues with subtask with key 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

=	!=	~	!~	>	>=	<	<=	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.

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

=	!=	~	!~	>	>=	<	<=	IS	IS NOT	IN	NOT IN	WAS	WAS IN	WAS NOT	WAS NOT IN	CHANGED

EXAMPLES

Find issues with subtasks of issue type "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

=	!=	~	!~	>	>=	<	<=	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".

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

=	!=	~	!~	>	>=	<	<=	IS	IS NOT	IN	NOT IN	WAS	WAS IN	WAS NOT	WAS NOT IN	CHANGED

EXAMPLES

Find issues that have "To Do" status category.