Hi, in web2py 2.9.5 and older I was using database views to simplify my work doing something like that:
db.define_table('mytable',Field('myfield)) having a view on my db with all mytable fields plus some others. I define the view in web2py: db.define_table('myview',Field('myfield), Field('otherfield')) So I was using the grid in this way: SQLFORM.grid(db.myview, field_id=db.mytable.id) and worked like a charm showing the view in the grid and editing mytable in add/edit/delete Now doesn't work anymore cause this line of code: orderby = fix_orderby(orderby) in sqlhtml.py line 2561 (2.10.4) but a simple: if not orderby: orderby = fix_orderby(orderby) fix the problem. I don't know if this way to proceed is/was supported or not but could save a lot of work. Can we restore the older behaviour? What do you think? Thank you -- Massimiliano -- 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.