How to query elasticsearch nested object using fuzziness and wildcard query

Question

{  
   "took":1,
   "timed_out":false,
   "_shards":{  
      "total":5,
      "successful":5,
      "skipped":0,
      "failed":0
   },
   "hits":{  
      "total":1,
      "max_score":1,
      "hits":[  
         {  
            "_index":"event_11",
            "_type":"_doc",
            "_id":"1",
            "_score":1,
            "_source":{  
               "title":"Event One",
               "comments":{  
                  "author":"Alvin",
                  "author_id":1
               }
            },
            "inner_hits":{  
               "comments":{  
                  "hits":{  
                     "total":1,
                     "max_score":1,
                     "hits":[  
                        {  
                           "_index":"event_11",
                           "_type":"_doc",
                           "_id":"1",
                           "_nested":{  
                              "field":"comments",
                              "offset":0
                           },
                           "_score":1,
                           "_source":{  
                              "author":"Alvin",
                              "author_id":1
                           }
                        }
                     ]
                  }
               }
            }
         }
      ]
   }
}

I am trying to query the above data with the below wildcard query:

GET event_11/_search
{
  "query": {
    "nested": {
      "path": "comments",
        "query": {
          "wildcard": {
              "comments.author": "Al*"
          } 
        }
    }
  }
}

The above query is giving empty result set. Can someone help me fix the search query using wildcard and fuzziness? I am using ElasticSearch 6 and Kibana to create my queries. PHP SDK is used to write queries from PHP application.

Answer 1

You can try this.

  {
    "query": {
      "nested": {
        "path": "comments",
        "query": {
          "bool": {
            "should": [
              {
                "wildcard": {
                  "comments.author": "real*"
                }
              },            
              {
                "match": {
                  "comments.author": {
                    "query": "reaa",
                    "fuzziness": "AUTO"
                  }
                }
              }
            ]
          }
        }
      }
    }
  }