Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Image RemovedImage Added

Info

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

Table of Contents
minLevel1
maxLevel7
excludeTry it free

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

(tick)

(tick)

(error)

(error)

(tick)

(tick)

(tick)

(tick)

(error)

(error)

(error)

(error)

(error)

(error)

(error)

(error)

(error)

EXAMPLES

Find issues with comments

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

(tick)

(tick)

(error)

(error)

(error)

(error)

(error)

(error)

(error)

(error)

(tick)

(tick)

(error)

(error)

(error)

(error)

(error)

EXAMPLES

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. 

SUPPORTED OPERATORS 

=

!=

~

!~

>

>=

<

<=

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)

EXAMPLES

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. 

SUPPORTED OPERATORS 

=

!=

~

!~

>

>=

<

<=

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)

EXAMPLES

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()

Also see:

 

SUPPORTED OPERATORS 

=

!=

~

!~

>

>=

<

<=

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 were commented on 13th or 14th of March, 2016

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

 

CommentedUpdatedOnDate

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

(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
commentUpdatedDatecommentUpdatedOnDate >= "2016/03/13" AND commentUpdatedDatecommentUpdatedOnDate < "2016/03/15" 
commentUpdatedDatecommentUpdatedOnDate < 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()

Also see:

 

SUPPORTED OPERATORS 

=

!=

~

!~

>

>=

<

<=

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 that were commented on more than 2 days ago:

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

Also see:

 

SUPPORTED OPERATORS 

=

!=

~

!~

>

>=

<

<=

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 that were commented on more than 2 days ago:

Code Block
commentLastUpdatedOnDate < -2d