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.
I’m a designer on the Jira team. For a long time, I’ve fielded questions from other designers about how they should be using Jira Software with their design team. I’ve also heard feedback from other ...
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