hi
i have table
db.define_table('items', Field('name'), Field('created_by'),
Field('modified_by'))
fields `created_by` and `modified_by` has defined relation to
db.auth_user.user_id (not auth_user.id)
how to programatically create virtual fields created_by.full_name and
modified_by.full_name?
lefts = []
auth_user_fields = ('created_by', 'modified_by')
for field in auth_user_fields:
table = db.auth_user.with_alias(field)
table.full_name = self.db.Field.Virtual('full_name', lambda
row, field=field: '%s %s' % (row[field].first_name, row[field].last_name))
lefts.append(table.on(table.user_id==self.model[field]))
rows = db(db.items).select(left=lefts)
but `rows` in last line contains only fields/columns from `db.items` ,
aliased `created_by` and `modified_by` `auth_user` table is missing
am i doing something wrong?
--
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.
