Displaying Most Recent Date Time Entry from DB

Displaying Most Recent Date Time Entry from DB

  

Hello,

I am trying to return the most recent 'Timestamp' (Date Time data type) from an entity and having some troubles. The UserComment table has the Timestamp attribute and a foreign key to another table Customer.


On the customer detail screen staff can leave a comment which automatically applies the currdatetime() value on their comment. On the customer list screen I want to display the most recent comment's timestamp for that customer on the table records for customers.


I think I need help fetching and filtering the data.


Any advice is helpful. Thank you.

Sort TimeStamp descending Z-A, make max records fetching from aggregation 1.

Brilliant! Thank you, Kovan. I was using a different aggregate to and using the 'Max' formula, but it was messing with the rest of the table. I'll give this a shot. Thank you.