what is the question?
On Nov 2, 9:09 am, mmartinez <alexra...@gmail.com> wrote: > Hello list. > > My question is this, I have a join in my query to the database, you > need to show the columns belonging to tables and routes accountcode, > here is my code: > > left = > (db.accountcode.on(db.llamados.id_accountcode==db.accountcode.id),db.rutapr > oveedor.on(db.llamados.id_rutaproveedor==db.rutaproveedor.id),db.rutas.on(d > b.rutaproveedor.id_rutas==db.rutas.id)) > > query = (db.llamados.dialstatus=='ANSWER') & (db.llamados.inicio>=dt1) > & (db.llamados.inicio<=dt2) > > ## > rows=db(query).select(b.ani,a.destino,r.nombre,a.answeredtime,a.inicio,a.va > lor, > left=left) > > rws=SQLFORM.grid( > > query, > > left = left, > > deletable=False, > > editable=False, > > create=False, > > csv=False, > > details=False, > > showbuttontext=False, > > columns=['accountcode.ani','llamados.destino','llamados.answeredtime','llam > ados.inicio','llamados.valor'] )
