Elasticsearch - Query on array for matching multiple objects in the array

Question

I am trying to write a query that will match a document with a nested object that is an array of objects. Example :

{"ListName" : "List 1", "Fruits": [ { "name" : "Apple"}, {"name": "Orange"}, {"name" : "banana"} ] }

I would like to write a query were I get the document above based on the names inside the Fruits array, e.g. Apple and Orange.

What I currently have matches names with both Apple and Orange in the same name field rather than each object.

 {
  "query": {
    "nested": {
      "path": "Fruits",
      "query": {
        "bool": {
          "must": [
            {
              "term": {
                "Fruits.name": "Apple"
              }
            },
            {
              "match": {
                "Fruits.name": "Orange"
              }
            }
          ]
        }
      }
    }
  }
}

Val · Accepted Answer · 2018-04-14 05:58:20Z

3

You need to make two different nested queries in a bool/must query instead, like this:

{
  "query": {
    "bool": {
      "must": [
        {
          "nested": {
            "path": "Fruits",
            "query": {
              "term": {
                "Fruits.name": "Apple"
              }
            }
          }
        },
        {
          "nested": {
            "path": "Fruits",
            "query": {
              "match": {
                "Fruits.name": "Orange"
              }
            }
          }
        }
      ]
    }
  }
}

answered Apr 14, 2018 at 5:58

Val

218k14 gold badges377 silver badges384 bronze badges

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

Collectives™ on Stack Overflow

Elasticsearch - Query on array for matching multiple objects in the array

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