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; } } }

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

Accepted answers

All 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

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

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.

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 Casas

Me funcionó, gracias

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,

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira-core

jql

filter