Filtrar, agrupar y totalizar un arreglo
array-filter-aggregateAplica condiciones where a un arreglo de objetos (campos con punto), agrupa por campos y calcula count, count_distinct, sum, avg, min y max. Sin expresiones ni eval. Cuándo: hay que transformar, comparar o revisar con exactitud datos estructurados (JSON, CSV, YAML, XML, arreglos). No para: agrupar objetos por el valor de una clave y devolver grupos y conteos (array-group-by). Efectos secundarios: ninguno (solo lectura, sin red, sin estado guardado). Determinista: la misma entrada da la misma salida. Límites: entrada JSON de hasta 64 KB, 1 s por llamada, resultado de hasta 1 MB.
EN: Filters an array of objects with where-clauses (eq, ne, gt, gte, lt, lte, in, nin, contains, starts_with, ends_with, exists, is_null on dotted fields; all or any), then groups by fields and computes count, count_distinct, sum, avg, min and max. No expressions or eval. When: structured data (JSON, CSV, YAML, XML, arrays) has to be transformed, compared or checked exactly. [EN completo / full EN: inputSchema.description]
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| items | Yes | Array of objects (array; required). | |
| limit | No | Keep at most this many groups (integer; optional; min 1; max 10000). | |
| match | No | Combine conditions with all (AND) or any (OR) (optional; one of: all, any; default "all"). | all |
| order | No | Sort order (optional; one of: asc, desc; default "desc"). | desc |
| where | No | Conditions (array of object; optional; default []; up to 20 items). | |
| sort_by | No | Sort groups by an aggregate name or group field (string; optional; up to 200 chars). | |
| group_by | No | Fields to group by (array of string; optional; default []; up to 5 items). | |
| aggregates | No | Aggregates (default: count) (array of object; optional; default []; up to 20 items). |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| total | No | ||
| groups | No | ||
| matched | No | ||
| group_count | No |