let say i have code
*models/db.py*
db.define_table('employee', 
Field('is_auth', 'boolean'),
Field('auth_user', 'reference auth_user'), 
Field('full_name'), 
Field('role'), 
format = '%(full_name)s')

auth_user_employee = db(db.employee.auth_user == 
auth.user_id).select().first()

db.define_table('client', 
Field('name'), 
Field('pic_it', 'list:reference employee'), 
format = '%(name)s')

# work for text type
db.client.pic_it.requires = IS_IN_DB(db(db.employee.role.contains('IT') ), 
db.employee.id, db.employee._format, 
multiple = True)
db.define_table('checklist', 
Field('checklist_no'), 
Field('client', 'reference client'), 
format = '%(checklist_no)s')

*# not work for list:reference type*
*db.checklist.client.requires = 
IS_IN_DB(db(db.client.pic_it.contains(auth_user_employee.id) ), *
* db.client.id, db.client._format)*

why is_in_db() contains query not work for list:reference type?
any idea to solve this?

thanks and best regards,
stifan

-- 
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.

Reply via email to