In a controller I have this: fields=[db.table.id.count()] columns = [str(db.table.id.count())] headers = {str(db.table.id.count()):'Total recs',}
rows=db(qry).select(*fields) t=SQLTABLE(rows, columns=columns, headers=headers) How can I use .represent on the calculated field db.table.id.count() in order to show a number if count()>0, and '' otherwise? If not with .represent, is there any other way to achieve the same? I have tried: db.table.id.count().represent = lambda v: ... but now I am lost. --