In the book I read:
*Showing virtual fields in SQLFORM.grid and smartgrid*
In recent versions of web2py, virtual fields are shown in grids like normal
fields: either shown alongside all other fields by default, or by including
them in the fields argument. However, virtual fields are not sortable.
However, if i use the welcome app and define:
db.define_table('entity',
Field('entity_name', 'string'),
Field('slogan', 'string'),
Field.Virtual('slogan2', lambda row: row.entity.slogan+', it is really
the best.')
)
and then create a grid:
def index():
my_grid = SQLFORM.grid(db.entity)
return locals()
Reading the book I expect this to work. However I get the error 'Query Not
Supported: no such column: entity.slogan2' in the smartgrid.
Massimo, is this related to to the same bug I asked about yesterday? (I
have not yet updated my web2py to trunk, but did not find anything about
this issue in the tracker.)
One solution might be to change the Virtual Fiels to computed fields.
A big hug to all web2py contributors!
--
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 web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
