Conditions on array of objects in ElasticSearch

Question

Still new to ES so apologies if this is obvious. Let's say I have a document with the structure like this

{..., 'objectArray': [{'a': 3, 'b': 2}, {'a': 0, 'b': 4}]}

in which my objectArray property is an array of objects. How would I query for documents in this index that have an object within objectArray with a = 3 and b = 4? So the above document would not be in the result set but

{..., 'objectArray': [{'a': 3, 'b': 2}, {'a': 3, 'b': 4}]}

would be

If you could show an example in NEST or just illustrate the type of query so I could read about it, that would be awesome, thanks so much

rabbitbr · Accepted Answer · 2022-11-30 02:22:55Z

1

Assuming that we are talking about a property of type nested, we use nested query.

Mapping

PUT idx_nested
{
  "mappings": {
    "properties": {
      "objectArray":{
        "type": "nested"
      }
    }
  }
}

Documents

POST idx_nested/_doc
{
  "objectArray": [
    {
      "a": 3,
      "b": 2
    },
    {
      "a": 0,
      "b": 4
    }
  ]
}


POST idx_nested/_doc
{
  "objectArray": [
    {
      "a": 3,
      "b": 2
    },
    {
      "a": 3,
      "b": 4
    }
  ]
}

Query

GET idx_nested/_search
{
  "query": {
    "nested": {
      "path": "objectArray",
      "query": {
        "bool": {
          "must": [
            {
              "term": {
                "objectArray.a": {
                  "value": 3
                }
              }
            },
            {
              "term": {
                "objectArray.b": {
                  "value": 4
                }
              }
            }
          ]
        }
      }
    }
  }
}

Response:

"hits": [
  {
    "_index": "idx_nested",
    "_id": "4j5VxoQBiZR2Tvxo_zXz",
    "_score": 2,
    "_source": {
      "objectArray": [
        {
          "a": 3,
          "b": 2
        },
        {
          "a": 3,
          "b": 4
        }
      ]
    }
  }
]

answered Nov 30, 2022 at 2:22

rabbitbr

3,2712 gold badges8 silver badges20 bronze badges

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

1 Comment

pbordeaux Over a year ago

Ahh so I need the nested mapping for this, ok awesome! thanks again

Collectives™ on Stack Overflow

Conditions on array of objects in ElasticSearch

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related