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
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- सीआरएम
- e-Commerce
- लेखांकन
- इन्वेंटरी
- PoS
- Project
- MRP
This question has been flagged
2
Replies
1237
Views
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,
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.
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
Enjoying the discussion? Don't just read, join in!
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign up| Related Posts | Replies | Views | Activity | |
|---|---|---|---|---|
|
3
नव॰ 24
|
1188 | ||
|
"THIS YEAR" FILTER STUDIO
Solved
|
|
1
अप्रैल 22
|
3406 | |
|
1
अप्रैल 22
|
1883 | ||
|
1
अग॰ 21
|
11284 | ||
|
1
अप्रैल 20
|
3759 |
