*table* db.define_table('address', Field('address'), format = lambda r: f'{r.address}' )
db.define_table('customer', Field('name'), Field('address', 'list:reference address'), format = lambda r: f'{r.name}' ) *objective* search customer address by type the words that contains address e.g. 'boulevard' *already tried* db(db.customer.address.belongs(db.address.address.contains('boulevard') ) ).select() no error occured but the result is not expected (blank) any idea to achieve it ? thanks -- 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 web2py+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/web2py/f22e111d-1598-4689-a12c-951cc797eb37n%40googlegroups.com.