search_records
Search for records in Odoo 19 models using flexible domain filters, specify return fields, and control pagination with sorting options.
Instructions
Search for records in an Odoo model.
Args: model: Model name (e.g., 'res.partner') domain: 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: Fields to return (None = auto-exclude dangerous fields like binary/image/html) limit: Maximum number of records offset: Number of records to skip order: Sort order (e.g., 'name asc', 'create_date desc')
Returns: JSON with records, total count, limit, and offset. Each record includes a '_url' field for direct browser access.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| model | Yes | ||
| domain | No | ||
| fields | No | ||
| limit | No | ||
| offset | No | ||
| order | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |