Info

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

JQL aliases added by the app are accessible from Jira advanced search. JQL functions are accessible from Extended Search screen or via Extended Search filters in Jira advanced search.

JQL Functions

Extended search functions are invoked just like standard JQL functions. They are autocompleted after you start typing issue in…

ExactTextMatch

Info
JQL functions are accessible only from Extended Search

Matches issues that contain the text in the summary or description. Takes a case-sensitive text as an argument.

Example:
issue in exactTextMatch("text")

ExactTextMatchCaseInsensitive

Info
JQL functions are accessible only from Extended Search

Similar to exactTextMatch but is case insensitive.

Example:
issue in exactTextMatchCaseInsensitive("tExT") matches issues with TEXT, Text, tEXT etc.

WildcardMatch

Info
JQL functions are accessible only from Extended Search

Matches issues with a field containing a specified text (case-sensitive). You can use the asterisk (*) to match any text.

Examples:
issue in wildcardMatch("summary", "Hello*")
issue in wildcardMatch("fixVersion", "12.0*")
issue in wildcardMatch("labels", "*Marketing*")
issue in wildcardMatch("component", "Business*")
issue in wildcardMatch("category", "MyOrg*")

The star symbol can be placed anywhere in the text – you can even place more than one.

Regex

Info
JQL functions are accessible only from Extended Search

Use the full power of regular expressions to match field values. Regular expressions are strict and case sensitive.

Examples:

issue in regex("summary", "^Hello.*") matches issues with summaries starting with
issue in regex("fixVersion", "12.[0-5]") matches issues with versions from 12.0 to 12.5
issue in regex("labels", "Marketing$")matches issues with labels that end with Marketing
issue in regex("component", "Business.*")
issue in regex("category", "MyOrg.*")
issue in regex("Acceptance checklist", "can proceed") matches issues that have any checkbox with can proceed checked
issue in regex("Custom cascading select list", "- Georgia") matches issues with a cascading select field with Georgia as a child value

EpicsOfChildrenInQuery

Info
JQL functions are accessible only from Extended Search

For a given JQL subquery it finds the epics of the resulting issues.

Examples:

issue in epicsOfChildrenInQuery("'Team Name'='My great team'") and status='To Do' finds my team’s epics that are still in progress
issue in epicsOfChildrenInQuery("assignee=currentUser() AND updated>-1d") finds epics of my issues that where updated over the last day

ChildrenOfEpicsInQuery

Info
JQL functions are accessible only from Extended Search

For a given JQL subquery it finds the children of the resulting epics.

Examples:

issue in childrenOfEpicsInQuery("resolution is not empty") AND resolution is empty finds issues in progress that belong to an epic which has finished
issue in childrenOfEpicsInQuery("fixVersion='21.0.1' AND component=UI AND labels='review'") finds children of epics with particular version, component and label

LinkedIssuesOfQuery

Info
JQL functions are accessible only from Extended Search

For a given JQL subquery and an optional link type, it finds issues linked to resulting issues.

issue in linkedIssuesOfQuery("project=ACME", "is blocked by") finds issues that my project ACME is blocked by
issue in linkedIssuesOfQuery("project=ACME", "blocks") finds issues that project ACME blocks
issue in linkedIssuesOfQuery("type=Epic AND status='To Do'") finds issues that are linked in any way with epics that are in progress

ParentsOfSubtasksInQuery

Info
JQL functions are accessible only from Extended 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 subtasks
issue in parentsOfSubtasksInQuery("assignee=currentUser()") finds parents of my subtasks

SubtasksOfParentsInQuery

Info
JQL functions are accessible only from Extended Search

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

ParentsOfIssuesInQuery

Info
JQL functions are accessible only from Extended Search

For a given JQL subquery it finds parents of resulting issues. It supports Advanced Roadmaps “Parent Link” and a standard Jira hierachy Epic → Story → Subtask.

Also have a look at ParentsOfIssuesInQueryRecursive.

Examples:

issue in parentsOfIssuesInQuery("project='ACME' and type=Epic") finds all parents of epics in project ACME. Parents of epics are usually called Initiative.
issue in parentsOfIssuesInQuery("assignee=currentUser()") finds parents of all of my tickets.

ParentsOfIssuesInQueryRecursive

Info
JQL functions are accessible only from Extended Search

For a given JQL subquery it finds issues in the hierarchy above the resulting issues up to an optional depth. It supports Advanced Roadmaps “Parent Link” and a standard Jira hierachy Epic → Story → Subtask.

Examples:

issue in parentsOfIssuesInQueryRecursive("project='ACME' and type=Epic") finds all parents of epics in project ACME, and parents of parents, and so on. Parents of epics are usually called Initiative.
issue in parentsOfIssuesInQuery("assignee=currentUser() and issueType in subtaskIssueTypes()", 2) finds parents of my subtasks and epics of the parents, skips anything above epics.

ChildrenOfIssuesInQuery

Info
JQL functions are accessible only from Extended Search

For a given JQL subquery it finds children of resulting issues. It supports Advanced Roadmaps “Parent Link” and a standard Jira hierachy Epic → Story → Subtask. Also have a look at ChildrenOfIssuesInQueryRecursive.

Examples:

issue in childrenOfIssuesInQuery("project='ACME' and type=Initiative") finds all epics in initiatives in project ACME.
issue in childrenOfIssuesInQuery("assignee=currentUser()") finds children of all of my tickets.

ChildrenOfIssuesInQueryRecursive

Info
JQL functions are accessible only from Extended Search

For a given JQL subquery it finds issues in the hierarchy below the resulting issues up to an optional depth. It supports Advanced Roadmaps “Parent Link” and a standard Jira hierachy Epic → Story → Subtask.

Examples:

issue in childrenOfIssuesInQueryRecursive("project='ACME' and type=Initiative") finds all epics, stories and subtasks in initiatives in project ACME.
issue in childrenOfIssuesInQueryRecursive("assignee=currentUser() and type=Initiative", 2) finds epics and stories of all of my epics and skips the subtasks.

NextSprint

Info
JQL functions are accessible only from Extended Search

Finds issues that are planned for the next sprint. Pass a Jira board name or board id as an argument.

issue in nextSprint("ACME board")

issue in nextSprint(10)

Info
Only sprints that were originally created on the board are included in the search

PreviousSprint

Info
JQL functions are accessible only from Extended Search

Finds issues that were part of a previous sprint. Pass a Jira board name or board id as an argument.

issue in previousSprint("ACME board")

issue in previousSprint(10)

Info
Only sprints that were originally created on the board are included in the search

AddedToSprintAfterStart

Info
JQL functions are accessible only from Extended Search

Finds issues that were added to the sprint after the sprint was started. Handy to identify a scope creep in the sprint.

Pass a Jira board name or board id as a first argument.

You can optionally pass a sprint name or sprint id as a second argument. By default the active sprint is used in the search.

issue in addedToSprintAfterStart("ACME board") issues added after the current sprint was started

issue in addedToSprintAfterStart("ACME board", "ACME Sprint 5") issues added after sprint 5 was started

issue in addedToSprintAfterStart(10, 55) you can also use board and sprint ids

Info
Only sprints that were originally created on the board are included in the search

Permissions and feature availability to users

JQL Search Extensions Extended Search screen is a global permission that controls a visibility of Extended search feature. By defaults this permission is granted to all Jira users.

Table of Contents

JQL aliases

Searching for attachments

AttachmentContent

Search for issues that have attachments with the provided phrase. Search functionality will go find the provided phrase in PDF, Word (doc, docx), PowerPoint (ppt, pptx), Excel (xls and xslx), OpenOffice and PlainText.

Please keep in mind that it is sometimes impossible to extract text from files. Complex PDFs and Excel files are the most problematic. Having said that in over 99% of cases indexing is successful.

SUPPORTED OPERATORS

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

EXAMPLES

