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
Cree una cuenta para poder utilizar funciones exclusivas e interactuar con la comunidad.
Registrarse| Publicaciones relacionadas | Respuestas | Vistas | Actividad | |
|---|---|---|---|---|
|
how to use and in search?
Resuelto
|
|
2
dic 22
|
17204 | |
|
1
abr 20
|
142 | ||
|
|
1
jun 19
|
5019 | ||
|
|
2
jun 18
|
89 | ||
|
|
0
mar 18
|
6570 |
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
