Full list of search domain operators in Odoo

 In this article you will learn about search operators used in Odoo search and domain filters. Each tuple in the search domain needs to have three elements, in the form of 

Comparison Operators in Odoo

('field_name', 'operator', value)

 where:

Element	Description
field_name	field_name must be a valid name of field of the object model, possibly following many-to-one relationships using dot-notation, e.g 'street' or 'partner_id.country' are valid values.
operator	operator must be a string with a valid comparison operator from this list: =, !=, >, >=, <, <=, like, ilike, in, not in, child_of, parent_left, parent_right The semantics of most of these operators are obvious. The child_of operator will look for records who are children or grand-children of a given record, according to the semantics of this model (i.e following the relationship field named by self._parent_name, by default parent_id.
value	value must be a valid value to compare with the values of field_name, depending on its type.

Now I am going to show you the example of usage of these operators.

Operator	Usage	Description
like	[('input', 'like', 'open')]	Returns case sensitive (wildcards - '%open%'). O/p: open, opensource, openerp, Odooopenerp
not like	[('input', 'not like', 'open')]	Returns results not matched with case sensitive (wildcards - '%open%'). O/p: Openerp, Opensource, Open, Odoo, odoo, OdooOpenerp
=like	[('name', '=like', 'open')]	Returns exact (= 'open') case sensitive search. O/p: open
ilike	[('name', 'ilike', 'open')]	Returns exact case insensitive (wildcards - '%open%'). O/p: Openerp, openerp, Opensource, opensource, Open, open, Odooopenerp, OdooOpenerp
not like	[('name', 'not ilike', 'open')]	Returns results not matched with exact case insensitive (wildcards - '%open%'). O/p: Odoo, odoo
=ilike	[('name', '=ilike', 'open')]	Returns exact (= 'open' or 'Open') case insensitive. O/p: Open, open
in	[('value1', 'in', ['value1', 'value2'])]	in operator will check the value1 is present or not in list of right term
not in	[('value1', 'not in', ['value2'])]	not in operator will check the value1 is not present in list of right term
=	[('input', '=', 'open')]	Returns case sensitive (exact match - 'open'). O/p: open
!=	[('input', '!=', 'open')]	Returns results not matched with given input (other than - 'open'). O/p: other than open records
>	[('input', '>', '10')]	Returns results greater than given input (other value greater than - '10'). O/p: 11, 12, 13
>=	[('input', '>=', '10')]	Returns results greater or equal of given input. O/p: 10, 11, 12, 13
<	[('input', '<', '10')]	Returns results less than given input (other value less than - '10'). O/p: 9, 8, 7
<=	[('input', '<=', '10')]	Returns results less or equal of given input. O/p: 10, 9, 8, 7