Right now grid does not work with virtual fields. There is a pending proposal for enhancement to support them.
On Tuesday, 18 December 2012 01:03:05 UTC-6, software.ted wrote: > > Does SQLFORM.grid support adding and display of a virtual field...am > getting an exception...my code: > > db.file_subject_issue.file_name = Field.Virtual(lambda row: > get_file_name(row.file_subject_issue.file_id)) > fields = [db.file_subject_issue.file_id, > db.file_subject_issue.date_created, db.file_subject_issue.file_name] > query =.... > > form = SQLFORM.grid(query,fields=fields,...) > > I am getting the error > > <type 'exceptions.AttributeError'> 'FieldVirtual' object has no attribute > '_tablename' > > 1. > 2. > 3. > 4. > 5. > 6. > 7. > 8. > 9. > 10. > 11. > 12. > > Traceback (most recent call last): > File "/home/www-data/web2py/gluon/restricted.py", line 212, in restricted > > exec ccode in environment > File > "/home/www-data/web2py/applications/intranet/controllers/administration.py" > <https://192.168.0.251/admin/default/edit/intranet/controllers/administration.py>, > line 176, in <module> > > File "/home/www-data/web2py/gluon/globals.py", line 188, in <lambda> > > self._caller = lambda f: f() > > File > "/home/www-data/web2py/applications/intranet/controllers/administration.py" > <https://192.168.0.251/admin/default/edit/intranet/controllers/administration.py>, > line 71, in file_track > > selectable=False,csv=False , paginate=20, user_signature=False) > > File "/home/www-data/web2py/gluon/sqlhtml.py", line 1796, in grid > > if field._tablename in tablenames] > AttributeError: 'FieldVirtual' object has no attribute '_tablename' > > > > > -- > > ....................................................................................... > Teddy Lubasi Nyambe > Opensource Zambia > Lusaka, ZAMBIA > > Cell: +260 97 7760473 > website: http://www.opensource.org.zm > > ~/ > Human Knowledge belongs to the world! - AntiTrust > > Man is a tool-using animal. Without tools he is nothing, with tools he is > all - Thomas Carlyle 1795-1881 > > /~ > --
