Looks like a bug. Feel free to open a Github issue. Anthony
On Sunday, April 15, 2018 at 6:47:46 AM UTC-4, mweissen wrote: > > Yes, that is possible. > > def t(): > db.tt.f.readable = False > form = SQLFORM.grid(db.tt) > return dict(form=form) > > > > But now there is the next problem. I try to use the Export "CSV" button > and I get another eooror: > > Ticket ID > > 194.118.190.134.2018-04-15.12-45-01.b4d5db05-e1e0-40b8-9233-47f2a2b37cca > <type 'exceptions.KeyError'> '"tt"."ff"'Version > web2py™ Version 2.15.4-stable+timestamp.2017.09.02.04.02.22 > Python Python 2.7.12: /usr/local/bin/uwsgi (prefix: /usr/local)Traceback > > 1. > 2. > 3. > 4. > 5. > 6. > 7. > 8. > 9. > 10. > 11. > 12. > 13. > 14. > 15. > 16. > > Traceback (most recent call last): > File "/home/www-data/web2py/gluon/restricted.py", line 219, in restricted > exec(ccode, environment) > File "/home/www-data/web2py/applications/gridtest/controllers/default.py" > <https://sx.infosms.org/admin/default/edit/gridtest/controllers/default.py>, > line 100, in <module> > File "/home/www-data/web2py/gluon/globals.py", line 414, in <lambda> > self._caller = lambda f: f() > File "/home/www-data/web2py/applications/gridtest/controllers/default.py" > <https://sx.infosms.org/admin/default/edit/gridtest/controllers/default.py>, > line 14, in t > form = SQLFORM.grid(db.tt) > File "/home/www-data/web2py/gluon/sqlhtml.py", line 2601, in grid > raise HTTP(200, oExp.export(), **response.headers) > File "/home/www-data/web2py/gluon/sqlhtml.py", line 3648, in export > self.rows.export_to_csv_file(s, represent=True) > File "/home/www-data/web2py/gluon/packages/dal/pydal/objects.py", line > 2582, in export_to_csv_file > field = fieldmap[col] > KeyError: '"tt"."ff"' > > > It seems that the export function does not find the virtual field. > Is there any workaround? > > Martin > > > 2018-04-15 8:43 GMT+02:00 Anthony >> >> But with the *field argument* I get an error: >>> >>> def t(): >>> form = SQLFORM.grid( >>> db.tt, >>> *fields=[**db.tt.ff]* >>> ) >>> return dict(form=form) >>> >>> >> What happens if you remove the "fields" argument and instead limit which >> fields display by setting their "readable" attributes to False? >> >> Anthony >> >> -- >> 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/d/optout. >> > > > > -- 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/d/optout.