nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to search for JIRAs which have no comment?

Ben Hoi

In "Advanced Query", "comment" does not support "is empty" and supports only ~ and !~.

I had the idea of excluding each vowel. I tried "comment !~ 'A'" but that did not exclude comments with 'A'. Maybe the search string needs to be longer?

Any idea? Is this a bug?

Accepted answers

All comments

Geoff

Getting the same results here.

Trying to search for:

comment ~ '\ '

returns:

The field 'comment' does not support searching for an empty string.

You could try raising a feature request on https://jira.atlassian.com

Theinvisibleman

Hi,

As far as I know, this is not possible in JIRA currently. However, I agree that this can be a rather useful search feature. Hence, I have created a sub task for it here : https://jira.atlassian.com/browse/JRA-31057.

No worries, as the parent task of this sub-task is this : https://jira.atlassian.com/browse/JRA-23288 (List of suggested JQL improvements)

For now, I would recommend that you :

* Vote, so that it will receive more attention

* Watch it, so that you will receive any and all updates

* Comment, and give your opinion on the matter

Please note that the implementation of new features and improvement requests falls under Implementation of New Features Policy : https://confluence.atlassian.com/display/DEV/Implementation+of+New+Features+Policy

Renjith Pillai

For achieving the reverse, I was able to do this.

Install JIRA Tool Kit plugin and add a custom field of the type 'Number of Comments'

https://marketplace.atlassian.com/plugins/com.atlassian.jira.toolkit

Once done do a JQL search similar to below:

COMMCOUNT != "0"

This gives all issues with comments.

JamieA

There is a function in the script runner plugin that can do this:

issueFunction not in hasComments()

issueFunction in hasComments(-1)

(ie, less than one comment).

Neeraj Tiwari

Can we do a similar search for all issues that doesn't have description in a specific project? We recently transferred all our bugzilla tickets to JIRA and some of the tickets have no description in them. We are suspecting the description was not copied. In order to verify this we want to know how many issues actually doesn't have the description in them? Can anyone of you know how we can accomplish this in JIRA using Script Runner. We have the latest JIRA (6.0.1) and Script Runner installed currently.

Thom Franklin_r7eb4f

All comments have "AM" and "PM" in them.

This will show you all records with comments:

comment !~ '\"m" '

This will show you all records without comments.

comment ~ '\"m" '

Mark de Bont_d2r62f

Both queries return issues with comments, not sure what goes wrong....

James Bromwell

This is really neat, script runner also has a "commented" function which supports its own subset of query language for specific comment properties. Not only can I find issues with no comments, I can also identify issues where I left a comment recently:

AND issueFunction in commented('after -4w by currentUser()')