Advanced Searching/ JQL help - need tickets with a comment update in the past xx days

[Brian Borg]

Hi, I'm looking to pull a list of tickets that have had a comment entered or updated in the last xx days. Reason is, often times there are outstanding tasks that need to be done or questions answered that come out of these comments, and during our weekly status calls I like to highlight these and remind folks. 

Currently I just have a filter for 'tickets changed in the past xx days' which I review before our weekly call, but this includes all kinds of tickets with nothing of interest (label change, status change, etc). It would be great to narrow the search criteria down to just changes in that one field.

On the Advanced Searching Field Reference it's clear that I can search on specific text using ~ or !~ but when I try to use this on an empty string JIRA complains.

project = FSW AND resolution = Unresolved AND (comment !~ "" and updated >= -7d)

Error: The field 'comment' does not support searching for an empty string.

I'll keep playing around with this but any thoughts or suggestions are greatly appreciated. Thanks!

[Alexey Matveev · Accepted solution]

If you want to pull all tickets that have a comment entered or updated in the last xx days, you need to use an add-on. You can not do it out of the box. For example, you could use Scriptrunner. You can find more info here:

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

[Brian Borg]

Great, thanks for the suggestion, will check that out...