JQL Reference

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.

JQL Queries

Attachments

  • Attachment Counts

Find issues according to the number of attachments. 

QuerySupported Operators
attachmentsCount= , != , < , > , <= , >=

Example:

Find issues having attachments:

1attachmentsCount > 0


  • Attachment File Name

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

QuerySupported Operators
attachmentFileName~ , !~ , is , is not

Example:

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

1attachmentsFileName ~ "document"


  • Attached By User

Find issues that have an attachment added by a particular user

QuerySupported Operators
attachedByUser= , != , is , is not , in , not in 

Example:

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

1attachedByUser = "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. 

QuerySupported Operators
attachedByUserFullName~ , !~ , is , is not

Example:

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

1attachedByUserFullName ~ "Luke"
  • Attachment Date

To search for issues according to attachment number.

QuerySupported Operators
attachedOnDate

endOfDay(), endOfMonth(), endOfWeek(), endOfYear(), lastLogin(), 

now(), startOfDay(), startOfMonth(), startOfWeek(), startOfYear()

Example:

Find issues that attachment has been added in this year.

1attachedOnDate > startOfYear()
  • Attachment Size

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

QuerySupported Operators
attachmentSize= , != , < , > , <= , >=

Example:

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

1attachmentSize > 1


  • Attachment Extension

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

QuerySupported Operators
attachmentExtension= , != , is , is not , in , not in

Example:

Find issues with attachments with "PNG" extension.

1attachmentExtension = "PNG"


Comments

  • Comments Count

Find issues according to the number of comments. 

QuerySupported Operators
commentsCount= , != , < , > , <= , >=

Example:

Find issues having comments:

1commentsCount > 0


  • Comments By User

Find issues that have a comment added by a particular user

QuerySupported Operators
commentedByUser= , != , is , is not , in , not in

Example:

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

1commentedByUser = "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. 

QuerySupported Operators
commentedByUserFullName~ , !~ , is , is not

Example:

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

1commentedByUserFullName ~ "Luke"


  • Comments Date

To search for issues according to comment added date.

QuerySupported Operators
commentedDate

endOfDay(), endOfMonth(), endOfWeek(), endOfYear(), lastLogin(), 

now(), startOfDay(), startOfMonth(), startOfWeek(), startOfYear()

Example:

Find issues with comments that added today.

1commentedDate >= startOfDay()


  • Comments Update Date

To search for issues according to comment edited date.

QuerySupported Operators
commentedUpdatedDate

endOfDay(), endOfMonth(), endOfWeek(), endOfYear(), lastLogin(), 

now(), startOfDay(), startOfMonth(), startOfWeek(), startOfYear()

Example:

Find issues with comments that edited today.

1commentedUpdatedDate >= startOfDay()


  • Last Comment By User

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

QuerySupported Operators
lastCommentedByUser= , != , is , is not , in , not in

Example:

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

1lastCommentedByUser = "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. 

QuerySupported Operators
lastCommentedByUserFullName~ , !~ , is , is not

Example:

Find issues with commented by "luke" lastly:

1lastCommentedByUserFullName ~ "Luke"


  • Links Count

Find issues according to the number of links. 

QuerySupported Operators
linksCounts= , != , < , > , <= , >=

Example:

Find issues with links:

1linksCount > 0
  • Links Issue

Find issues that link to a particular issue.

QuerySupported Operators
linksIssue= , != , is , is not , not in , in

Example:

Find issues that link to "DEV-2":

1linksIssue = "DEV-2"
  • Linked By Issue

Find issues that are linked by a particular issue.

QuerySupported Operators
linkedBy= , != , is , is not , not in , in

Example:

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

1linkedBy = "TEST-2"
  • Linked Type

Find issues that are linked according to link type.

QuerySupported Operators
linkedType= , != , is , is not , not in , in

Example:

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

1linkedType = "is blocked by"
  • Links Type

Find issues that link according to link type.

QuerySupported Operators
linksType= , != , is , is not , not in , in

Example:

Find issues that link whose type is "blocks":

1linksType = "blocks"
  • Linked Issue Status

Find issues that are linked according to linked issue status.

QuerySupported Operators
linkedIssueStatus
= , != , is , is not , not in , in

Example:

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

1linkedIssueStatus = "Open"
  • Links Issue Status

Find issues that link according to link issue status.

QuerySupported Operators
linksIssueStatus
= , != , is , is not , not in , in

Example:

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

1linksIssueStatus = "Open"
  • Linked Issue Status Category

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

QuerySupported Operators
linkedIssueStatusCategory
= , != , is , is not , not in , in

Example:

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

1linkedIssueStatusCategory = "In Progress"
  • Links Issue Status Category

Find issues that link according to link issue status category.

QuerySupported Operators
linksIssueStatusCategory
= , != , is , is not , not in , in

Example:

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

