Breeze / breeze.server.net

Breeze support for .NET servers
MIT License
76 stars 62 forks source link

Support aggregate functions in queries #185

Closed NateRadebaugh closed 1 year ago

NateRadebaugh commented 1 year ago

From the docs here, breeze does not yet support aggregate functions.

https://breeze.github.io/doc-cs/query-in-depth.html

image

What would it take to support aggregate functions? For instance, using breeze queries to perform a "group by" to get the count or sum of a group label etc, to populate data for charts.

steveschmitt commented 1 year ago

It's a good question. Aggregation can get complicated, so it would be difficult to make a clean syntax.

What I've been doing on the server is applying the Breeze query to my IQueryable, then aggregating the results. See issue #97 for the implementation details. https://github.com/Breeze/breeze.server.net/issues/97

NateRadebaugh commented 1 year ago

Thanks I'll review that thread.

Might be worth adding to the docs somewhere.