http://web2py.com/books/default/chapter/29/07/forms-and-validators#SQLFORM-smartgrid is designed to take as input not a query but only one table and to browse said table and selected referencing tables.
http://web2py.com/books/default/chapter/29/07/forms-and-validators#SQLFORM-grid The first argument of SQLFORM.grid can be a table or a query. On Tuesday, April 5, 2016 at 4:12:20 PM UTC-4, Boken . . wrote: > > Hi, > > I need to use smartgrid with a query to avoid users view records of other > users, but I don't how does. > This code: > form = SQLFORM.smartgrid(db(db.t_table.user == > auth.user).select(),onupdate=auth.archive) > > raise an error: > <type 'exceptions.AttributeError'> 'Rows' object has no attribute '_db' > > Thanks you very much. > Regards. > -- 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.