Re: [web2py] SQLFORM.grid to view and using groupby clause
you can't have a column in the grid with a groupby that is not the groupby itself or an aggregate of another column, just like you can't in SQL. -- 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.
Re: [web2py] SQLFORM.grid to view and using groupby clause
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 >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 . >> 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.
Re: [web2py] SQLFORM.grid to view and using groupby clause
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, > > >> 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 . >> 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.
Re: [web2py] SQLFORM.grid to view and using groupby clause
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 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+unsubscr...@googlegroups.com. > 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.
[web2py] SQLFORM.grid to view and using groupby clause
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+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
