this should work:
nested_select =
db(db.address.address.contains('boulevard'))._select(db.address.id)
rows = db(db.customer.address.belongs(nested_select) ).select()
Notice the _select instead of select makes it a nested select.
Without _ it would give the same result with two explicit selects.
On Sunday, 10 October 2021 at 03:15:32 UTC-7 黄祥 wrote:
> *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/544e6188-a4d8-42eb-811c-6965cdea6ff6n%40googlegroups.com.
