This question has been flagged
3510 Views

Hello everyone. In my openerp have divided the field name in firstname and surname. The problem is I have to make a search of my clients. For example if a client of mine called John Doe, if I look John I get, if I look Doe also, but if I put John Doe did not appear in the filter. My question is if I can somehow I combine two fields in the xml for me to perform the search in both. Right now I have it so:

filter_domain="['|','|',('firstname','ilike',self),('surname','ilike',self),('parent_id','ilike',self),('ref','=',self) ]

And I'd like to do something like this:

filter_domain = "['|', '|', ('name + surname', 'ilike', self), ('parent_id', 'ilike', self), ('ref', '=', self)]

Thank you very much.

Avatar
Discard