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