Nest query equivalent for following ElasticSearch Query

user_5357821 0
Viewed 439

I am new to dot net core. I am using https://www.elastic.co/guide/en/elasticsearch/client/net-api/current/nest.html as my elastic search client.

I have following query for written in elastic search:

{
    "query": {
        "bool":{
         "must":[
            {
               "term":{
                  "bookId.keyword":"c962ec04-6d25-4823-8e78-6d99d4072032"
               }
            },
            {
               "bool":{
                  "should":[
                     {
                        "match_phrase":{
                         "text":"Plants"
                        }
                     }
                  ]
               }
            }
         ]
      }
    }
}

While my NEST code is:

 var searchResponse = await _esClient.SearchAsync<Content>(s => s
                .Query(q => q
                    .Bool(b => b
                        .Must(m => m
                            .Term(terms => terms.Field(
                                    field => field.BookId.Suffix("keyword")
                                ).Value(bookId.ToString())
                            )
                        )
                        .Must(should =>
                            should.Match(mp => mp.Field(f => f.Text).Query(query))
                        )
                    )
                ));

However I am unable to get the intended result. Can anyone help me with this?

nest elasticsearch .net-core c#
2 Answers

Your NEST query does not exactly match the DSL query. Please modify your query to match the following.

var searchResponse = await _esClient.SearchAsync<Content>(s => s
    .Query(q => q
        .Bool(b => b
            .Must(m => m
                .Term(terms => terms
                    .Field(field => field
                        .BookId.Suffix("keyword"))
                        .Value(bookId.ToString())
                ) && m.Bool(mb => mb
                    .Should(sh => sh
                        .MatchPhrase(mp => mp
                           .Field(f => f.Text).Query(query))))
                    )
                )
            ));
user_92566990

You've almost got it. Must() takes a params[] of queries instead of calling it multiple times

var searchResponse = await _esClient.Search<Content>(s => s
   .Query(q => q
       .Bool(b => b
           .Must(m => m
               .Term(terms => terms.Field(
                       field => field.BookId.Suffix("keyword")
                   ).Value(bookId.ToString())
               ), m => m
               .Bool(mb => mb
                   .Should(sh => sh
                       .MatchPhrase(mp => mp
                           .Field(f => f.Text)
                           .Query(query)
                       )
                   )
               )
           )
       )
   )
);

Mahesh's answer is the more succinct way of writing this query with operator overloading.

Russ_Cam_18310
Related