JQL to identify issue which fields were modified but no comment was added

[Deleted user]

Hello,

I am trying to find a JQL to identify issues that were modified during the week (worklog added, attachement added, status changed) but no comment was added in the last three days. I came up with :

project = "XXXXX" and component = XXXXX AND status not in (Resolved,Closed) and updatedDate >= startOfWeek() AND worklogDate >= startOfWeek() AND status CHANGED AFTER startOfWeek() AND commentedOn >= -3d

It is perfect except for the fact that we don't have the Scriptrunner plugin so ''commentedOn'' is out of the question. :(

Any ideas for a workaround?

Thank you so much!

[Bill Sheboy · Accepted solution]

Hi @[deleted] 

How often do you need to run this query, as that may help you decide possible solution approaches?

One time: Run your existing query without the "commented on" check, and...

• Manually look at issues histories and comments, or
• Export the issues to a spreadsheet and use formulas to identify the last comment date/time

Often:

• Investigate purchasing a marketplace addon, or
• Using automation for Jira rules to log the last date/time a comment was made in a custom field.

Kind regard,
Bill

[Deleted user]

Hi @Bill Sheboy

Thank you so much for your response. I appreciate you taking the time to do it.