Neither aggregates nor groupBy exist in the GraphQL schema.
- Aggregation groupBy argument not available
- Aggregation HAVING not available
- Aggregation DISTINCT not available
Expected
GraphQL supports aggregates and groupBy for SQL Server entities, including:
sum, average, min, max, count
groupBy: { fields: [...] }
having filters on aggregates
distinct: true on count
Schema
{"fields": [
{"name": "items"},
{"name": "endCursor"},
{"name": "hasNextPage"},
{"name": "groupBy"} // exists as a FIELD on the connection, not as a query argument
]}
Reproduct
# All of these fail with "field does not exist" or "argument does not exist"
# 1. Basic aggregation
{ todos { aggregates { id { count } } } }
# Error: "The field `aggregates` does not exist on the type `TodoConnection`."
# 2. groupBy as argument
{ todos(groupBy: { fields: ["completed"] }) { items { completed } } }
# Error: "The argument `groupBy` does not exist."
# 3. Aggregate without groupBy
{ todos { aggregates { id { sum average min max count } } } }
# Error: "The field `aggregates` does not exist on the type `TodoConnection`."
Neither aggregates nor groupBy exist in the GraphQL schema.
Expected
GraphQL supports aggregates and groupBy for SQL Server entities, including:
sum, average, min, max, count
groupBy: { fields: [...] }
having filters on aggregates
distinct: true on count
Schema
{"fields": [ {"name": "items"}, {"name": "endCursor"}, {"name": "hasNextPage"}, {"name": "groupBy"} // exists as a FIELD on the connection, not as a query argument ]}Reproduct