Ah got it, thanks =) Missed that bit.
On Nov 13, 8:40 pm, villas <villa...@gmail.com> wrote: > Hi Ruiwen, > > See also 'orderby' in the book. Do something like this: > > db().select(db.person.ALL, orderby=~db.yourtable.created_date, > limitby=(0, 15)) > > Don't overlook the tilde (~), this is important because it makes > reverse order i.e. latest dates first > > -D > > On Nov 13, 10:10 am, Ruiwen Chua <rwc...@gmail.com> wrote: > > > > > > > > > Hi, > > > I have a table full of records and would like to retrieve only the 15 > > most recent records, sorted by their creation date. > > > I've tried using the limitby= argument to select() in the DAL, but the > > online book only shows one example that uses limitby to select 2 > > records starting from 0, ie. limitby=(0,2). > > > However, if I'd like to select the 15 most recent records, the > > database offset most likely isn't going to be 0. What should I pass to > > limitby in this case? > > > //Ruiwen