Odoo 12 Development Essentials - Fourth Edition

Creating recordsets

The search() method takes a domain expression and returns a recordset with the records matching those conditions. An empty domain [] will return all records.

If the model has the active special field, by default only the records with active=True will be considered.

The following keyword arguments can also be used:

• order is a string to be used as the ORDER BY clause in the database query. This is usually a comma-separated list of field names. Each field name may be followed by the DESC keyword, to indicate a descending order.
• limit sets a maximum number of records to retrieve.
• offset ignores the first n results; it can be used with limit to query blocks of records at a time.

Sometimes, we just need to know the number ...