[web2py] Re: SQLFORM.grid, groupby and sum/count

2017-01-19 Thread Anthony
You could also do something like what is suggested here: https://github.com/web2py/web2py/issues/1553#issuecomment-270406959. Though as noted, the aggregate column will not be sortable, and you'd need to add some code to remove the link in the UI that allows it to be selected for sorting. Anth

[web2py] Re: SQLFORM.grid, groupby and sum/count

2017-01-19 Thread Anthony
On Thursday, January 19, 2017 at 8:02:23 AM UTC-5, James Booth wrote: > > Hm, so there's no real way to do this at the minute? > > The problem is, if I do it via executesql or virtual fields, I can't > export it as CSV which is my primary goal. > You could (a) create a view in the database to r

[web2py] Re: SQLFORM.grid, groupby and sum/count

2017-01-19 Thread James Booth
Hm, so there's no real way to do this at the minute? The problem is, if I do it via executesql or virtual fields, I can't export it as CSV which is my primary goal. On Monday, January 16, 2017 at 1:01:01 PM UTC, Jurgis Pralgauskis wrote: > > Hi, > > I think it echoes my isssues > https://github

[web2py] Re: SQLFORM.grid, groupby and sum/count

2017-01-16 Thread Jurgis Pralgauskis
Hi, I think it echoes my isssues https://github.com/web2py/web2py/issues/1559 https://github.com/web2py/web2py/issues/1553 -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (