Re: [web2py] Re: join with SQLFORM.grid

2011-10-12 Thread Marcelo Martinez
Thank you 2011/10/12 Massimo Di Pierro > SQLFORM.grid does not take rows. It take the query itself. It needs > the query to optimize the select for orderby and pagination. You can > in fact do: > > query =(a.dialstatus=='ANSWER')& (a.inicio>=dt1)&(a.inicio<=dt2) > left = > (b.on(a.id_accountcode

[web2py] Re: join with SQLFORM.grid

2011-10-12 Thread Massimo Di Pierro
SQLFORM.grid does not take rows. It take the query itself. It needs the query to optimize the select for orderby and pagination. You can in fact do: 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_r u