Hello,
How can I define the column name of a field which is a projection
(like sum()) on select?
Examplo:
        query = ((db.despesa.id_servico == db.servico.id))

        total_gasto = (db.despesa.valor_servico *
db.despesa.quantidade).sum()
        linhas = db(query).select(db.servico.descricao, total_gasto, groupby
= db.servico.id)

The return "linhas" have a column with name
'SUM((despesa.valor_servico * despesa.quantidade))'
When iteration by linhas array, how can I get the values of this
column?

Thanks

Reply via email to