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 web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
