Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Reverted from v. 2

Description:

Excerpt

Searches for issues with / without comments, additionally you can further refine your query by using a number expression.

Note:

A 'number expression' is made of an optional operator representing by its mathematical symbol and a (prositive/negative) number.

Expand
titleLet's see the allowed symbols...


OperatorSymbol
Equals to=
Not equals to!=
Greater than>
Greater than or equals to>=
Less than<
Less than or equals to<=




Syntax

hasComments()
hasComments(numberExpression)

Available sincev2.0.0-RELEASE
Supported fieldsIssue
Supported operatorsIN , NOT IN
Unsupported operators

= , != , ~ , !~ , > , >= , < , <=

IS , IS NOT , WAS , WAS IN , WAS NOT , WAS NOT IN , CHANGED

Examples:

• Find issues without comments:

Code Block
languagesql
themeConfluence
issue NOT IN hasComments()


• Find Stories that have three or more comments

Code Block
languagesql
themeConfluence
type = Story AND issue IN hasComments(">= 3")

• Find issues within the EMEA project without with exactly two comments

Code Block
languagesql
themeConfluence
project = EMEA AND issue NOT IN hasComments("2")

Real World Use Cases:

· JRASERVER-40308 - JQL query to filter by comment quantity (by Vincent Chin)
·
Is it possible to search for issues with no comments? (by Svante Gustafsson at ATLASSIAN Community)
·
Filter issue that has comment (by Pangianto Pang at ATLASSIAN Community)
· How can I filter issues by comment count?(by Stanislav Golodov Reis at ATLASSIAN Community)

JQL Function Reference

Page Tree
rootJQL Function Reference
startDepth2