Hello list my doubt is how I can create a list SQLForm.grid from this consultation that I make to the database
dt1=datetime.datetime(*time.strptime(request.vars.desde,'%Y-%m-%d %H: %M:%S')[0:6]) dt2=datetime.datetime(*time.strptime(request.vars.hasta, '%Y-%m-%d %H: %M:%S')[0:6]) query =(a.dialstatus=='ANSWER')& (a.inicio>=dt1)&(a.inicio<=dt2) left = (b.on(a.id_accountcode==b.id),rp.on(a.id_rutaproveedor==rp.id),r.on(rp.id_rutas==r.id)) rows=db(query).select(b.ani,a.destino,a.answeredtime,a.inicio,a.valor, left=left) SQLFORM.grid(rows)
