In appadmin, you can specify a query to define which records to select, but you cannot specify columns or expressions to calculate from the returned records. You'll have to create a custom action to do that, or do it in a web2py shell. I use an IPython Notebook web2py shell with some special methods for rendering Rows -- looks like this:
Note, in the shell, you will need to call db.commit() to commit any changes you make to the database. Anthony On Thursday, April 16, 2015 at 10:26:16 AM UTC-4, Carla Raquel wrote: > > I'm having some troubles making a sum query in appadmin.I want to sum all > the values of field 'Custo' and then group by type of service, much like > you would do in a dal query.I tried db.Chamada.Custo.sum() just to start, > but that doesn't work.It gives me a 'misuse of aggregate: SUM()' error. Any > help would be appreciated. > > > > > > > > > > > > > > > > > > > Cheers, > Carla > -- 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/d/optout.
