[web2py] Re: Powertable and DAL count

[Wes Hall]

Pat,

I have a hard time hanging with you west-coasters some time.

Thank you for your assistance.  I was able to reference the field directly 
into the columns with 'COUNT(events.email)', but wasn't finding it when I 
was in the Virtual class.  _extra was the key. 

def event_list(): 
>     class Virtual(object): 
>         @virtualsettings(label='Count') 
>         def email_count(self): 
>             return ??????????? # What do I need to reference? 


is now

def event_list(): 
    class Virtual(object): 
        @virtualsettings(label='Count') 
        def email_count(self): 
            return self._extra(count1)
 
, and life is peachy.

Both 
table.columns = ['COUNT(events.email)','events.email'] 
& 
table.columns = ['virtual.email_count','events.email'] 
now work as expected.

Thanks again
wh