Issues with subtasks

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

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.

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 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.

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.

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 subtasks in the To Do status.