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
لقد تم الإبلاغ عن هذا السؤال
2
الردود
1247
أدوات العرض
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
هل أعجبك النقاش؟ لا تكن مستمعاً فقط. شاركنا!
أنشئ حساباً اليوم لتستمتع بالخصائص الحصرية، وتفاعل مع مجتمعنا الرائع!
تسجيل| المنشورات ذات الصلة | الردود | أدوات العرض | النشاط | |
|---|---|---|---|---|
|
3
نوفمبر 24
|
1188 | ||
|
"THIS YEAR" FILTER STUDIO
تم الحل
|
|
1
أبريل 22
|
3410 | |
|
1
أبريل 22
|
1886 | ||
|
1
أغسطس 21
|
11288 | ||
|
1
أبريل 20
|
3766 |
