Match an array element in the array of json objects in elasticsearch

Question

I am using elasticsearch-6.4.3

Let's say I have a sample document in the form:

{
"segment_details": [{
  "departure_airport_code": "DEL",
  "departure_time": "2019-10-10 03:00:00"
}, 
{
"departure_airport_code": "BOM",
"departure_time": "2019-10-11 23:00:00" 
}]
}

I wrote a query to get all the documents in which any of the elements of the segment_details has departure_airport_code of given code. The below query is working fine.

GET flight-cache_layers/_doc/_search
{
  "query": {
    "nested": {
      "path": "segment_details",
      "query": {
        "bool": {
          "must": [
            { "match": { 
              "segment_details.departure_airport_code": code }}
          ]
        }
      }
    }
  }
}

I want to write a query in which I want to check if any of the element of the segment_details contains any of the departure_airport_code in the given codes list.

GET flight-cache_layers/_doc/_search
{
  "query": {
    "nested": {
      "path": "segment_details",
      "query": {
        "bool": {
          "must": [
            { "match": { 
              "segment_details.departure_airport_code" IN codes }}  # something like this.
          ]
        }
      }
    }
  }
}

jaspreet chahal · Accepted Answer · 2019-10-03 10:52:54Z

1

Nested Aggregation You can use a should clause where a text should match any of these values.

"query": {
    "nested": {
      "path": "segment_details",
      "query": {
        "bool": {
          "should": [
            {
              "match": {
                "FIELD": "TEXT"  --> replace field with your field and text with value
              }
            },
             {
              "match": {
                "FIELD": "TEXT"
              }
            }
          ]
        }
      }
    }
  }

If you are searching for exact words, you can use terms query

"query": {
    "nested": {
      "path": "segment_details",
      "query": {
        "bool": {
          "must": [
            {
              "terms": {
                "FIELD": [ --> replace field with your field and value array with values, you might need to use field.keyword as per your mapping 
                  "VALUE1",
                  "VALUE2"
                ]
              }
            }
          ]
        }
      }
    }
  }

edited Oct 3, 2019 at 10:52

answered Oct 3, 2019 at 10:23

jaspreet chahal

9,1392 gold badges14 silver badges30 bronze badges

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

3 Comments

Bhawan Over a year ago

segment_details is an array of objects. And departure_airport_code is a field in that object. The above solution working if departure_airport_code is directly nested inside segment_details like this: {"segment_details":{"departure_airport_code": "DEL"}}

jaspreet chahal Over a year ago

is segment_details of nested type

Bhawan Over a year ago

Yes, it is of nested type.

Collectives™ on Stack Overflow

Match an array element in the array of json objects in elasticsearch

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related