smart_grid = SQLFORM.smartgrid(db.child,
left =
(db.parent.on(db.child.parent_id* & (db.parent.field_bla == some_value)*),
...other settings...)
On Sunday, August 25, 2019 at 3:44:47 PM UTC+3, Gilad Hoshmand wrote:
>
> I'm trying to make a smartgrid from 2 tables and apply a query to it.
> I've tried all the following:
>
> smart_grid = SQLFORM.smartgrid(db.child,
> left = (db.parent.on(db.child.
> parent_id),
> # keywords = (db.parent.field_bla
> == some_value),
> # constraints = {'parent':
> (db.parent.field_bla == some_value)},
> ...other settings...)
>
> I've tried joining the other way around, using 'constraints' in many ways,
> keywords, query instead of table. None of these worked.
>
>
--
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].
To view this discussion on the web visit
https://groups.google.com/d/msgid/web2py/bd3ee1f6-7310-40ba-9bbd-3b510c3e18e3%40googlegroups.com.
