Search Odoo records
aidoo_querySearch and read Odoo records using domain filters, with sorting, pagination, and offset-based retrieval to access all matching records.
Instructions
Search and read records from an Odoo model using a domain filter. Returns pagination info (total_count, has_more, next_offset) so you know if more records exist. Supports 'order' for sorting. WARNING: results are paginated (default 80 records). For statistics or aggregations, use aidoo_report instead. If you need ALL records, you MUST loop with offset=next_offset while has_more=true.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | ||
| model | Yes | ||
| order | No | ||
| domain | Yes | ||
| fields | No | ||
| offset | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |