Introduction

This app provides more powerful queries while searching issues or making filters. With the help of this app, managers could get more powerful reports by using filters and could optimize their workload.

Here is an example of a searching issue with the last commented by "Skywalker". It is shown in the screenshot.

You can find the query reference at the bottom of the page and also you can use the table of content in the below.

1 Attachments
2 Comments
3 Issue Links
4 Subtasks
5 Versions

JQL Queries

Attachments

Attachment Counts

Find issues according to the number of attachments.

Query	Supported Operators

Query	Supported Operators
attachmentsCount	= , != , < , > , <= , >=

Example:

Find issues having attachments:

1	attachmentsCount > 0

Attachment File Name

Find issues that have an attachment according to a file name.

Query	Supported Operators

Query	Supported Operators
attachmentFileName	~ , !~ , is , is not

Example:

Find issues that have an attachment whose name is "document".

1	attachmentsFileName ~ "document"

Attached By User

Find issues that have an attachment added by a particular user

Query	Supported Operators

Query	Supported Operators
attachedByUser	= , != , is , is not , in , not in

Example:

Find issues that have an attachment added by "Luke Skywalker".

1	attachedByUser = "Luke Skywalker"

Attached By User Full Name

Find issues that have an attachment added by a particular user. This query provides a partial match on the name of

the user.

Query	Supported Operators

Query	Supported Operators
attachedByUserFullName	~ , !~ , is , is not

Example:

Find issues that have an attachment added by "Luke".

1	attachedByUserFullName ~ "Luke"

Attachment Date

To search for issues according to attachment number.

Query	Supported Operators

Query	Supported Operators
attachedOnDate	endOfDay(), endOfMonth(), endOfWeek(), endOfYear(), lastLogin(), now(), startOfDay(), startOfMonth(), startOfWeek(), startOfYear()

Example:

Find issues that attachment has been added in this year.

1	attachedOnDate > startOfYear()

Attachment Size

To search for issues according to attachment size. (in MB)

Query	Supported Operators

Query	Supported Operators
attachmentSize	= , != , < , > , <= , >=

Example:

Find issues with attachments whose size are bigger than 1 MB.

1	attachmentSize > 1

Attachment Extension

Find issues that have an attachment according to a file extension.

Query	Supported Operators

Query	Supported Operators
attachmentExtension	= , != , is , is not , in , not in

Example:

Find issues with attachments with "PNG" extension.

1	attachmentExtension = "PNG"

Comments

Comments Count

Find issues according to the number of comments.

Query	Supported Operators

Query	Supported Operators
commentsCount	= , != , < , > , <= , >=

Example:

Find issues having comments:

1	commentsCount > 0

Comments By User

Find issues that have a comment added by a particular user

Query	Supported Operators

Query	Supported Operators
commentedByUser	= , != , is , is not , in , not in

Example:

Find issues that have a comment added by "Luke Skywalker".

1	commentedByUser = "Luke Skywalker"

Comments By User Full Name

Find issues that have a comment added by a particular user. This query provides a partial match on the name of

the user.

Query	Supported Operators

Query	Supported Operators
commentedByUserFullName	~ , !~ , is , is not

Example:

Find issues that have a comment added by "Luke".

1	commentedByUserFullName ~ "Luke"

Comments Date

To search for issues according to comment added date.

Query	Supported Operators

Query	Supported Operators
commentedDate	endOfDay(), endOfMonth(), endOfWeek(), endOfYear(), lastLogin(), now(), startOfDay(), startOfMonth(), startOfWeek(), startOfYear()

Example:

Find issues with comments that added today.

1	commentedDate >= startOfDay()

Comments Update Date

To search for issues according to comment edited date.

Query	Supported Operators

Query	Supported Operators
commentedUpdatedDate	endOfDay(), endOfMonth(), endOfWeek(), endOfYear(), lastLogin(), now(), startOfDay(), startOfMonth(), startOfWeek(), startOfYear()

Example:

Find issues with comments that edited today.

1	commentedUpdatedDate >= startOfDay()

Last Comment By User

Find issues that have the last comment added by a particular user

Query	Supported Operators

Query	Supported Operators
lastCommentedByUser	= , != , is , is not , in , not in

Example:

Find issues that have the last comment added by "Luke Skywalker".

1	lastCommentedByUser = "Luke Skywalker"

