Need to Check if Comment is Empty for Issue

[Sanjivani Wayal]

Hi,

Is there a way to check if the Comment on issue is empty as in JQL EMPTY doesnt work with Comment field , I have Scriptrunner plugin as well maybe if there is any way for it i need to prepare dashboard with this condition .

[John Funk · Accepted solution]

Hi Sanjivani,

If you are using ScriptRunner, try this:  issueFunction not in commented()

[Aron Gombas _Midori_]

If you want to do this without any app, you could do this:

1. Define a date-type custom field "Last commented on" and add this to your issues
2. Add an automation rule which is triggered by "Issue commented" and sets this field value to "now"

Now, in JQL you can just say:

"Last commented on" is empty

[Sanjivani Wayal]

Hi @Aron Gombas _Midori_  i used commentedon in JQL and its worked for me , Now i have another request to Check if there are comments that were provided within 5 days before the DATE.

Where DATE is verification date , iam not able to use CommentedOn because its data type is in days and DATE is in date format .

Can you please help how can i achieve it?

[Hannes Obweger - JXL for Jira]

Hi @Sanjen Bariki

here's another Marketplace app that you might like: JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a number of so-called smart columns that aren’t natively available, including the number of comments (along with many other comment-related columns).

This is how it looks in action:

As you can see above, you can easily sort and filter by the number of comments, and also use it across JXL's advanced features, such as support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting.

(Disclaimer: I work on JXL.)

Any questions just let me know,

Best,

Hannes

[Sanjivani Wayal]

Hi,

I found out the way in JQL we can use commentedon is empty it gives all the issues where no comments are updated.

[Charlotte Santos -Appfire-]

Hi @Sanjivani Wayal 

I’m Charlotte, a support engineer at Appfire and I’m here to help you.

Unfortunately, using JQL of Jira, you’ll not be able to do it dynamically.

In the app where my team works, JQL Search Extensions for Jira, you can use this query to display all issues with no comments on them:

commentsCount = 0

Please note that we have created a support ticket https://jqlsearchextensions.atlassian.net/servicedesk/customer/portal/2/SEARCH-1126 in our portal, and we request you to sign in to the portal and let us know the username so that we can mark you as the reporter, and then you will be able to access the ticket. 

Please find the below link to signup to the portal: https://jqlsearchextensions.atlassian.net/servicedesk/customer/portal/2 

Looking forward to hearing from you!

Thanks,
Charlotte

[Sanjen Bariki]

Hi @Sanjivani Wayal ,

Welcome to Atlassian Community!

As per my experience, There is no way in the Jira to check if the Comment on issue is empty.

It can be possible by the help of Script runner.

Thanks & regards,

Sanjen Bariki