In a table definition I have the following field:
db.define_table('app_settings',
...
Field('viewtypeID', type='integer', requires=IS_IN_SET(viewtype_list)),
...
migrate = False)
This is the viewtype_list:
viewtype_list = [(1, 'zero'), (2, 'thing'), (3, 'client'), ..., (8, 'hub')]
I have two types of users, distinguished by their e-mail starting with
'thing' or not.
What I want is to group the views by type and within a group by e-mail
starting with 'thing' or not
and then count the number of views.
viewtype 1 r views of which s thing users t none thing users
viewtype 2 x views of which y thing users z none thing users
etc.
This is the join:
join = db.auth_user.on(db.app_settings.vertexID==db.auth_user.vertexID)
Kind regards,
Annet
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
