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?

[JamieA]

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

issueFunction not in hasComments()

or

issueFunction in hasComments(-1)

(ie, less than one comment).

[Thom Franklin]

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]

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

[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.

[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.

[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

[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