I am trying to show a grouped count in a powertable. How do I
reference the count's storage object?
<snippet>
def event_list():
class Virtual(object):
@virtualsettings(label='Count')
def email_count(self):
return ??????????? # What do I need to reference?
report_id = int(request.args[0])
count1 = db.events.email.count()
datasource = db(
(db.events.report_id==report_id) &
(db.events.event_type=='event1')
).select(
db.events.id,
count1,
db.events.email,
db.events.name,
db.users.first_name,
db.users.last_name,
left=db.users.on(
db.events.email==db.users.email),
groupby=db.events.email)
table = plugins.powerTable
table.datasource=datasource
table.headers = 'labels'
table.virtualfields = Virtual()
table.keycolumn = 'events.id'
table.columns = ['virtual.email_count','events.email']
...
</snippet>
This is my first web2py project and second python project, so if it is
a lack of basic understanding, pointing me towards helpful resources
would also be appreciated.
Thank you
