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.rutaproveedor.on(db.llamados.id_rutaproveedor==db.rutaproveedor.id),db.rutas.on(db.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.valor,
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','llamados.inicio','llamados.valor']
)
