The instructions on this page describe how to execute a JQL search using JQL Search Extensions.
Comments JQL keywords
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Example:
Find issues with comments
commentsCount > 0
CommentedByUser
Search for issues that were commented on by a particular user.
Supported operators
= | != | ~ | !~ | > | >= | < | <= | IS | IS NOT | IN | NOT IN | WAS | WAS IN | WAS NOT | WAS NOT IN | CHANGED |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Example:
Find issues that were commented on by Jane Potter.
commentedByUser = "Jane Potter"
CommentLastCreatedBy
Search for issues that were last commented on by a particular user.
Supported operators
= | != | ~ | !~ | > | >= | < | <= | IS | IS NOT | IN | NOT IN | WAS | WAS IN | WAS NOT | WAS NOT IN | CHANGED |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Example:
Find issues that were last commented on by admin.
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Example:
Find issues with a comment last updated by admin.
commentLastUpdatedBy= "admin"
CommentedOnDate
Search for issues that were commented on a particular date. This keyword works with date-related JQL functions:
endOfDay()
endOfMonth()
endOfWeek()
endOfYear()
lastLogin()
now()
startOfDay()
startOfMonth()
startOfWeek()
startOfYear()
See also:
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.
commentedOnDate >= "2016/03/13" AND commentedOnDate < "2016/03/15" commentedOnDate < now()
CommentUpdatedOnDate
Search for issues in which a 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.
commentUpdatedOnDate >= "2016/03/13" AND commentUpdatedOnDate < "2016/03/15" commentUpdatedOnDate < now()
CommentLastCreatedOnDate
Search for issues that were last commented on a particular date. This keyword works with date-related JQL functions:
endOfDay()
endOfMonth()
endOfWeek()
endOfYear()
lastLogin()
now()
startOfDay()
startOfMonth()
startOfWeek()
startOfYear()
See also:
Supported operators
= | != | ~ | !~ | > | >= | < | <= | IS | IS NOT | IN | NOT IN | WAS | WAS IN | WAS NOT | WAS NOT IN | CHANGED |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Example:
Find issues that were commented on more than 2 days ago:
commentLastCreatedOnDate < -2d
CommentLastUpdatedOnDate
Search for issues with comments updated on a particular date. This keyword works with date-related JQL functions:
endOfDay()
endOfMonth()
endOfWeek()
endOfYear()
lastLogin()
now()
startOfDay()
startOfMonth()
startOfWeek()
startOfYear()
See also:
Supported operators
= | != | ~ | !~ | > | >= | < | <= | IS | IS NOT | IN | NOT IN | WAS | WAS IN | WAS NOT | WAS NOT IN | CHANGED |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Example:
Find issues that were commented on more than 2 days ago:
commentLastUpdatedOnDate < -2d