How to search for JIRAs which have no comment?

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?

5 answers

This widget could not be displayed.

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

This widget could not be displayed.

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

This widget could not be displayed.
Joe Wai Tye Atlassian Team Dec 20, 2012

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

This widget could not be displayed.

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.

This widget could not be displayed.

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.

Suggest an answer

Log in or Sign up to answer
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Posted Wednesday in New to Jira

Are you planning to trial, or are currently trialling Jira Software? - We want to talk to you!

Hello! I'm Rayen, a product manager at Atlassian. My team and I are working hard to improve the trial experience for Jira Software Cloud. We are interested in   talking to 20 people planning t...

292 views 5 0
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you