aren't you missing the db. before table?
like
def something():
grilla = SQLFORM.smartgrid(db.table_1)
and then for the orderby statement should be:
def something():
grilla = SQLFORM.smartgrid(db.table_1, orderby=db.table_1.field)
that should work.
Hello
Suppose we have the following:
#Model:
table_1 = db.define_table('table1',
Field('name'),
)
table_2 = db.define_table('table2',
Field('field1'),
Field('field2', table_1),
)
#Controller:
def something():
grilla = SQLFORM.smartgrid(table_1)
this shows me the grid with records from table1 and a link to another
grid with table2 records. This is correct.
But if I do the following:
def something():
grilla = SQLFORM.smartgrid(table_1, orderby= table_1)
The first grid shows good and well ordered, but when trying to
display records from table2 through the link, can't get the records
because it is sort of a field belonging to table1
*Query Not Supported: no such column: table1.name*
*
*
Jose
--