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
- Bogføring
- Lager
- PoS
- Project
- MRP
Dette spørgsmål er blevet anmeldt
2
Besvarelser
1249
Visninger
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!
Tilmeld dig| Related Posts | Besvarelser | Visninger | Aktivitet | |
|---|---|---|---|---|
|
3
nov. 24
|
1188 | ||
|
1
apr. 22
|
3410 | ||
|
1
apr. 22
|
1886 | ||
|
1
aug. 21
|
11290 | ||
|
1
apr. 20
|
3767 |
