Does the lastCommentedDate in the Jira support desk actually work?

[Melissa]

I can't find any information on this field available in the jira support desk que sql. It populates some records but not all records with comments before a given date. Can someone point me in the right direction of what the lastCommentedDate means here?

[Hazwan Ariffin]

I believe that's a Scriptrunner field: https://scriptrunner-docs.connect.adaptavist.com/jiracloud/jql-aliases.html

lastCommentedDate

The lastCommentedDate keyword can be used to search for issues based on the date of most recent comment.

assignee = currentUser() AND lastCommentedDate < startOfMonth()
status = 'In Progress' AND lastCommentedDate = '2016-10-14'

This keyword can be used with the JQL relative date functions and also the numeric comparison operators.