Search Records
search_recordsFind records in Odoo 19 models using domain filters, field selection, sorting, and pagination to retrieve exactly the data you need.
Instructions
Search for records in an Odoo model.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | Maximum number of records | |
| model | Yes | Model name (e.g., 'res.partner') | |
| order | No | Sort order (e.g., 'name asc', 'create_date desc') | |
| domain | No | Odoo search domain (list of conditions). Examples: - Simple: [["name", "=", "John"]] - Multiple (AND): [["is_company", "=", True], ["active", "=", True]] - OR condition: ["|", ["name", "ilike", "test"], ["email", "ilike", "test"]] - any (Odoo 19+): [["order_line", "any", [["product_uom_qty", ">", 5]]]] - Operators: =, !=, >, >=, <, <=, like, ilike, in, not in, child_of, any | |
| fields | No | Fields to return (None = auto-exclude dangerous fields like binary/image/html) | |
| offset | No | Number of records to skip |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |