Re: [web2py] SQLFORM.grid to view and using groupby clause

2013-11-13 Thread Niphlod
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/

Re: [web2py] SQLFORM.grid to view and using groupby clause

2013-11-13 Thread Meir
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

Re: [web2py] SQLFORM.grid to view and using groupby clause

2013-11-13 Thread Meir
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

Re: [web2py] SQLFORM.grid to view and using groupby clause

2013-11-13 Thread Johann Spies
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.

[web2py] SQLFORM.grid to view and using groupby clause

2013-11-12 Thread Meir
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 sta