The medium term plan is replace the entire appadmin with a few lines of SQLFORM.smatgrid(...)
smartgrid allows to register a callback to perform operations on selected rows (update, delete) but needs a little more work. On Aug 29, 11:45 am, António Ramos <[email protected]> wrote: > I think database administration should also have a natural language tool to > update all/subset of record for example. > > 2011/8/29 Massimo Di Pierro <[email protected]> > > > > > > > > > If a field is named "starts" you can do > > > starts starts with "m" > > > supporting internationalization here would be possible, but a mess. I > > would not recommend it. I am not even sure full language in english is > > a good idea. > > > On Aug 29, 10:41 am, Bruno Rocha <[email protected]> wrote: > > > I did not look in the source yet. But. > > > > Is it possible to support i18n? > > > > name contains m > > > To > > > name contém m > > > > name is equal or greater than > > > To > > > name é igual ou maior que > > > > Is there some way to have a dictionary of terms? > > > > (what if a field is named 'starts'? ) > > > >http://zerp.ly/rochacbruno > > > Em 29/08/2011 12:23, "Massimo Di Pierro" <[email protected]> > > > escreveu: > > > > > A new feature in trunk allows natural language search in SQLFORM.grid > > > > and smartgrid > > > > > for example given: > > > > db.define_table('person',Field('name')) > > > > form = SQLFORM.smartgrid(db.person) > > > > > you can search for > > > > > name is max > > > > name is "Max" > > > > person.name is "Max" > > > > person.name = "Max" > > > > person.name == "Max" > > > > name contains max > > > > name contains m and name ends with x > > > > name starts with m and name is not equal mick > > > > name starts with m and not name is equal mick > > > > name starts with m and not name equals mick > > > > name is equal or greater than max and name ends with "x" > > > > etc. > > > > > The only rule is that field names cannot contain spaces.

