I do not think it is possible to define such a JQL query out of the box or with script runner even.
Instead i would suggest an alternative to your need and i.e. you to update your notification scheme and include relevant users for the event Issue commented. This way you always get emails when someone comments on an issue.
You could get this information from the database from the following query:
SELECT concat(po.pkey, '-', ji.issuenum) issuekey, ist.pname Status, ji.created Issue_Create, ja.actiontype Action_Type, ja.updated Action_Update, ja.actionbody FROM jiraaction ja LEFT JOIN jiraissue ji ON ja.issueid=ji.id LEFT JOIN project po ON ji.project=po.id LEFT JOIN issuestatus ist ON ji.issuestatus=ist.id WHERE ja.actiontype='comment' ORDER BY issuekey ASC, Issue_Create ASC, Action_Type ASC, Action_Update ASC
I hope it helps.
Badges are a great way to show off community activity, whether you’re a newbie or a Champion.Learn more
Hi Atlassian Community! My name is Shana, and I’m on the Jira Software team. One of the many reasons this Community exists is to connect you to others on similar product journeys or with comparabl...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs