Versions Compared

Key

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

...

Image Removed

Info

The

...

examples on this page describe how to

...

build a JQL search using JQL Search Extensions.

On this page:

Table of Contents
minLevel1
maxLevel7
excludeTry it free

Comments JQL

...

keywords

...

commentsCount

...

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

...

Example

Find issues with comments.

Code Block
commentsCount > 0 

...

commentedByUser

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)

...

Example

Find issues

...

that were commented on by Jane Potter. 

Code Block
commentedByUser = "Jane Potter"

...

commentLastCreatedBy

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)

...

Example

Find issues

...

that were last commented on by admin. 

Code Block
commentLastCreatedBy= "admin"

...

commentLastUpdatedBy

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)

...

Example

Find issues with a comment last updated by admin. 

Code Block
commentLastUpdatedBy= "admin"

...

commentedOnDate

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

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 the 13th or 14th of March, 2016.

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

(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

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

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) 

...

Example

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

...

See also

 Supported operators

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) 

...

Example

Find issues

...

that were commented on more than 2 days ago

...

.

Code Block
commentLastUpdatedOnDate < -2d

...