Feature request · API & developer experience · Blocks work
Filter and order by aggregate values in where clauses
1 source thread · first seen 2019-01
Summary
Aggregate fields cannot be used in where or order_by, which makes it impossible to filter on an aggregation such as a related row count.
Evidence
Excerpts are copied word for word from the source; follow the link to read it in full.
“Currently, there's no support for aggregate fields in `where` and `order_by` clause, which means it's impossible to do filtering on aggregation”