Problem with ilike operator in openerp 7

Question

Hi,

i know operator ilike already with regard to sql. It will perform this way when placing in where class

'PSS01' ilike 'pss01' -> will return true
'PSS01' ilike '%ss01' -> will return true
'PSS01' ilike 'ss01' -> will return false

But in openerp 7, it performs this way

'PSS01' ilike 'pss01' -> returns true
'PSS01' ilike 'ss01' -> returns true **(it should return false)**

My code is below

repeted_ids = prod_serial_obj.search(cr, uid, ['&',('name', 'ilike', line.prod_ser_no),('product_id',

vivek · Accepted Answer

More descriptive answer i got from another source..

OpenERP automatically wraps the right handed value of ilike operator inside percents. So when you write the domain

[('name', 'ilike', 'ss01')]

OpenERP convert it to

name ilike '%ss01%'

To avoid having these wildcard characters added, you have to use the =ilike operator.

[('name', '=ilike', 'ss01')]

will be converted to

name ilike 'ss01'

Serpent Consulting Services Pvt. Ltd. · Answer

Hello,

OpenERP automatically wraps the right handed value of ilike operator inside percents. So when you write the domain
[('name','ilike','ss01')]

OpenERP convert it to
[('name','ilike','%ss01%')]

To avoid having these wildcard characters added, you have to use the =ilike operator.
[('name', '=ilike', 'ss01')]

Hope this will help.

Thank you.

Publicaciones relacionadas	Respuestas	Vistas
How to use dynamic values in domain filter? Resuelto filter domain code	6 may 24	73885
How to do compare ignoring case in search filter? Resuelto filter code search	1 nov 22	15868
@%{{💃🔭🗽GUÍA~Teléfono~Perú}} ¿Cómo llamar Expedia en Perú? filter	0 may 26	3
[[(LATAM)(CHILE)(OFICINA)(TELÉFONO)(+𝟱6-553~280-𝟹𝟹𝟺)]]¿Cómo hablar con un agente desde LATAM? code	0 jun 26	42
O19 EE - Cropped images in image block? filter	0 abr 26	2