Domain Condition with list of value with like condition .

Question

i m facing an issue ,in which i have list of name (list of values) i need to pattern match with (ilike) condition to match contains name with list of values.
this take 'IN' as argument in domain search:
[('payment_ref','in', tuple(label_data.mapped('name')))]
but i need to match with contains name(ilike) condition with label_data.mapped('name')
how can i do that.
list = ['abc','def']
matching should be 'xxabcyy', 'aadef' should match.

Cybrosys Techno Solutions Pvt.Ltd · Answer

Hi,
You can use the '|' operator in the domain to combine multiple ilike conditions. Here's an example of how you can modify your domain search:

domain=[]
for name in list_of_names:
domain.extend(['|', ('name', 'ilike', name)])
domain.pop(-2)

Hope it helps

相關帖文	回覆	瀏覽次數
Something wrong when i use self.env[{model_name}].search search odoo16features	1 11月 23	1616
CMS pages searchable through Searchbar search odoo16features	1 5月 23	2407
Can the Product Sales Description text be included in the Global Search? or how can I search Products using the Sales Descriptions? 已解決 product search odoo16features	2 3月 24	1649
How to add condition with domain domain condition odoo16features	1 11月 23	2024
How can i add multiple conditions with the domain atttribute 已解決 domain conditional odoo16features	4 11月 23	2777

此問題已被標幟

喜歡這則討論？不要只閱讀，加入發表意見吧！