Not sure if you can do it with just one query. How about getting the count first and using it in the grid:
sm = db.invocados.modulo_servico modulo_counts = db().select(sm, sm.count(), groupby=sm) Denes. On Thursday, October 1, 2015 at 9:41:59 PM UTC-4, Bruno Oliveira wrote: > > > I'm trying to create a SQLFORM.grid in web2py that group 2 fields and > count them up, but I couldn't figure it out how to do it. > > > *Model* > > db.define_table('invocados', > Field('modulo_servico', 'string', label='Módulo (Serviço)', > default=IS_LENGTH(2)), > Field('servico', 'string', default=IS_LENGTH(8)), > ) > > > *Controller* > > fields=(db.invocados.modulo_servico, > db.invocados.servico)Invocados=SQLFORM.grid(db.invocados.modulo_servico != > db.invocados.modulo_consumidor, details=False, fields=fields, > groupby=(db.invocados.modulo_servico | db.invocados.servico) , paginate=15) > > > I'm trying to count all records grouped by modulo_servico and servico. > I've tried: > > fields=(db.invocados.modulo_servico, db.invocados.servico, > db.invocados.count()) > > but it doesn't work. > > > Can somebody help? > -- 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/d/optout.