How do I give a label to calculated fields, like if I used:
rows = db().select(db.hvmt2.hub,db.*hvmt2.bytes_total.sum()*,
groupby=db.hvmt2.hub, cacheable=True)
I want to serialize rows as:
Result=SQLTABLE(rows,headers={'hvmt2.hub':'HUB',*'hvmt2.bytes_total.sum()'*:'USAGE
in MB'},truncate=60)
But the summed column (what I referred to above as 'calculated') gets
displayed as SUM(hvmt2.bytes_total) not 'USAGE in MB' as I desire.
Thanks,
mave
On Thursday, January 21, 2010 5:36:17 AM UTC-8, Johann Spies wrote:
>
> I would like the table produced by SQLTABLE to have different column
> labels (e.g. "Name" for "db.person.name"). How do I do it?
>
> Also: I would like the output of SQLTABLE to provide links to
> individual records simliar to what appadmin does. I could not fully
> understand the code appadmin uses to achieve this.
>
> Can linkto be used in this case? From what I understand from te book
> linkto is a SQLFORM method and is not related to SQLTABLE.
>
> Regards
> Johann
>
>
--
