Filtering based on results of aggregations is not supported

[cezet]

Hi!

in 2014 there was a question regarding filtering over aggregation:

Help with ES 1.x aggregation range filter over "sum" value

I have an index full of user transactions. credit is the amount of an individual transaction. To get a list of users with most total credits I have this working fine { "size": 0, // only interested in aggregation info "aggs": { "users": { "terms": { "field": "user_id", "order": { "total_sum.sum": "desc" } }, "aggs": { "total_sum": { "sum": { "field": "credit" } } } } } } which is roughly equivalent in SQL: SELECT user_id, SUM(credit) FROM index ORDER BY SUM(credit) DESC L…

the answer was: Filtering based on results of aggregations is not supported unfortunately

Whether filtreing based on results of aggregation possible now?

Thanks!