Looks good. Can you please send me a patch applied to the trunk version? On Friday, 18 January 2013 05:47:20 UTC-6, Felipe Meirelles wrote: > > Did anyone saw it? > > On Monday, January 14, 2013 5:41:36 PM UTC-2, Felipe Meirelles wrote: >> >> 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) >>> >>
--