Alert Composer: Working alert with the group by functionality

Summary

Alert Composer: "Group by" doesn't work

Content

Dear all

I try to create an alert for managers to inform them when the projected end date = sysdate +30 days. That works fine if I don't use the group by functionality. But it sends no message if I use this template:

Projected end dates of these worker assignments occur during the next 30 days:

${AlertUtils.write("<table border=\"1\"><tr><th>Name</th> <th>Person Number</th> <th>Projected Termination Date</th></tr>")}${AlertUtils.loop('emps,assignments','<tr><td>${DisplayName} </td><td>${PersonNumber}</td><td>${AlertUtils.formatDate(ProjectedTerminationDate,\'dd-MMM-yyyy\')} </td></tr>')}${AlertUtils.write("</table>")}