The appadmin seems stuck in time. It needs some improvements and having available DAL queries would be great.
Regards António 2015-04-16 15:44 GMT+01:00 Anthony <[email protected]>: > 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. > -- 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.
