JQL to find issues I'm mentioned in but haven't commented since the last mention

[Trevor Buttrey]

I'm trying to find a way to make a JQL search that will list all the issues I'm mentioned in, that I haven't commented after the mention. Thus, once I've commented on an issue I'm mentioned in, it goes away unless I'm mentioned again.

It seems like I need to be able to get the date of a specific comment in order to compare it to the date of another comment, but I haven't figured out how to do that.  I've been looking at Script Runner functions and the commented("By Username after") type queries but they aren't quite powerfull enough.

Currently I'm using this: 

text ~ currentUser() AND issue not in watchedissues() AND (assignee != currentUser() OR assignee = EMPTY) AND status != Resolved ORDER BY updated DESC

However if I stop watching the issue it goes back into this filter

Thanks in advance for any assistance.

[Deleted user]

You may want to look into this plugin though it is only applicable to Service Instances: Comment Toolbox

Hope it helps.