Skip to Content
Menu
This question has been flagged
2 Replies
1239 Zobrazenia

Hi, 


Would it be possible on filters to add an operator beginning with

Example use case: Filter on companies in the same department. To do this, I need to filter on postal codes starting with “02”.


Merci pour votre aide

Avatar
Zrušiť
Autor Best Answer

Hello,

Thank you for your reply, but I don't quite understand where I can enter the query you're giving me, or what "ilike operator" means..

Can you enlighten me further?

Thanks & Regards, 

Avatar
Zrušiť

The "=ilike" operator in Odoo is used for case-insensitive search, and the "%" wildcard allows for flexible pattern matching.

for example:
<field name="name" filter_domain="[('complete_name', '=ilike', 'can%')]"/>

This filter will indeed retrieve all records where the complete_name field starts with "can" (case-insensitive). The "can%" pattern matches any string that begins with "can", which is perfect for finding all customer names that start with this prefix.

Best Answer

Hello Bourillon Thibault,

In search view, We can use =ilike operator along with % wildcard around the searched expression. 
For example. following search filter will search all the name of the customer which starts with "can" 

<field name="name" filter_domain="[('complete_name', '=ilike', 'can%')]"/>

Thanks & Regards,

CandidRoot Solutions Pvt. Ltd.

Mobile: (+91) 8849036209

Email: info@candidroot.com

Avatar
Zrušiť
Related Posts Replies Zobrazenia Aktivita
3
nov 24
1188
1
apr 22
3407
1
apr 22
1885
1
aug 21
11286
1
apr 20
3764