1linkedIssueStatusCategory = "In Progress"
  • Linked Issue Type

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

QuerySupported Operators
linkedIssueType
= , != , is , is not , not in , in

Example:

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

1linkedIssueType = "Sub-task"
  • Links Issue Type

Find issues that link according to linked issue status type.

QuerySupported Operators
linksIssueType
= , != , is , is not , not in , in

Example:

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

1linksIssueType = "Sub-task"
  • Linked Issue Priority

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

QuerySupported Operators
linkedIssuePriority
= , != , is , is not , not in , in

Example:

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

1linkedIssuePriority = Medium
  • Links Issue Priority

Find issues that link according to linked issue status priority.

QuerySupported Operators
linksIssuePriority
= , != , is , is not , not in , in

Example:

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

1linksIssuePriority = Medium
  • Links Issues Count

Find issues that link according to the number of links.

QuerySupported Operators
linksIssuesCount
= , != , < , > , <= , >=

Example:

Find issues with outward link:

1linksIssuesCount > 0
  • Linked Issues Count

Find issues that are linked according to number of links.

QuerySupported Operators
linkedByIssuesCount
= , != , < , > , <= , >=

Example:

Find issues with inward link:

1linkedByIssuesCount > 0

Subtasks

  • Subtasks Count

Find issues according to the number of subtasks. 

QuerySupported Operators
subTaskCounts
= , != , < , > , <= , >=

Example:

Find issues with subtasks:

1subTaskCounts > 0
  • Subtask Summary

Find issues according to a summary of a subtask. 

QuerySupported Operators
subTaskSummary
~ , !~ , is , is not

Example:

Find issues with a summary of the subtask is "test is required":

1subTasksSummary ~ "test is required"
  • Subtask Key

Find issues according to a key of a subtask. 

QuerySupported Operators
subTaskKey
= , != , is , is not , in , not in

Example:

Find issues with a key of the subtask is "TEST-1":

1subTaskKey = "TEST-1"
  • Subtask Priority

Find issues according to a priority of a subtask. 

QuerySupported Operators
subTaskPriority
= , != , is , is not , in , not in

Example:

Find issues with a priority of subtask is "Medium":

1subTaskPriority = "Medium"
  • Subtask Issue Type

Find issues according to an issue type of a subtask. 

QuerySupported Operators
subTaskIssueType
= , != , is , is not , in , not in

Example:

Find issues with an issue type of subtask is "Task":

1subTaskIssueType = "Task"
  • Subtask Status

Find issues according to a status of a subtask. 

QuerySupported Operators
subTaskStatus
= , != , is , is not , in , not in

Example:

Find issues with an issue status of a subtask is "Open":

1subTaskStatus = "Open"
  • Subtask Status Category 

Find issues according to a status category of a subtask. 

QuerySupported Operators
subTaskStatusCategory
= , != , is , is not , in , not in

Example:

Find issues with an issue status category of a subtask is "To Do":

1subTaskStatusCategory = "To Do"

Versions

  • Affected Version Count

To search for issues according to the affected version number.

QuerySupported Operators
affectedVersionCount
= , != , < , > , <= , >=

Example:

Find issues with affected version:

1affectedVersionCount > 0
  • Affected Version Released

To search for issues according to affected version released or not. 

QuerySupported Operators
affectedVersionReleased
=

Example:

1affectedVersionRelased = "True"
2affectedVersionRelased = "False"
  • Affected Version Released Date

To search for issues according to the affected version release date

QuerySupported Operators
affectedVersionReleasedDate

endOfDay(), endOfMonth(), endOfWeek(), endOfYear(), lastLogin(), 

now(), startOfDay(), startOfMonth(), startOfWeek(), startOfYear()

Example:


1
  • Affected Version Archived

To search for issues according to the affected version archived or not. 

QuerySupported Operators
affectedVersionArchived
=

Example:

1affectedVersionArchived = "True"
2affectedVersionArchived = "False"
  • Fix Version Count

To search for issues according to fix version number.

QuerySupported Operators
fixVersionCount
= , != , < , > , <= , >=

Example:

Find issues with fix version:

1fixVersionCount > 0
  • Fix Version Released

To search for issues according to fix version released or not. 

QuerySupported Operators
fixVersionReleased
=

Example:

1fixVersionRelased = "True"
2fixVersionRelased = "False"
  • Fix Version Released Date

To search for issues according to the fix version release date

QuerySupported Operators
fixVersionReleasedDate

endOfDay(), endOfMonth(), endOfWeek(), endOfYear(), lastLogin(), 

now(), startOfDay(), startOfMonth(), startOfWeek(), startOfYear()

Example:


1
  • Fix Version Archived

To search for issues according to fix version archived or not. 

QuerySupported Operators
fixVersionArchived
=

Example:

1fixVersionArchived = "True"
2fixVersionArchived = "False"