Yes it has. The sample code runs on 1.99.2.
Updated for 1.99.4 it shows the same behavior. Grid displays no
information from the dogs table.
On Dec 15, 12:12 am, Jim Steil <j...@qlf.com> wrote:
> 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 <massimo.dipie...@gmail.com
> > <javascript:;>>
> > wrote:
> > > Can you provide an example of grid usage that ignores left joins?
>
> > > On Dec 14, 8:00 am, Johann Spies <johann.sp...@gmail.com
> > <javascript:;>> wrote:
>
> > > > On 14 December 2011 14:07, Cliff <cjk...@gmail.com
> > <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
