Filter for the existence of comments on issues

[michaelfanderson]

I would like to write a filter that will return any issues that have comments. The only option in JQL I've seen related to comments is the Tilde (~) which I believe indicates "contains."  However, I want to find all issues with comments, not just those, and I don't know how I can do that with ~ because I can't know what the comments might contain. I tried " ", but Jira didn't like the empty string operator.

Any ideas would be appreciated.

Thank you.

Michael Anderson

[Pavel Konstantinov]

I came up with the following workaround  - add the following as a part of your query:

(comment ~ "anything*" OR comment !~ "anything*")

[Keren Rachev]

That was really helpful, thanks!

[Ioana Sundius]

clever!

[Abdiel Martínez]

Me funcionó, gracias

[Kat Markava]

Thanks! Helped!

[Martijn van de Locht]

First of all, thanks for this! I know this is an old topic, but I couldn't find the answer to this anywhere else: Is there a way to get the inverse result (issues without comments) in a similar fashion (without app or plugin)? Thanks again.

Edit: For those who come after me, I did manage to find the solution here: How to setup a filter that shows tickets with no responses.

[Calebe Garcia]

Obrigado, foi muito útil!

------

Tanks, It was very useful!

[Justin Golden]

Worked for me, thanks!

Maybe one day they'll actually support this without workaround, seems like an extremly common search

[Daniel Turczanski - JQL Search Extensions]

Hi Michael,

JQL Search Extensions adds a bunch of keywords for comments. After installing the plugin you can then use the following JQL:

commentsCount > 0 

Full documentation is here.

[Ramanathan, Ananth (External)]

But (comment ~ "anything*" OR comment !~ "anything*") results the user stories or subtasks with the comments.    How to alter it if i want to list the stories or subtasks with no cimments entered.  Please let me know,

[Joanna Plaskonka]

Hello,

There are already some answers which might be interesting for you:

https://community.atlassian.com/t5/Jira-questions/How-to-find-issues-which-does-not-have-a-comment/qaq-p/402636

https://community.atlassian.com/t5/Jira-questions/How-to-search-for-JIRAs-which-have-no-comment/qaq-p/292185

Look for example at Jira Toolkit Plugin and create custom field 'Number of comments'. 

[Alexey Matveev]

Hello,

you could write such a filter if you have Adaptivist Scriptrunner installed. This plugin has "hasComments" JQL function. You can read more here about this function:

https://scriptrunner.adaptavist.com/latest/jira/jql-functions.html#_hascomments