Should not be *{...., 'hvmt2.bytes_total.sum()'*:'USAGE in MB'}
but {....., str(db.*hvmt2.bytes_total.sum())*:'USAGE in MB'} On Tuesday, 18 September 2012 01:23:58 UTC-5, maverick wrote: > > 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 >> >> --