Elasticsearch nested search - must not include

Question

I'm having docs containning nested list

fixed_fields: [
    {
       id: 12,
       value: "someValue"
    },
    {
       id: 38,
       value: "someValue2"
    },
]

Now I need to find all documents that don't have fixed field with id = 38

I've tried:

            "bool":{
              "must":[
                {
                  "nested":{
                    "path":"fixed_fields",
                    "filter":{
                      "bool":{
                        "must_not":[
                          {
                            "term":{
                              "fixed_fields.id":38
                            }
                          }
                        ]
                      }
                    }
                  }
                }
              ]
            }

But I got all documents having any fixed_fields in response, including the ones with id 38.

I'm using elastic in version 2.4.6, and I don't have option to upgrade it

user3775217 · Accepted Answer · 2019-02-11 10:52:53Z

3

Try this instead:

{
 "bool": {
    "must_not": [{
        "nested": {
            "path": "fixed_fields",
            "filter": {
                "term": {
                    "fixed_fields.id": 38
                }
            }
        }
    }]
  }
}

edited Feb 11, 2019 at 10:52

user3775217

4,8231 gold badge26 silver badges33 bronze badges

answered Feb 11, 2019 at 8:16

Val

218k14 gold badges377 silver badges384 bronze badges

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

Collectives™ on Stack Overflow

Elasticsearch nested search - must not include

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related