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.
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
We're bringing product updates and pro tips on teamwork to ten cities around the world.Save your spot