uhm... "newest message for each user" was kinda clear ... no ? On Monday, October 5, 2015 at 9:32:29 PM UTC+2, DenesL wrote: > > You probably want the sorting and no grouping: > > messages = db(db.messages.toid == auth.user.id).select(db.messages.ALL, > orderby=db.messages.fromid|~db.messages.timesent) > > Denes > > On Monday, October 5, 2015 at 2:35:16 PM UTC-4, Daniel wrote: >> >> Hi all, >> >> I am trying to order messages so that the newest message from each user >> is displayed. However when grouped by user, the oldest message is displayed >> despite being ordered by timesent. Its like the groupby argument overrides >> the orderby. >> >> messages = db(db.messages.toid == auth.user.id).select(db.messages.ALL, >> orderby=~db.messages.timesent, groupby=db.messages.fromid) >> >> >> Thanks for your help >> >
-- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
