ElasticSearch filter query for having null value

Question

I want to filter data from elasic search document like documents which is having blank list. HOw can i achieve that. Suppose i want this results.

1) { name:'vipul', gender:[] }

this is having blank list

This answer may help: stackoverflow.com/questions/32949321/… (hint: use bool/must_not/exists) — Val
– Val, Commented Oct 22, 2018 at 14:21

Most Wanted · Accepted Answer · 2020-05-28 18:42:33Z

12

You can combine a bool query with a exists query like so:

"bool": {
    "must_not": [
        {
            "exists": {
                "field": "gender"
            }
        }
    ]
}

Most Wanted

7,2498 gold badges64 silver badges82 bronze badges

answered Oct 22, 2018 at 19:47

hudsonb

2,32420 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1