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

Reply via email to