How to Use Search Domain Operators in Odoo 17
Cybrosys Technologies
09-05-2024
1. Equal (=)
The equal operator (=) is used to find records that exactly match a given value.
2. Not Equal Operator (!=)
The not-equal operator (!=) does the opposite. It helps you find records that do not match a specified value.
3. Greater Than (>)
This operator (>) is essential for filtering records based on numerical or date values.
4. Less Than (<)
This operator (<) is essential for filtering records based on numerical or date values.
5. Greater Than or Equal to (>=)
This operator is similar to the greater than operator, this operator (>=) includes records where the field value is equal to the specified value.
6. Less Than or Equal to (<=)
This operator is similar to less than the operator, this operator (<=) includes records where the field value is equal to the specified value.
7. Like Operator ('like')
The like operator in Odoo is used for case-sensitive text matching to filter records.To find records whose names contain ‘Johnson’ in a case-sensitive manner.
8. Not Like Operator ('not like')
The not-like operator in Odoo is used to filter records that do not contain a specific string in a case-sensitive manner.
9. In Operator ('in')
The in operator helps you find records where a field's value is one of the specified values in a list
10. Not In Operator ('not in')
The not in operator identifies records where the field's value is not in the list
11. Ilike Operator
The ilike operator in Odoo is used for case-insensitive text matching. It helps you find records that contain a specific string, regardless of letter case.
12. not ilike Operator
The NOT ilike operator in Odoo is used to filter records that do not contain a specific string in a case-insensitive manner.
13. =?
The =? operator in Odoo is used to filter records where a field's value is exactly equal to a specified value.
14. Child_of
In Odoo, the child_of domain operator is used to filter records that are either the specified record or any of its children in a hierarchical structure, such as parent-child relationships.