Aggregate - Filter Record by Latest Date

Aggregate - Filter Record by Latest Date

  

Hi All,


I need to filter the data by latest date in the aggregate which has same title.

For example in the below table i need see only the highlighted record, since those has the latest update date and time.

Solution

HI Vinod,

I don't know if it is that what are you asking for. But if you select on the aggregate the Max of your "Last Updated" attribute and you group by "UMR" you will have automatically a new attribute (MAX of Last Update) with records for each UMR value.



Solution

Helena Lameiro wrote: Thanks Helena. 

HI Vinod,

I don't know if it is that what are you asking for. But if you select on the aggregate the Max of your "Last Updated" attribute and you group by "UMR" you will have automatically a new attribute (MAX of Last Update) with records for each UMR value.





Hi Vinod,

It's great that it could help you!

I really wish you to improve in OutSystems :-) 

If you have some spare time, try to consolidate and deepen your knowledge in SQL. It really makes the difference!