Why not use the 'group by' in the creation of the view and then you can just view the view using the grid with no need to group by again in the grid?
Regards Johann On 13 November 2013 03:06, Meir <[email protected]> wrote: > > Hello, > > I have the following problem: I have created a view in the legacy database. > In this view created a field ID of type integer and unique. > > I used SQLFORM.grid using fields = [...] to specify the fields that wanted > and used the groupby = ... to perform clustering. > But it returns an error stating that the database must specify the ID in > the group by clause .... > Do not understand the reason for the error. If I put the ID in the groupby > clause SQLFORM.grid, there does not generate the error, but my grid is not > grouped because the ID is unique .... :/ > > Anyone have any ideas? > > -- > Resources: > - http://web2py.com > - http://web2py.com/book (Documentation) > - http://github.com/web2py/web2py (Source code) > - https://code.google.com/p/web2py/issues/list (Report Issues) > --- > 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. > -- Because experiencing your loyal love is better than life itself, my lips will praise you. (Psalm 63:3) -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- 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.
