Query issue

[inandi (Gobinda Nandi)]

i have this document

{
   "createTime" => "2018-01-05T05:49:14.050Z",
     "reviewId" => "AIe9_BGErQpX2pRNZrXBy5NOsH0eH9QFkVat2vH-a3aJ-Crxe_ifrVuMokjr1zist4BFWRGP70uG38nMXJ1Fuv1zWSNJD7e6y03lAFbMvHFVpt1_ew-puWA",
   "locationId" => "9166534068115432035",
    "json_data" => [
       {
               "Keyword_score" => 0.9,
            "Keyword_salience" => 0.7635041,
           "Keyword_magnitude" => 0.9,
                     "Keyword" => "Company"
       },
       {
               "Keyword_score" => 0,
            "Keyword_salience" => 0.13866921,
           "Keyword_magnitude" => 0,
                     "Keyword" => "Interview"
       }
   ],
   "starRating" => "4",
      "comment" => "Nice Company. Attended Interview but Still No Response.",
        "score" => 0.2,
    "user_name" => "FirkyTube Studio",
    "magnitude" => 1
}

I want to search who has "interview" keyword?

[dadoonet (David Pilato)]

This should work I guess...

GET /_search?q=json_data.Keyword:Interview

If not, please provide a full recreation script as described in About the Elasticsearch category. It will help to better understand what you are doing. Please, try to keep the example as simple as possible.

A full reproduction script will help readers to understand, reproduce and if needed fix your problem. It will also most likely help to get a faster answer.

[inandi (Gobinda Nandi)]

sorry its not working.

[dadoonet (David Pilato)]

So read the rest of my post...

If not, please provide a full recreation script ....