Yes On 12/14/2011 10:25 PM, Nik Go wrote:
columns support has been dropped, right?On Thursday, December 15, 2011, Cliff wrote: On 1.99.2, grid will display a row for each row returned by the query, but won't show any data from the secondary table. Unless I'm missing a step. Actually I would be happy if that were the case, as I have one situation where it would be very helpful to show data from the foreign table. Insert an owner in this table: db.define_table('owners', Field('name', length=32), format = '%(name)s', ) Insert two dogs in this table. Point owner_id to the owner inserted above. db.define_table('dogs', Field('owner_id', 'reference owners'), Field('name', length=32), format = '%(name)s', ) This grid will show two rows, reflecting the left join, but it won't show either dog's name or id. def index(): columns = ('owners.name <http://owners.name>', 'dogs.id <http://dogs.id>', 'dogs.name <http://dogs.name>') query = db.owners.id <http://db.owners.id> > 0 form = SQLFORM.grid( query, left = db.dogs.on( db.dogs.owner_id == db.owners.id <http://db.owners.id> ), columns=columns ) return dict(form=form On Dec 14, 11:14 am, Massimo Di Pierro <[email protected] <javascript:;>> wrote: > Can you provide an example of grid usage that ignores left joins? > > On Dec 14, 8:00 am, Johann Spies <[email protected] <javascript:;>> wrote: > > > > > > > > > On 14 December 2011 14:07, Cliff <[email protected] <javascript:;>> wrote: > > > > > It is not possible with that query. It is the essence of the query. > > > > I don't think grid processes left joins. > > > > You might try smartgrid. It knows about left joins and gives you a > > > link to the foreign table, but it doesn't display any information from > > > specific rows in that table. > > > Thanks for your attention. I have worked around this problem. I was just > > curious why the grid would count the correct number of records but not > > display them. > > > Regards > > Johann > > -- > > Because experiencing your loyal love is better than life itself, > > my lips will praise you. (Psalm 63:3) No virus found in this message. Checked by AVG - www.avg.com <http://www.avg.com> Version: 2012.0.1890 / Virus Database: 2108/4681 - Release Date: 12/14/11
-- Jim Steil VP of Information Technology Quality Liquid Feeds, Inc. 608.935.2345 office 608.341.9896 cell
