Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
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 Aliases

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 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 which were commented by Jane Potter. 

Code Block
commentedByUser = "Jane Potter"

 

CommentLastCreatedBy

Search for issues that were last commented 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 which were last commented 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 which 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

Search for issues which 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
commentUpdatedDate >= "2016/03/13" AND commentUpdatedDate < "2016/03/15" 
commentUpdatedDate < now()

 

CommentLastCreatedOnDate

Search for issues which 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 which were commented 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 which were commented more than 2 days ago:

Code Block
commentLastUpdatedOnDate < -2d