Hello Johann, It's why I created this view with the concept of cube to BI. I carry a lot of information forlater summarize according to the parameters of the users, but this I do in web2py. I'm working with web2py like my small BI ... Then the assembly is accomplished in various ways as defined by the user.
Thanks for your time! Em quarta-feira, 13 de novembro de 2013 10h51min52s UTC-2, Johann Spies escreveu: > > 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 <mmaalbu...@hotmail.com <javascript:>>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 web2py+un...@googlegroups.com <javascript:>. >> 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 web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
