Please desconsider the sorter_icons parameter, its a custom implementation of mine. I can post this patch too if you think its relevant.
Thanks! On Monday, January 14, 2013 5:38:53 PM UTC-2, Felipe Meirelles wrote: > > Hi, > > When you try to make more than one left join on a SQLFORM.grid as: > > grid = SQLFORMCustom.grid(db.device, > fields=[db.device.serial, db.device.device_type, > db.device.vehicle, db.vehicle.plate, db.chip.imei, ], > field_id=db.device.id, > left=[db.chip.on(db.chip.id==db.device.chip), db.vehicle.on( > db.vehicle.id==db.device.vehicle)], > paginate=max_results, > showbuttontext=False, > formstyle='divs', > paginate_icons=paginate_icons, > sorter_icons=sorter_icons > ) > > it can't display the join fields as it dosen't find the fields on the > query in sqlhtml.py line 1083. > > Can you apply this patch on line 1083? > > if left is not None: > if isinstance(left, (list)): > for l in left: > tablenames += db._adapter.tables(l) > else: > tablenames += db._adapter.tables(left) > --
