you can't really group by something and then select all the fields. That's not how grouping works. When you group by something, you MUST also aggregate something else. If you're looking to return the oldest message, what you'd need to ask the database is the minimum date in a group. If you're lucky enough, you can then ask for the message record that has the date equal to the minimum date for each group.
On Monday, October 5, 2015 at 8:35:16 PM UTC+2, 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.
