Odoo Help


"starts with" operator

on 10/4/13, 11:38 AM 990 views

What is the precise syntax to replace the filter [['name', 'ilike', 'BA']] with STARTS WITH ?

Daniel Reis
On 10/4/13, 1:49 PM

Use the =ilike operator instead, which doesn't add the % wildcard around the searched expression. So the for your example you should use:

[('name', '=ilike', 'BA%')]

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

0 follower(s)


Asked: 10/4/13, 11:38 AM
Seen: 990 times
Last updated: 3/16/15, 8:10 AM