I think he is looking for the first record of each group, not the first record of the entire result. I think there is no such function in web2py yet.
I have performed a similar task for reporting using this: https://docs.python.org/2/library/itertools.html#itertools.groupby It will require more computation and memory as you will have do it in memory but is possible and simple. 2014-04-28 10:33 GMT-03:00 Jim S <j...@qlf.com>: > > http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#first-and-last > > Is this what you were looking for? > > -Jim > > On Monday, April 28, 2014 7:20:15 AM UTC-5, Manuele wrote: >> >> Hi! >> does exists or can be implemented an aggregation function that returns >> the first element of a group instead of the sum, max, min or avg result? >> >> Thank you... as usual :) >> >> Manuele >> > -- > 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. > -- Att. Carlos J. Costa Cientista da Computação Esp. Gestão em Telecom EL MELECH NEEMAN! אָמֵן -- 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.
