aggregate_records
Aggregate Odoo records by specified fields with sum and count measures. Uses server-side PostgreSQL grouping for efficient data analysis.
Instructions
Aggregate Odoo records server-side using Postgres groupby/sum/count. Uses formatted_read_group on Odoo 19+ and falls back to read_group.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| model | Yes | ||
| group_by | Yes | ||
| measures | No | ||
| domain | No | ||
| lazy | No | ||
| limit | No | ||
| offset | No | ||
| order | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |