Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
Alert Composer: Working alert with the group by functionality — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Alert Composer: Working alert with the group by functionality

Received Response
18
Views
3
Comments
edited Jul 22, 2020 4:18PM in HCM Integrations 3 comments

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>")}

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!