I have a very strange problem with the following elasticsearch query on https://es.kucha-leipzig.de/kucha_deep_new/_search (username: “read_only_user”, password: “kuchaReadOnly”):

{
    "query": {
        "bool": {
            "must": [
                {
                    "nested": {
                        "path": "relatedIconographyList",
                        "query": {
                            "nested": {
                                "path": "relatedIconographyList",
                                "query": {
                                    "terms": {
                                        "relatedIconographyList.iconographyID": [
                                            2308
                                        ]
                                    }
                                }
                            }
                        }
                    }
                }
            ]
        }
    }
}

The resulting answer (please query it by your own, it is to big to be included here) includes two hits: Depiction-1914 and Depiction-2197 which shouldn’t be included in this elasticsearch result, because, they do not include iconographyId 2308 in their relatedIconographyList.

The most intreaging part is, that elastic also thinks that way. If I ask elastic on which decisions it included Depiction-1914 in the results (_explain) it answers:

{
    "_index": "kucha_deep_new",
    "_type": "_doc",
    "_id": "Depiction-1914",
    "matched": false,
    "explanation": {
        "value": 0.0,
        "description": "Not a match",
        "details": []
    }
}

Can someone explain to me, what is going wrong here?

Thanks in advance,

Erik