I guess I wasn't clear enough, my example queries are not python code, they are text that would be entered in the search box in the default search widget generated by SQLFORM.grid.
I know how to do it in python code, but I am looking for an answer regarding if this is possible from the search box (and equivalently directly by URL) Thanks Vincent On Thu, Jun 12, 2014 at 5:38 PM, Derek <[email protected]> wrote: > You have your queries all wrong. Can you share your code? You should use > the python bitwise operators not the words. Also, why are you using > assignment when you should be testing for equality? > > > On Thursday, June 12, 2014 2:35:25 PM UTC-7, Vincent wrote: >> >> How would one go about doing the equivalent of >> A and (B or C) >> in the grid or smartgrid search? >> Tried reading the source but got lost. >> >> Given >> db.person.firstname >> db.person.lastname >> >> this fails as an invalid query: >> person.firstname = "John" and (person.lastname = "Smith" or >> person.lastname = "Williams") >> >> Boolean precedence also does not seem to be implemented (and before or) >> as this doesn't return the expected results: >> person.firstname = "John" and person.lastname = "Smith" or >> person.firstname = "John" and person.lastname = "Williams" >> >> Any suggestions? >> > -- > 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 a topic in the > Google Groups "web2py-users" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/web2py/2stnvKwdHaY/unsubscribe. > To unsubscribe from this group and all its topics, send an email to > [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- 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 [email protected]. For more options, visit https://groups.google.com/d/optout.
