Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
I'm trying to search strings that end with certain characters. How can I do this with the search method?
Searching ('name', '=', '%abc') doesn't work. If I use like ('name', 'like', '%abc') it does not search the strings that end with 'abc' but all strings that contain 'abc'.
The search has to be fast so I cannot use another line where I iterate trough the results to get only those that end with the value.
before posting I didn't found anything but after posting I found in 5 min https://www.odoo.com/forum/help-1/question/solved-what-does-ilike-in-domain-operator-used-for-58261
Also note that this is the case insensitive version of the search. Use =like rather than =ilike if case matters.
yeah I know, but I'm searching for phone numbers so it does not matter
Create an account today to enjoy exclusive features and engage with our awesome community!
Registrar-se| Related Posts | Respostes | Vistes | Activitat | |
|---|---|---|---|---|
|
how to use and in search?
Solved
|
|
2
de des. 22
|
17204 | |
|
1
d’abr. 20
|
142 | ||
|
|
1
de juny 19
|
5017 | ||
|
|
2
de juny 18
|
89 | ||
|
|
0
de març 18
|
6570 |
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
