is there anyway specify key list terms aggregation.
for example query. filter member field values 72,16,92
{ "from": 0, "size": 0, "query": { "filtered": { "filter": { "and": [{ "or": [{ "term": { "member": 72 } }, { "term": { "member": 16 } }, { "term": { "member": 92 } }] }] }, "query": { "match_all": {} } } }, "aggs": { "member": { "terms": { "field": "member", "order": { "_term": "asc" }, "size": 100 } } } }
aggregation result returns 16 , 72 because member=92 not match document.
{ "took": 6, "timed_out": false, "_shards": { "total": 5, "successful": 5, "failed": 0 }, "hits": { "total": 2360, "max_score": 0, "hits": [] }, "aggregations": { "member": { "doc_count_error_upper_bound": 0, "sum_other_doc_count": 0, "buckets": [{ "key": 16, "doc_count": 2357 }, { "key": 72, "doc_count": 3 }] } } }
i want keys in aggregation result doc_count 0 not exists in resultset
try add min_doc_count
"aggs": { "member": { "terms": { "field": "member", "min_doc_count": 0, "order": { "_term": "asc" }, "size": 100 } }
Comments
Post a Comment