Filter Odoo records using ORM domain operators and avoid computed-field pitfalls

Steps

1. Build domain filters as lists of triples: [('field_name', 'operator', value)]; supported operators include '=', '!=', 'like', 'ilike', 'in', 'not in', '>=', '<='
2. Combine conditions with logical prefixes: ['&', condition1, condition2] for AND, ['|', condition1, condition2] for OR; the default when listing multiple conditions without a prefix is AND
3. Before filtering on a field, check whether it is a stored vs computed field using the model's fields_get() method or the Odoo source; stored fields map to database columns and are filterable
4. For non-stored computed fields, retrieve all candidate records and filter in Python/application code — attempting to filter on them via the ORM domain will raise an error or return empty results
5. Use 'limit' and 'offset' kwargs in search_read to paginate results and avoid loading entire tables