Odoo Help

1

How to do compare ignoring case in search filter?

By
vivek
on 5/22/13, 6:52 AM 1,785 views

Hi,

How to do compare ignoring case in search filter? For instance in the below code

ids = self.pool.get('product.product').search(cr, uid, [('name', '=', 'Service'))], context=context)

i am comparing the name of the product with string 'Service'. i want to compare ignoring its case something similar to below

ids = self.pool.get('product.product').search(cr, uid, [('name'.upper(), '=', 'Service'.upper()))], context=context)

I can use 'service'.upper but not 'name'.upper. So how do i compare ignoring its case. Thanks for your time.

2
Sudhir Arya (SA)
On 5/22/13, 6:58 AM

You can use ilike operator instead of = in search domain. It ignores case.

Try this:

ids = self.pool.get('product.product').search(cr, uid, [('name', 'ilike', 'Service'))], context=context)

Hope this is what you are looking for.

oh! Thanks sudhir, i actually forgot that option!!

vivek
on 5/22/13, 6:59 AM

Most welcome.

Sudhir Arya (SA)
on 5/22/13, 7:05 AM

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.

Register

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)

Stats

Asked: 5/22/13, 6:52 AM
Seen: 1785 times
Last updated: 3/16/15, 8:10 AM