Find issues with attachments containing the phrase "specification".

Code Block
attachmentContent ~ "specification"

AttachmentsCount

Search for issues that have a particular attachments number.

SUPPORTED OPERATORS

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

EXAMPLES

Find issues with attachments:

Code Block
attachmentsCount > 0

AttachedByUser

Search for issues with attachments added by a particular user.

SUPPORTED OPERATORS

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

EXAMPLES

Find issues with attachments added by "Jane Potter".

Code Block
attachedByUser = "Jane Potter"

AttachedOnDate

Search for issues with attachments added on a particular date. This JQL keyword works with date related JQL functions:

endOfDay()
endOfMonth()
endOfWeek()
endOfYear()
lastLogin()
now()
startOfDay()
startOfMonth()
startOfWeek()
startOfYear()

Also see:

SUPPORTED OPERATORS

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

EXAMPLES

Find issues with attachments attached on particular dates.

Code Block
attachedOnDate >= "2016/03/14" and attachedOnDate < "2016/03/15" attachedOnDate < now()

AttachmentExtension

Search for issues with attachments with a particular extension.

SUPPORTED OPERATORS

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

EXAMPLES

Find issues with attachments with PNG of JPG extensions.

Code Block
attachmentExtension = "png" OR attachmentExtension = "jpg"

AttachmentName

Search for issues with attachments with a particular name.

SUPPORTED OPERATORS

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

EXAMPLES

Find issues with an attachment name containing "screenshot".

Code Block
attachmentName ~ "screenshot"

Searching for subtasks

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

EXAMPLES

Find subtasks which parents summary contains text "Test"

Code Block
parentSummary ~ "Test"

ParentPriority

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.

Code Block
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

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

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

Code Block
parentStatus = "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

EXAMPLES

Find subtasks with a parent in "To Do" status category.

Code Block
parentStatusCategory= "To Do"

Searching for issues with subtasks

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

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

EXAMPLES

Find issues which 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 which have "To Do" status category.

Code Block
subtaskStatusCategory = "To Do"

Searching for comments

CommentsCount

Search for issues that have a particular number of comments.

SUPPORTED OPERATORS

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

EXAMPLES

Find issues with comments

Code Block
commentsCount > 0

CommentedByUser

Search for issues that were commented by a particular user.

SUPPORTED OPERATORS

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

EXAMPLES

Find issues which were commented by Jane Potter.

Code Block
commentedByUser = "Jane Potter"

CommentLastCreatedBy

Search for issues that were last commented by a particular user.

SUPPORTED OPERATORS

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

EXAMPLES

Find issues which were last commented by admin.

Code Block
commentLastCreatedBy= "admin"

CommentLastUpdatedBy

Search for issues with a comment last updated by a particular user.

SUPPORTED OPERATORS

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

EXAMPLES

Find issues with a comment last updated by admin.

Code Block
commentLastUpdatedBy= "admin"

CommentedOnDate

Search for issues which were commented on a particular date. This keyword works with date related JQL functions:

endOfDay()
endOfMonth()
endOfWeek()
endOfYear()
lastLogin()
now()
startOfDay()
startOfMonth()
startOfWeek()
startOfYear()

Also see:

SUPPORTED OPERATORS

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

EXAMPLES

Find issues which were commented on 13th or 14th of March, 2016

Code Block
commentUpdatedDate >= "2016/03/13" AND commentUpdatedDate < "2016/03/15" commentedOnDate < now()

CommentedUpdatedOnDate

Search for issues which comment was updated on a particular date. This keyword works with date related JQL functions:

endOfDay()
endOfMonth()
endOfWeek()
endOfYear()
lastLogin()
now()
startOfDay()
startOfMonth()
startOfWeek()
startOfYear()

Also see:

SUPPORTED OPERATORS

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

EXAMPLES

Find issues with comments updated on 13th or 14th of March, 2016

Code Block
commentUpdatedDate >= "2016/03/13" AND commentUpdatedDate < "2016/03/15" commentUpdatedDate < now()

