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:
- CRM
- e-Commerce
- Kế toán
- Tồn kho
- PoS
- Project
- MRP
Câu hỏi này đã bị gắn cờ
2
Trả lời
1277
Lượt xem
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
Bạn có hứng thú với cuộc thảo luận không? Đừng chỉ đọc, hãy tham gia nhé!
Tạo tài khoản ngay hôm nay để tận hưởng các tính năng độc đáo và tham gia cộng đồng tuyệt vời của chúng tôi!
Đăng ký| Bài viết liên quan | Trả lời | Lượt xem | Hoạt động | |
|---|---|---|---|---|
|
3
thg 11 24
|
1201 | ||
|
"THIS YEAR" FILTER STUDIO
Đã xử lý
|
|
1
thg 4 22
|
3421 | |
|
1
thg 4 22
|
1918 | ||
|
1
thg 8 21
|
11314 | ||
|
1
thg 4 20
|
3796 |
