Reg: Getting the latest or last saved data from the table

[Former Member]

Hi,

I'm having a table, which is getting updated whenever something is saved.

Now i want to get the latest or last saved details to be displayed or the details of the row with greatest Id.( i.e, the Id. will be greatest for the last saved)

please help me out with code to do this...

Thanks & Regards,

Suresh

[former_member214651]

Hi Suresh,

This could be done either through the webdynpro or the back end function module itself.

If another field of type date/time is present in the table, u can save the current date and time along with the data in the table, and sort it in descending order of time. so that whenever u refresh the page the latest record is always in the first row,

if u want to do it through webdynpro, u can also sort the table based on the date so that u get the latest record that was saved.

Another solution is that u can maintain a serial number sort of thing the table which helps u identify the latest record

Hope this helps u.

Regards,

Poojith M V