Would you like to have some 'like's and 'ilike's in your domain and attrs?

The point is domain calculations (attrs is also using domain) are done in JS not the database, so you can not use SQL commands such as 'ilike'.

But there is a way to add this function to Odoo rather easily with some coding. Edit view_form.js ( in openerp/addons/web/static/src/js), find this line:

case 'not in':
    if (!_.isArray(val)) val = [val];
    stack.push(!_(val).contains(field_value));
    break;

and add these lines after it:

case 'like':
    stack.push(field_value.indexOf(val)>=0);
    break;
case 'not like':
    stack.push(field_value.indexOf(val)<0);
    break;
case 'ilike':
    stack.push(field_value.toUpperCase().indexOf(val.toUpperCase())>=0);
    break;
case 'ilike':
    stack.push(field_value.toUpperCase().indexOf(val.toUpperCase())<0);
    break;

and save it, TADA you can use it now. warning: if you use it with a field which is not string, it will raise an error

Comments