Query a join tables SQLFORM.smartgrid

[Gilad Hoshmand]

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.

[Gilad Hoshmand]

The answer(not in the book):

        smart_grid = SQLFORM.smartgrid(db.child,
                                       left = (db.parent.on(db.child.parent_id & (db.parent.field_bla == some_value)),
                                       ...other settings...)