elasticsearch query nested array of objects

Question

Hi I am trying to get a query to filter based on values in an array of objects, the structure is like this

{
  "_index": "test",
  "_type": "home",
  "_id": "1247816",
  "_score": 1,
  "_source": {
    "TranCust": {
      "CustId": 1247816,
      "sourceNodeName": "SRC"
    },
    "TranList": [
      {
        "TranId": 2431015,
        "batchNr": "211"
      },
      {
        "TranId": 2431016,
        "batchNr": "213"
      }
    ]
  }
}

as an example, i would like to find all documents with a TranId of 2431015, my query looks like this

{
  "query": {
    "bool": {
      "must": [
        {
          "nested": {
            "path": "TranList",
            "query": {
              "bool": {
                "must": [
                  {
                    "match": {
                      "TranId": "2431015"
                    }
                  }
                ]
              }
            }
          }
        }
      ]
    }
  }
}

it seems to return no results, is there a better way to try and write this query ?

EDIT, here are the mappings put in

{
 "mappings": {
    "home": {
        "properties": {
            "TranCust": {
                "type": "object"
                }
            },
            "TranList": {
                "type": "nested"
            }
        }
    }
 }
}

Are you sure your objects are stores as nested type, rather than object? — Evaldas Buinauskas
– Evaldas Buinauskas, Commented Nov 9, 2015 at 9:35

Joshua G · Accepted Answer · 2024-10-30 14:44:56Z

15

ok, so after lots of attempts this is how i got it to work

{
  "query": {
    "nested": {
      "path": "TranList",
      "query": {
        "bool": {
          "must": [{
            "match": {
              "TranList.TranId": "2431015"
            }
          }]
        }
      }
    }
  }
}

edited Oct 30, 2024 at 14:44

Joshua G

2,1363 gold badges21 silver badges25 bronze badges

answered Nov 9, 2015 at 9:59

user2168435

7622 gold badges10 silver badges28 bronze badges

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

1 Comment

Sourabh Over a year ago

this can be more simplfied , check this out -

{     "query": {         "nested": {             "path": "TranList",             "query": {                 "match": {                    "TranList.TranId": "2431015"                 }             }         }     } }

Ricardo · Accepted Answer · 2022-07-27 01:16:13Z

9

Not sure what was your ES version, but the following should ideally work for ES 6.x+ versions. You don't actually need to wrap your nested query with bool:must

{
    "query": {
        "nested" : {
            "path" : "TranList",
            "query" : {
                "bool" : {
                    "must" : [
                        { "match" : {"TranList.TranId" : "2431015"} }
                    ]    
                }
            }
        }
    }
}

edited Jul 27, 2022 at 1:16

Ricardo

4,4085 gold badges43 silver badges58 bronze badges

answered Feb 3, 2019 at 16:37

tugcem

1,1083 gold badges15 silver badges25 bronze badges

Comments

Ricardo · Accepted Answer · 2022-07-27 01:18:44Z

3

{
  "query": {
    "query_string": {
      "default_field": "TranList.TranId",
      "query": "2431015"
    }
  }
}

edited Jul 27, 2022 at 1:18

Ricardo

4,4085 gold badges43 silver badges58 bronze badges

answered Jan 10, 2019 at 14:20

Hamza Aassif

393 bronze badges

1 Comment

Imantas Over a year ago

Could you elaborate on how does your answer solve the problem?

Collectives™ on Stack Overflow

elasticsearch query nested array of objects

3 Answers 3

1 Comment

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related