Elasticsearch filtered search for sub-object fields

Question

How to perform a filtered search in ElasticSearch in a sub-object field? For example, my document has a field idand data, which is a JSON array, as the data was stored in my database:

{_id: 000, merchant: "merchant_1", email: "[e-mail]"}

My search query:

"query": {
    "filtered": {
        "filter": { "term": { "data.merchant": "merchant_1"} },
        "query": {
            "query_string": {"query": "hello"} }
        }
    }
}

returns nothing, but executing a query using query_string helloreturns the correct rows. Change "data.merchant"=> "merchant"also does not change anything.

Am I doing something wrong here?

Update: . In the end, I just used a logical query that worked.

Answer 1

"query": {
    "filtered": {
        "filter": { "term": { "data.merchant": "merchant_1"} },
        "query": {
            "query_string": {
                "default_field": "_all",
                "query": "hello"
            }
        }
    }
}

This should work for your case.