We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
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

Alerts Composer: Can data from an AlertUtils.loop be Sorted/Ordered in a Table?

Received Response
21
Views
2
Comments
edited Jul 7, 2021 10:59PM in HCM Integrations 2 comments

Summary

Can "AlertUtils.loop" rows of data in a Table be sorted/ordered by one of the result fields?

Content

Goal: Send supervisor a list overdue training assigned to his or her direct reports in a table.
Table Columns: Person Name, Person Number, Learning Item Number, Learning Item Title, Due Date, Status

The data is written to a table with the "AlertUtils.loop" routine.

Problem: The employees' rows of data are interspersed in the table and I have not found a way sort the rows with an "Order By".
See Attached: "Table of Data.png"

In example, "Sam Smith" data rows are interspersed among "John Doe" data rows.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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