the question is: to define columns=['accountcode.ani','llamados.destino','llamados.answeredtime','llamados.inicio','llamados.valor']
I only show the columns that correspond to the table is llamados I need to display and just as the column of the table accountcode 2011/11/2 Massimo Di Pierro <massimo.dipie...@gmail.com> > 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'] ) >