| Previous | Next |
| QUERY_E_UPGRADEINPROGRESS | QUERY_E_TOP_LEVEL_IN_GROUP |
QUERY_E_AGGREGATE_NOT_SUPPORTED
QUERY_E_AGGREGATE_NOT_SUPPORTED belongs to grouped query construction. Windows Search supports a defined aggregate set inside GROUP ON ... OVER; it is not a general SQL database with arbitrary aggregate functions.
Compare the aggregate with the documented Windows Search set
- Log the aggregate function, target property, alias, and the surrounding group statement.
- Use documented functions such as
COUNT,MAX, andMINonly in the supported grouping position. - If an application requires a custom calculation, return the underlying rows or supported aggregates and calculate the value after query execution.
Microsoft’s aggregate examples place AGGREGATE between the group definition and OVER, with functions over searchable properties or rank. A generic SQL builder can easily emit database-specific aggregates that Windows Search never implemented. The fix is to target the search SQL dialect, not to add the missing function to the catalog schema or reindex documents.
Aggregate functions · GROUP ON ... OVER · Windows Search SQL syntax
Looking for a different code? Search another status or error code.