Query issue


(Gobinda Nandi) #1

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?


(David Pilato) #2

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.


(Gobinda Nandi) #3

sorry its not working.


(David Pilato) #4

So read the rest of my post...

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


(system) closed #5

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.