elasticsearch - Multi-Nested Elastic Query

Question

I am trying to return all documents that match a specific keyword property in a collection.

The image below represents the document hierarchy.

The AggregateRoot has a collection of GUID Id's in the property DomainElements.

I am trying write a query that returns all documents where the Id matches a specific Guid value.

the following image shows the nested path in the index schema;

When I attempt this query I do not return any results...

{
"query": {
    "nested": {
        "path": "boundedContexts",
        "query": {
            "nested": {
                "path": "boundedContexts.aggregateRoots",
                  "query": {
                    "nested": {
                    "path": "boundedContexts.aggregateRoots.domainElements",
                        "query": {
                            "bool": {
                                "must": [
                                    { "match": { "domainelements.id": "48be3bb4-838d-44a5-85e3-c5ea4fa8ee36" } }
                                ]
                            }
                        }
                    }
                }
            }
        }
    }
}

}

Here is the index documents which shows the data I am trying to query does exist ...

What am I missing?

Is there a more simplified way to query these results?

question from:https://stackoverflow.com/questions/65862449/multi-nested-elastic-query

Answer 1

You almost got it -- just make sure the complete nested path is included in the field name you're targeting:

{
  "query": {
    "nested": {
      "path": "boundedContexts",
      "query": {
        "nested": {
          "path": "boundedContexts.aggregateRoots",
          "query": {
            "nested": {
              "path": "boundedContexts.aggregateRoots.domainElements",
              "query": {
                "bool": {
                  "must": [
                    {
                      "match": {
                        "boundedContexts.aggregateRoots.domainElements.id": "48be3bb4-838d-44a5-85e3-c5ea4fa8ee36"
                      }
                    }
                  ]
                }
              }
            }
          }
        }
      }
    }
  }
}

BTW there's no need for so many (sub)nested queries. The inner-most nested path is enough:

{
  "query": {
    "nested": {
      "path": "boundedContexts.aggregateRoots.domainElements",
      "query": {
        "bool": {
          "must": [
            {
              "match": {
                "boundedContexts.aggregateRoots.domainElements.id": "48be3bb4-838d-44a5-85e3-c5ea4fa8ee36"
              }
            }
          ]
        }
      }
    }
  }
}