[web2py] Nested References in Smart Grid
Hi I have been using this framework for the last few days and I am in awe a fantastic framework. I have come from a strong .net and php framework back ground and wanted to learn python this has already taught me so much!! I have a question that hopefully can be answered easily and maybe I am overlooking something. I have the smart grid working well however i want to display a reference of a reference eg Vehicle > Model > Make Please bare in mind i am using a legacy db Model # db.define_table('tblmake', Field('MakeID','id'), Field('Make','string'), format="%(Make)s", migrate=False) # db.define_table('tblmodels', Field('Model','string'), Field('ModelID','id'), Field('MakeID','reference tblmake'), format="%(Model)s", migrate=False) # db.define_table('tblvehicles', Field('VehicleID','id'), Field('Registration','string'), Field('Driver','string'), Field('Model','reference tblmodels'), migrate=False) Controller vehiclefields = [db.tblvehicles.Registration, db.tblvehicles.Driver, db.tblvehicles.Model] vehiclelinks = [lambda row: A('View Post',_href=URL("search","test",args=[row.VehicleID]))] vehicles = SQLFORM.smartgrid(db.tblvehicles, orderby="VehicleID Desc", fields=vehiclefields, formname="vehiclegrid", details=False, editable=False, deletable=False,links=vehiclelinks, linked_tables=False) I would like to display the db.tblmake.Make field How can I do this? Can I do this? I have tried adding various combinations but with no luck Any help would be greatly appreciated -- 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.
[web2py] Re: Nested References in Smart Grid
Thank you that worked however as pointed out its quite slow. I ended up creating a view joining the tblmodels and tblmake and reference that Thank you -- 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.
[web2py] Set Field Type Dynamically
Hi I am loving the smart grid but the amount of references is killing itvery slow. Removing the references and using multiple lefts is a workable option however I do want the goodness of references when editing a particular row in the edit field Can I change the type dynmaically? eg it is a integer I would set it to reference I have tried db.tablename.field.type = "reference othertable" this changes it when I view print db.tablename.field >>"reference othertable" but when applied to the gridnothing happens -- 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.
[web2py] Re: Set Field Type Dynamically
Awesome thanks!!! I know have a light weight but full featured grid! -- 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.