Searching for versions

AffectedVersionsArchived

Search for issues with affected version archived.

SUPPORTED OPERATORS

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

EXAMPLES

Find issues which affected version is archived

Code Block
affectedVersionsArchived > 0

AffectedVersionsReleased

Search for issues with affected version released.

SUPPORTED OPERATORS

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

EXAMPLES

Find issues which affected version is released.

Code Block
affectedVersionsReleased > 0

Find issues which no affected version is released.

Code Block
affectedVersionsReleased = 0

AffectedVersionsOpened

Search for issues with affected version opened.

SUPPORTED OPERATORS

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

EXAMPLES

Find issues which affected version is opened.

Code Block
affectedVersionsOpened > 0

AffectedVersionsCount

Search for issues with a particular number of affected versions.

SUPPORTED OPERATORS

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

EXAMPLES

Find issues which have affected versions.

Code Block
affectedVersionsCount > 0

AffectedVersionReleaseDate

Search for issues which affected version was released on a particular date. This keyword works with date related JQL functions:

endOfDay()
endOfMonth()
endOfWeek()
endOfYear()
lastLogin()
now()
startOfDay()
startOfMonth()
startOfWeek()
startOfYear()

SUPPORTED OPERATORS

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

EXAMPLES

Find issues which affected version was released on 13th or 14th of March, 2016

Code Block
affectedVersionReleasedDate = "2016/03/14" OR affectedVersionReleasedDate = "2016/03/13" affectedVersionReleasedDate in ("2016/03/14", "2016/03/13") affectedVersionReleasedDate < now()

FixVersionsArchived

Search for issues with fix version archived.

SUPPORTED OPERATORS

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

EXAMPLES

Find issues which affected version is archived

Code Block
fixVersionsArchived > 0

FixVersionsReleased

Search for issues with fix version released.

SUPPORTED OPERATORS

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

EXAMPLES

Find issues which fix version is released.

Code Block
fixVersionsReleased > 0

Find issues with no fix version released.

Code Block
fixVersionsReleased = 0

FixVersionsOpened

Search for issues with fix version opened.

SUPPORTED OPERATORS

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

EXAMPLES

Find issues which fix version is opened.

Code Block
fixVersionsOpened > 0

FixVersionsCount

Search for issues with a particular number of fix versions.

SUPPORTED OPERATORS

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

EXAMPLES

Find issues which have fix versions.

Code Block
fixVersionsCount > 0

FixVersionReleaseDate

Search for issues which fix version was released on a particular date. This keyword works with date related JQL functions:

endOfDay()
endOfMonth()
endOfWeek()
endOfYear()
lastLogin()
now()
startOfDay()
startOfMonth()
startOfWeek()
startOfYear()

SUPPORTED OPERATORS

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

EXAMPLES

Find issues which fix version was released on 13th or 14th of March, 2016

Code Block
fixVersionReleaseDate = "2016/03/14" OR fixVersionReleaseDate = "2016/03/13" fixVersionReleaseDate in ("2016/03/14", "2016/03/13") fixVersionReleaseDate < now()

Searching for links

LinksCount

Search for issues with a particular number of links.

SUPPORTED OPERATORS

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

EXAMPLES

Find issues which have links.

Code Block
linksCount > 0

LinkedBy

Search for issues that are linked by particular issues.

SUPPORTED OPERATORS

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

EXAMPLES

Find issues which were linked by JQL-3 or JQL-5.

Code Block
linkedBy in (JQL-3, JQL-5)

LinksIssue

Search for issues which links a particular issue.

SUPPORTED OPERATORS

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

EXAMPLES

Find issues which link JQL-3 or JQL-5

Code Block
linksIssue in (JQL-3, JQL-5)

LinkType

Search for issues which have a particular link type.

SUPPORTED OPERATORS

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

EXAMPLES

Find all issues which are blocked by another issue

Code Block
linkType = "is blocked by"

LinkedIssueStatus

