Odoo Help

Welcome!

This community 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.

1

"starts with" operator

By
ODF
on 10/4/13, 11:38 AM 705 views

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

0

Daniel Reis

--Daniel Reis--
3436
| 6 7 9
Lisbon, Portugal
--Daniel Reis--

Author of the "Odoo Development Essentials" book.

Applications Manager at Securitas Portugal

Github: https://github.com/dreispt

Twitter; @reis_pt


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%')]

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

0 follower(s)

Stats

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