aggregate_records
Group Odoo records by specified fields and compute aggregate measures like sum and count directly on the server with Postgres.
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 |
|---|---|---|---|
| model | Yes | ||
| group_by | Yes | ||
| measures | No | ||
| domain | No | ||
| lazy | No | ||
| limit | No | ||
| offset | No | ||
| order | No | ||
| instance | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |