How to do compare ignoring case in search filter?

Question

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

Sudhir Arya (ERP Harbor Consulting Services) · Accepted Answer

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.

相關帖文	回覆	瀏覽次數
how can i create a filter that uses the "and" condition filter search	2 11月 23	3089
How to save a filter with today value from context 已解決 filter search	7 4月 21	20436
filter with related model field 已解決 filter search	1 10月 20	4829
change search filter 已解決 filter search	2 11月 16	4191
How to set a new search filter? filter search	1 3月 15	13649