in the book online i searched sqltable
Info about "sqltable" No Information Attributes This page is dynamically generated from the source code docstring Where to go to master it? 2011/8/18 Jim Steil <[email protected]> > Is there a way to control which columns are displayed in the grid? > > Thanks! > > -Jim > > > On 8/18/2011 12:51 PM, Massimo Di Pierro wrote: > >> More examples >> >> SQLFORM.grid(db.mytable,query=db.mytable.somefield=='somevalue') >> SQLFORM.grid(db.mytable,deletable=False) # default True >> SQLFORM.grid(db.mytable,editable=False) # default True >> SQLFORM.grid(db.mytable,details=False) # default True >> SQLFORM.grid(db.mytable,create=False) # default True >> SQLFORM.grid(db.mytable,searchable=False) # default True >> SQLFORM.grid(db.mytable,sortable=False) # default True >> SQLFORM.grid(db.mytable,selectable=lambda ids: >> db(db.mytable.id.belongs(ids).delete()) >> >> and combinations thereof >> >> On Aug 18, 12:26 pm, Massimo Di Pierro<[email protected]> >> wrote: >> >>> You used to do >>> >>> def index(): >>> rows=db(db.mytable).select() >>> table = SQLTABLE(rows) >>> return dict(table=table) >>> def search():.... >>> def view(): ... >>> def edit(): ... >>> def delete(): ... >>> etc etc. >>> >>> Now you can just do >>> >>> def index(): >>> table = SQLFORM.grid(db.mytable) >>> return dict(table=table) >>> >>> The new syntax out of the box does: >>> - one click sorting >>> - view, edit, delete buttons (in place view/edit) no need for >>> additional code >>> - searching >>> - pagination >>> >>> and a few other things that I will explain later. >>> >>> Try with your tables and try break it. >>> >>> Works best with the base.css of welcome. >>> >>> Need to add some security using signed_url will do so soon. >>> >>> This was been included in trunk because there seems to be a lot of >>> code repetition about this. >>> This would not happened without great code examples from Bruno, Martin >>> and others. >>> >>> Massimo >>> >>
