Issues with subtasks

The examples on this page describe how to build a JQL search using JQL Search Extensions.

On this page: 1 Issues with subtasks JQL functions 1.1 parentsOfSubtasksInQuery() 2 Issues with subtasks JQL keywords 2.1 subtasksCount 2.2 subtaskSummary 2.3 subtaskKey 2.4 subtaskPriority 2.5 subtaskIssueType 2.6 subtaskStatus 2.7 subtaskStatusCategory

On this page: 1 Issues with subtasks JQL functions 1.1 parentsOfSubtasksInQuery() 2 Issues with subtasks JQL keywords 2.1 subtasksCount 2.2 subtaskSummary 2.3 subtaskKey 2.4 subtaskPriority 2.5 subtaskIssueType 2.6 subtaskStatus 2.7 subtaskStatusCategory

Issues with subtasks JQL functions

JQL functions are accessible from the Extended Search page or Extended Search filters in Jira advanced search. When using functions, the issues returned are based on the subquery defined in parentheses.

parentsOfSubtasksInQuery()

For a given JQL subquery, it finds the 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 subtasksSubtasks JQL keywords

Issues with subtasks JQL keywords

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.

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

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

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

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

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

Examples

Find issues with subtasks of issue type Spike.

subtaskIssueType = Spike

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.

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

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

Examples

Find issues that have subtasks in the To Do status.

subtaskStatusCategory = "To Do"