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.
Hey Community mates! Claire here from the Software Product Marketing team. We all know software development changes rapidly, and it's often tough to keep up. But from our research, we've found the h...
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