On Tuesday, April 25, 2017 at 10:39:53 AM UTC-4, Richard wrote: > > Forgot to mention... If you for some reason you can't refactor your > schema... you can unionize query in web2py like so : > > select_cat = db(db.cat.id>0).select() > > select_dog = db(db.dog.id>0).select() > > select_cat_and_dog = select_cat | select_dog > > Note: You can use & or | they are python binary operator, if I recall used > like that combine with web2py query they mimic union (no duplicate) and > union all (keep duplicate)... >
That won't help in this case. Above, you are running two separate SQL queries, creating two separate Rows objects, and then combining the Rows objects via Python. That approach cannot be used with SQLFORM.grid, which requires a single query as its input. Anthony -- 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.
