[web2py] Re: distinct keyword for SQLFORM.grid

Please open a ticket and we can add this. On Wednesday, 10 April 2013 04:46:14 UTC-5, Calvin wrote: > > Hi > > I have been struggling with how one could get just distinct records to > show with SQLFORM.grid if the query passed to it involved more than one > table? Doing an inner join tends to ge

[web2py] Re: distinct keyword for SQLFORM.grid

Hi Massimo, I think this still hasn't been added yet. I too am doing several inner joins with grid and I'm getting some rows that I consider duplicates and would like to get rid of them. The most straightforward way to remove these duplicates is perhaps calling select() on the Set object with

[web2py] Re: distinct keyword for SQLFORM.grid

Ok I think I solved my problem by using grid's groupby argument, thanks to this post and this post.