COREAI+0
Aggregate route and widget tool (backend)
Add the aggregate CRUD route (sums, averages, time series, top-N with "Others", previous-period comparison) under the caller's permissions, make summarize use the same engine, and let the in-app assistant emit validated kpi/chart/graph objects through a show_widget tool.
Tasks.
- Task 1: Error codes, exception, limits, config0/5
- Task 2:
ColumnKinds(what is measurable) and the test kit0/5 - Task 3: Time buckets, day truncation, periods0/5
- Task 4:
AggregateQuery,AggregateRequest0/5 - Task 5: The engine, totals only, and
CrudService::aggregate0/5 - Task 6: Grouping by column and by relation column, labels, sort, limit, "Others"0/5
- Task 7: Time buckets, periods, comparison0/5
- Task 8: Currency detection and mixed currencies0/5
- Task 9: Route, controller action, rate limiter, errors, Core documentation0/5
- Task 10:
summarizedelegates to the engine0/5 - Task 11: Capability,
WidgetObjectCollectorandShowWidgetTool0/5 - Task 12: Wiring, emission, stream event, capabilities, AI documentation0/5
- Task 13:
graphobjects0/5 - Task 14: Cross-driver check and delivery0/4