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
Get Started with Redwood for Oracle Cloud HCM   Begin Now

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

edited Jul 7, 2021 10:59PM in HCM Integrations 4 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!