SQLFORM.grid search - boolean precedence? - nested queries?

[Vincent]

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?

[Derek]

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?

[Vincent Chevrier]

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

--
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 web2py+un...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.