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.
>

Reply via email to