Search for issues which are linked or link issues with a particular status.

SUPPORTED OPERATORS

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

EXAMPLES

Find all issues which are linked by issues in "To Do" status.

Code Block
linkedIssueStatus = "To Do"

LinkedIssueStatusCategory

Search for issues which are linked or link issues with a particular status category.

SUPPORTED OPERATORS

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

EXAMPLES

Find all issues which are linked or link issues in status category "Done"

Code Block
linkedIssueStatusCategory = Done

LinkedIssueType

Search for issues which are linked or link issue with a particular issue type.

SUPPORTED OPERATORS

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

EXAMPLES

Find all issues which are linked by Bugs.

Code Block
linkedIssueType = Bug

LinkedIssuePriority

Search for issues which are linked or links issues with a particular priority.

SUPPORTED OPERATORS

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

EXAMPLES

Find all issues which are linked by high priority issues.

Code Block
linkedIssuePriority = "High"

LinksIssuesCount

Search for issues which link to a particular number of issues.

SUPPORTED OPERATORS

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

EXAMPLES

Find issues which link more than 5 issues.

Code Block
linksIssuesCount > 5

LinkedByIssuesCount

Search for issues which are linked by a particular number of issues.

SUPPORTED OPERATORS

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

EXAMPLES

Find issues which are linked by more than 10 issues.

Code Block
linkedByIssueCount > 10

LinkedByIssueProject

Search for issues which are linked by issues from a particular project.

SUPPORTED OPERATORS

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

EXAMPLES

Find all issues which are linked by issues from project JQL

Code Block
linkedByIssueProject = JQL

LinksIssueProject

Search for issues which link to issues from a particular project.

SUPPORTED OPERATORS

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

EXAMPLES

Find all issues which link to issues from project JQL

Code Block

language	none

linksIssueProject= JQL

Searching for remote links

Remote links are now called web links in the Jira user interface.

RemoteLinkUrl

Search for issues which contain the remote link with the URL.

SUPPORTED OPERATORS

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

EXAMPLES

Find issues which contain both URLs:

Code Block
remoteLinkUrl in ("http://digitaltoucan.com/our-products/jql-search-extensions/", "https://google.com")

RemoteLinkUrlPartialMatch

Like remoteLinkUrl but supports partial match. All the slashes are replaced with spaces. Words match will differ depending on your word stemming configuration in Jira.

SUPPORTED OPERATORS

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

EXAMPLES

Find issues which contain digitaltoucan in the URL.

Code Block
remoteLinkUrlPartialMatch ~ digitaltoucan

RemoteLinkApplicationName

Search for issues which contain the remote link to an application like Confluence.

SUPPORTED OPERATORS

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

EXAMPLES

Find issues which link to confluence:

Code Block
remoteLinkApplicationName="Confluence"

RemoteLinkApplicationType

Similar to remoteLinkApplicationName but matches the application identifier.

SUPPORTED OPERATORS

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

EXAMPLES

Find issues which link to confluence:

Code Block
remoteLinkApplicationType="com.atlassian.confluence"

RemoteLinkHost

Matches the host part of the remote link.

SUPPORTED OPERATORS

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

EXAMPLES

Find issues which link to jqlsearchextensions.atlassian.net:

Code Block
remoteLinkHost="jqlsearchextensions.atlassian.net"

RemoteLinkQuery

Matches the query part of the remote link.

SUPPORTED OPERATORS

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

EXAMPLES

Find issues which link to URLs like http://host.com/path?pageId=1234

Code Block
remoteLinkQuery="pageId=1234"

RemoteLinkPath

Matches the path part of the remote link.

SUPPORTED OPERATORS

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

EXAMPLES

Find issues which link to URLs like http://host.com/path?pageId=1234

Code Block
remoteLinkPath="/path"

RemoteLinkTitle

Find issues with a remote link title

SUPPORTED OPERATORS

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

EXAMPLES

Find issues with title My Page

Code Block
remoteLinkTitle="My Page"

RemoteLinkTitlePartialMatch

Find issues that contain text in the remote link title. Words match will differ depending on your word stemming configuration in Jira.

SUPPORTED OPERATORS

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

EXAMPLES

Find issues which contain Digital Toucan in the remote link title:

Code Block
remoteLinkTitlePartialMatch ~ "Digital Toucan"

RemoteLinkRelationship

Find issues with a remote link of a particular type.

SUPPORTED OPERATORS

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

EXAMPLES

Find issues with that were mentioned in Confluence.

Code Block
remoteLinkRelationship="mentioned in"

RemoteLinksCount

Search for issues that contain a particular number of remote links.

SUPPORTED OPERATORS

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

EXAMPLES

Find issues with more than 5 remote links:

Code Block
remoteLinksCount > 5

Searching for updates and time logs

UpdatedByUsersCount

Search for issues which were updated by a particular number of users.

SUPPORTED OPERATORS

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

EXAMPLES

Find issues updated by more than 5 users.

Code Block
updatedByUsersCount > 5

UpdatedBy

Search for issues which were updated by a particular user/users.

SUPPORTED OPERATORS

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

EXAMPLES

Find issues which were updated by Helen or Daniel:

Code Block
updatedBy in ("helen", "daniel")

TransitionedBy

Search for issues which were transitioned by a particular user/users.

SUPPORTED OPERATORS

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

EXAMPLES

Find issues which were transitioned by Helen or Daniel:

Code Block
transitionedBy in ("daniel", "helen")

LoggedTimeBy

Search for issues on which particular users reported time.

SUPPORTED OPERATORS

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

EXAMPLES

Find issues on which Helen or Daniel reported time.

Code Block
loggedTimeBy in ("daniel", "helen")

UpdatedOnDates

Search for issues which were updated on a particular date. This keyword works with date related JQL functions:

endOfDay()
endOfMonth()
endOfWeek()
endOfYear()
lastLogin()
now()
startOfDay()
startOfMonth()
startOfWeek()
startOfYear()

Also see:

SUPPORTED OPERATORS

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

EXAMPLES

Find issues which were updated on 13th or 14th of March, 2016

Code Block
updatedOnDates in ("2016/03/14", "2016/03/13") updatedOnDates < now()

LastUpdatedBy

Search for issues that were last updated by a particular user.

SUPPORTED OPERATORS

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

EXAMPLES

Find issues that were last updated by admin.

Code Block
lastUpdatedBy="admin"

Searching for projects

MovedProjects

Search for issues which were moved between projects.

SUPPORTED OPERATORS

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

EXAMPLES

Find issues which belonged to a different project and were moved. For instance, the following query finds issues which were in projects SEARCH and DATA.

Code Block
movedProjects in ("SEARCH", "DATA")

Warning: Due to Jira plugin system limitation it is impossible to build a command which supports searching from/to. The query will find all issues which were in SEARCH or DATA at some point.

MovedProjectsCount

Search for issues which were moved between a number of projects.

SUPPORTED OPERATORS

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

EXAMPLES

Find issues which were moved between 2 or more projects.

Code Block
movedProjectsCount >= 2

Searching for field comparisons

HasSameUpdatedAndCreatedDate

Search for issues which were not updated since creation

SUPPORTED OPERATORS

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

EXAMPLES

Code Block
hasSameUpdatedAndCreatedDate = "true"

HasSameAssigneeAndReporter

Search for issues with the same assignee and reporter

SUPPORTED OPERATORS

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

EXAMPLES

Code Block
hasSameAssigneeAndReporter = "true"

HasSameVersions

Search for issues with the same fix and affected versions.

SUPPORTED OPERATORS

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

EXAMPLES

Code Block
hasSameVersions = "true"

Epic

The following JQL extensions work on epics only

issuesInEpicCount - search for epics with a particular number of child issues regardless of issue type
bugsInEpicCount - search for epics with a particular number of bugs
storiesInEpicCount - search for epics with a particular number of stories
issuesInEpicToDoCount - search for epics with a particular number of child issues in "To Do" status category
issuesInEpicInProgressCount - search for epics with a particular number of child issues in "In Progress" status category
issuesInEpicDoneCount - search for epics with a particular number of child issues in "Done" status category
bugsInEpicToDoCount - search for epics with a particular number of bugs in "To Do" status category
bugsInEpicInProgressCount - search for epics with a particular number of bugs in "In Progress" status category
bugsInEpicDoneCount - search for epics with a particular number of bugs in "Done" status category
storiesInEpicToDoCount - search for epics with a particular number of stories in "To Do" status category
storiesInEpicInProgressCount - search for epics with a particular number of stories in "in Progress" status category
storiesInEpicDoneCount - search for epics with a particular number of stories in "Done" status category

Note on aggregation of dates

In case there are more than 100 timestamps to be stored for a particular date related JQL keyword the timestamps will be aggregated by day with time reset to start of the day (midnight). This means that the keyword won't be time sensitive, it will only be date sensitive for a particular Jira issue.

This applies to the following keywords:

attachedOnDate
updatedOnDates
commentedOnDate
commentUpdatedDate

For example if the issue was updated 150 times over a course of 5 days, the updatedOnDates queries for that particular issue will see 5 timestamps for each day only.

Note on dates with time

Most Jira date fields also contain the time component. Jira doesn’t currently support convenient use of = and IN operators with timestamps. You should use the comparison operators instead: <, <=, >, >=

The following JQL aliases contain timestamps:

attachedOnDate
updatedOnDates
commentedOnDate
commentUpdatedDate

For example, this query fails to find issues commented on a particular day:
commentedOnDate="2020/06/01"
Jira returns an empty result even if there are issues that were commented on 1 June.

The workaround is to search for the range of dates:
commentedOnDate>="2020/06/01" AND commentedOnDate<"2020/06/02"
Jira returns issues that were commented between midnight 1 June and midnight 2 June.

Page Comparison

Versions Compared

Old Version 76

New Version 77

Key

JQL Functions

ExactTextMatch

ExactTextMatchCaseInsensitive

WildcardMatch

Regex

EpicsOfChildrenInQuery

ChildrenOfEpicsInQuery

LinkedIssuesOfQuery

ParentsOfSubtasksInQuery

SubtasksOfParentsInQuery

ParentsOfIssuesInQuery

ParentsOfIssuesInQueryRecursive

ChildrenOfIssuesInQuery

ChildrenOfIssuesInQueryRecursive

NextSprint

PreviousSprint

AddedToSprintAfterStart

Permissions and feature availability to users

JQL aliases

Searching for attachments

AttachmentContent

AttachmentsCount

AttachedByUser

AttachedOnDate

AttachmentExtension

AttachmentName

Searching for subtasks

ParentSummary

ParentPriority

ParentIssueType

ParentStatus

ParentStatusCategory

Searching for issues with subtasks

SubtasksCount

SubtaskSummary

SubtaskKey

SubtaskPriority

SubtaskIssueType

SubtaskStatus

SubtaskStatusCategory

Searching for comments

CommentsCount

CommentedByUser

CommentLastCreatedBy

CommentLastUpdatedBy

CommentedOnDate

CommentedUpdatedOnDate

Searching for versions

AffectedVersionsArchived

AffectedVersionsReleased

AffectedVersionsOpened

AffectedVersionsCount

AffectedVersionReleaseDate

FixVersionsArchived

FixVersionsReleased

FixVersionsOpened

FixVersionsCount

FixVersionReleaseDate

Searching for links

LinksCount

LinkedBy

LinksIssue

LinkType

LinkedIssueStatus

LinkedIssueStatusCategory

LinkedIssueType

LinkedIssuePriority

LinksIssuesCount

LinkedByIssuesCount

LinkedByIssueProject

LinksIssueProject

Searching for remote links

RemoteLinkUrl

RemoteLinkUrlPartialMatch

RemoteLinkApplicationName