Skip to Content
Menu
This question has been flagged
1 Reply
1410 Views

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.

Avatar
Discard
Best 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

Avatar
Discard
Related Posts Replies Views Activity
1
Nov 23
1184
1
May 23
1868
2
Mar 24
1175
1
Nov 23
1471
4
Nov 23
2120