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 generate a lot of non-unique rows and > hence it would be important to just filter out the unique ones. With > select, there is support for the distinct keyword but this is not the case > with SQLFORM.grid. > > Using the groupby keyword is one approach but this can get somewhat > tedious having to specify the fields to group by in advance and hence, I > would like to understand if the omission of support for distinct in > SQLFORM.grid is by design? > > Many thanks > Calvin >
-- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
