aggregate_records
Aggregate Odoo records server-side with Postgres groupby, sum, and count operations. Supports both Odoo 19+ and earlier versions.
Instructions
Aggregate Odoo records server-side using Postgres groupby/sum/count. Uses formatted_read_group on Odoo 19+ and read_group on earlier versions.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| lazy | No | ||
| limit | No | ||
| model | Yes | ||
| order | No | ||
| domain | No | ||
| offset | No | ||
| group_by | Yes | ||
| instance | No | ||
| measures | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| rows | No | Aggregated group rows. | |
| tool | No | Reporting tool name. | |
| error | No | Sanitized error message when success is false. | |
| model | No | ||
| method | No | formatted_read_group (19+) or read_group. | |
| success | Yes | False when the call failed; see error. | |
| group_by | No | ||
| measures | No | ||
| row_count | No | ||
| major_version | No | ||
| fallback_reason | No |