Last Comment By User Full Name

Find issues that have the last comment added by a particular user. This query provides a partial match on the name of

the user.

Query	Supported Operators

Query	Supported Operators
lastCommentedByUserFullName	~ , !~ , is , is not

Example:

Find issues with commented by "luke" lastly:

1	lastCommentedByUserFullName ~ "Luke"

Issue Links

Links Count

Find issues according to the number of links.

Query	Supported Operators

Query	Supported Operators
linksCounts	= , != , < , > , <= , >=

Example:

Find issues with links:

1	linksCount > 0

Links Issue

Find issues that link to a particular issue.

Query	Supported Operators

Query	Supported Operators
linksIssue	= , != , is , is not , not in , in

Example:

Find issues that link to "DEV-2":

1	linksIssue = "DEV-2"

Linked By Issue

Find issues that are linked by a particular issue.

Query	Supported Operators

Query	Supported Operators
linkedBy	= , != , is , is not , not in , in

Example:

Find issues that are linked by "TEST-2":

1	linkedBy = "TEST-2"

Linked Type

Find issues that are linked according to link type.

Query	Supported Operators

Query	Supported Operators
linkedType	= , != , is , is not , not in , in

Example:

Find issues that are linked whose type is "is blocked by":

1	linkedType = "is blocked by"

Links Type

Find issues that link according to link type.

Query	Supported Operators

Query	Supported Operators
linksType	= , != , is , is not , not in , in

Example:

Find issues that link whose type is "blocks":

1	linksType = "blocks"

Linked Issue Status

Find issues that are linked according to linked issue status.

Query	Supported Operators

Query	Supported Operators
linkedIssueStatus	= , != , is , is not , not in , in

Example:

Find issues that are linked whose issue status is "Open":

1	linkedIssueStatus = "Open"

Links Issue Status

Find issues that link according to link issue status.

Query	Supported Operators

Query	Supported Operators
linksIssueStatus	= , != , is , is not , not in , in

Example:

Find issues that link whose issue status is "Open":

1	linksIssueStatus = "Open"

Linked Issue Status Category

Find issues that are linked according to linked issue status category.

Query	Supported Operators

Query	Supported Operators
linkedIssueStatusCategory	= , != , is , is not , not in , in

Example:

Find issues that are linked whose issue status category is "In Progress":

1	linkedIssueStatusCategory = "In Progress"

Links Issue Status Category

Find issues that link according to link issue status category.

Query	Supported Operators

Query	Supported Operators
linksIssueStatusCategory	= , != , is , is not , not in , in

Example:

Find issues that link whose issue status category is "In Progress":

1	linkedIssueStatusCategory = "In Progress"

Linked Issue Type

Find issues that are linked according to linked issue status type.

Query	Supported Operators

Query	Supported Operators
linkedIssueType	= , != , is , is not , not in , in

Example:

Find issues that are linked whose issue type is "Sub-task":

1	linkedIssueType = "Sub-task"

Links Issue Type

Find issues that link according to linked issue status type.

Query	Supported Operators

Query	Supported Operators
linksIssueType	= , != , is , is not , not in , in

Example:

Find issues that link whose issue type is "Sub-task":

1	linksIssueType = "Sub-task"

Linked Issue Priority

Find issues that are linked according to linked issue status priority.

Query	Supported Operators

Query	Supported Operators
linkedIssuePriority	= , != , is , is not , not in , in

Example:

Find issues that are linked whose issue priority is "Medium":

1	linkedIssuePriority = Medium

Links Issue Priority

Find issues that link according to linked issue status priority.

Query	Supported Operators

Query	Supported Operators
linksIssuePriority	= , != , is , is not , not in , in

Example:

Find issues that link whose issue priority is "Medium":

1	linksIssuePriority = Medium

Links Issues Count

Find issues that link according to the number of links.

Query	Supported Operators

Query	Supported Operators
linksIssuesCount	= , != , < , > , <= , >=

Example:

Find issues with outward link:

1	linksIssuesCount > 0

Linked Issues Count

Find issues that are linked according to number of links.

Query	Supported Operators

Query	Supported Operators
linkedByIssuesCount	= , != , < , > , <= , >=

Example:

Find issues with inward link:

1	linkedByIssuesCount > 0

JQL Reference

Introduction

JQL Queries

Attachments

Comments

Issue Links