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

Reply via email to