If you are grouping then you can't access a specific ID. You'd just be getting aggregates back.
On Thursday, October 10, 2013 10:13:56 AM UTC-7, Luis Furtado wrote: > > If I call SQLFORM.grid with "groupby" I get a table with no row buttons > ("view" in this case). > Those buttons show up if I leave "groupby" out. But then I get duplicate > records. > Notice that I'm joining three tables; > > g=SQLFORM.grid( ((db.empresa.id == db.emp_prod.emp ) & > (db.emp_prod.prod == db.nc.id) & > (db.nc.nc.like( ncsel + '%')) ), > fields = [ db.empresa.nome ], > details =True, create = False, editable = > False, deletable =False, searchable =False, csv =False, > groupby = db.empresa.nome ) > > What should I do? > Thanks > Luis > -- 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/groups/opt_out.