Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Info

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

On this page:

Table of Contents
minLevel1
maxLevel7
excludeTry it free

Comments JQL keywords

...

commentsCount

Search for Find issues that have a particular number of comments. 

...

=

!=

~

!~

>

>=

<

<=

IS

IS NOT

IN

NOT IN

WAS

WAS IN

WAS NOT

WAS NOT IN

CHANGED

(tick)

(tick)

(error)

(error)

(tick)

(tick)

(tick)

(tick)

(error)

(error)

(error)

(error)

(error)

(error)

(error)

(error)

(error)

Example:

Find issues with comments.

Code Block
commentsCount > 0 

...

commentedByUser

CommentedByUser

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

...

=

!=

~

!~

>

>=

<

<=

IS

IS NOT

IN

NOT IN

WAS

WAS IN

WAS NOT

WAS NOT IN

CHANGED

(tick)

(tick)

(error)

(error)

(error)

(error)

(error)

(error)

(error)

(error)

(tick)

(tick)

(error)

(error)

(error)

(error)

(error)

Example:

Find issues that were commented on by Jane Potter. 

Code Block
commentedByUser = "Jane Potter"

 

...

commentLastCreatedBy

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

...

=

!=

~

!~

>

>=

<

<=

IS

IS NOT

IN

NOT IN

WAS

WAS IN

WAS NOT

WAS NOT IN

CHANGED

(tick)

(tick)

(error)

(error)

(error)

(error)

(error)

(error)

(error)

(error)

(tick)

(tick)

(error)

(error)

(error)

(error)

(error)

Example:

Find issues that were last commented on by admin. 

Code Block
commentLastCreatedBy= "admin"

 

...

commentLastUpdatedBy

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

...

=

!=

~

!~

>

>=

<

<=

IS

IS NOT

IN

NOT IN

WAS

WAS IN

WAS NOT

WAS NOT IN

CHANGED

(tick)

(tick)

(error)

(error)

(error)

(error)

(error)

(error)

(error)

(error)

(tick)

(tick)

(error)

(error)

(error)

(error)

(error)

Example:

Find issues with a comment last updated by admin. 

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

...

=

!=

~

!~

>

>=

<

<=

IS

IS NOT

IN

NOT IN

WAS

WAS IN

WAS NOT

WAS NOT IN

CHANGED

(tick)

(tick)

(error)

(error)

(tick)

(tick)

(tick)

(error)

(tick)

(tick)

(tick)

(tick)

(error)

(error)

(error)

(error)

(error) 

Examples:

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

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

...

commentUpdatedOnDate

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:

...

=

!=

~

!~

>

>=

<

<=

IS

IS NOT

IN

NOT IN

WAS

WAS IN

WAS NOT

WAS NOT IN

CHANGED

(tick)

(tick)

(error)

(error)

(tick)

(tick)

(tick)

(error)

(tick)

(tick)

(tick)

(tick)

(error)

(error)

(error)

(error)

(error) 

Examples:

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

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

...

=

!=

~

!~

>

>=

<

<=

IS

IS NOT

IN

NOT IN

WAS

WAS IN

WAS NOT

WAS NOT IN

CHANGED

(tick)

(tick)

(error)

(error)

(tick)

(tick)

(tick)

(error)

(tick)

(tick)

(tick)

(tick)

(error)

(error)

(error)

(error)

(error) 

Example:

Find issues that were commented on more than 2 days ago:.

Code Block
commentLastCreatedOnDate < -2d

...

commentLastUpdatedOnDate

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:

...

=

!=

~

!~

>

>=

<

<=

IS

IS NOT

IN

NOT IN

WAS

WAS IN

WAS NOT

WAS NOT IN

CHANGED

(tick)

(tick)

(error)

(error)

(tick)

(tick)

(tick)

(error)

(tick)

(tick)

(tick)

(tick)

(error)

(error)

(error)

(error)

(error) 

Example:

Find issues that were commented on more than 2 days ago:.

Code Block
commentLastUpdatedOnDate < -2d

...