I had the issue with SQLFORM.grid and left join
I have Contact table (Kontakti) and Bank reference number (finnish bank
anomality) Viitteet.
It seems that it is not enough to introduce extra table in left join
only... so I made query (ugly) where I show both tables *
(db.Kontakti.id>0)&(db.Viitteet.id>0)*
records=SQLFORM.grid((db.Kontakti.id>0)&(db.Viitteet.id>0),fields=fields,headers=shheaders,left=db.Viitteet.on(db.Kontakti.id==db.Viitteet.id_Kontakti))
I don't think this is the right way. I think grid should also check all
tables introduced in left -parameter too.
