Retrieve last from database?

I am trying to compare some metrics from today vs the metrics of yesterday. So far as I understand New object are placed at the bottom of your database table? There is a simple way to retrieve the first from database, but is there also an easy way to retrieve the last from database? Or maybe a way to make new entries on the top of the database table?
1 answers


you could use the createdDate attribute (or create your own such attribute) to keep track of the table inserts. Retrieving first or last is simple – retrieve from database, select ‘first’ and apply sort by createdDate Ascending or Descending