Finding the most recent record in a one to many relationship and store in a derived field

Legacy Contributor

For example if I want to store the most recently created WorkAssignment in a one to many relationship and store in a derived field on Employee business class. How would I do that?

something like

return record having max ActiveWorkAssignRel.WorkAssignment_create_date

Dr. Awesome

Based on the Set / Sort Order used you can use the first/last operators with the relation.

"return first ActiveWorkAssignRel..." if the Sort Order is create stamp descending would return the "most recently created" record.