Having the following def by_country(): count = db.procesados.idpublicacion.count() rows = db().select(db.procesados.pais, count, groupby=db.procesados.pais) return rows.json()
It generates the JSON: [{"pais": "", "COUNT(procesados.idpublicacion)": 236}, {"pais": "AE", "COUNT(procesados.idpublicacion)": 3}] Is there a way to assign an Alias to the COUNT field so I won't have that long name "COUNT(procesados.idpublicacion)" in the JSON output Thanks