smart_query only usage seems to be processing SQLFORM.grid search queries??
It's used in pyDAL too, but can't figure out yet what it used for. smart_query() is not documented, I can write a little docstring for it, at least specifying it main purpose?? Richard On Wed, Apr 29, 2015 at 10:53 AM, Richard Vézina < [email protected]> wrote: > I was looking for know if it was not implemented because it was really > more complex or for some other reasons... > > I found myself needing to pass queries trough url and I need to pass > complexe "where clauses" which implies need for () sourrounding some > queries groups... > > For now I have this : > > from gluon.dal import smart_query > > keywords = \ > 'table1.f1 = True and ' \ > 'table1.f2 != {0}'.format( > db(db.ref_table.f1 =='Annulé - Void' > ).select(db.ref_table.id).first().id) > > fields = [db.table1.f1, > db.table1.f2] > > active_set = db(smart_query(fields, keywords)) > > So I can DRYly write db_set and then pass the queries through URL like so : > > URL(c='mycontroller', f='myfunc', vars=dict(keywords=keywords)) > > But, for more complexe "where clause" I am stuck... > > I guess passing a web2py query directly into URL vars raise security issue > that why I follow the path of SQLFORM.grid search tool for passing queries > in vars... > > QUESTION > > Is smart_query() able to parse parenthesis queries some how? > > Richard > > > On Wed, Apr 29, 2015 at 10:37 AM, Niphlod <[email protected]> wrote: > >> is it something that requires an answer ? grid search is meant to be >> flexible AND user-friendly: you can come up with your own syntax and code >> your own search widget if you need something else.... >> >> >> On Wednesday, April 29, 2015 at 3:49:37 PM UTC+2, Richard wrote: >>> >>> Hello, >>> >>> It seems that SQLFORM.grid search tool not accept parenthesis? >>> >>> Ex.: >>> >>> Not possible >>> >>> (table.input_comment = "" or table.input_comment != None) and ... >>> >>> Richard >>> >> -- >> 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. >> > > -- 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.
