Hi,

the grid support left joins from multiple tables?

I try this code:

 fields=
[db.examen_factura.id_factura, db.factura.fecha, db.examen.descripcion]
 left = (db.factura.on(db.factura.id==db.examen_factura.id_factura),
db.examen.on(db.examen.id==db.examen_factura.id_examen))
 orderby = ['factura.fecha',]
 query = ((db.examen_factura.id_paciente == registro) &
(db.examen_factura.procesado==True))
 grid = SQLFORM.grid(query = query, fields= fields, left = left,
user_signature=False, deletable=True, editable=False, details =
False,create=True, csv=False)

But only show the field id_factura, i I tried to solve it in various ways,
but I can not figure it out.

If try only one left, show that field,  but when i like one or more fields
in left, does not work.

anyone know who might be going?

thanks in advance.

PD: web2py 2.0.9

-- 



Reply via email to