C# elastic search query, match multiple queries

Question

I have 2 elastic search queries that need to be matched by each fetched document in different ways. The "pools" query is a terms query. Each document has a list of pools attached to it, each of them being a string, and at least one of those pools must be in the provided list of pools in the "pools" query.

The other query is actually composed of multiple queries and at least 75% percent of them should be matched.

So in order for a document to be matched, the "pools" query must always be matched and from the other query, at least 75% must be matched.

I wrote my query like this:

 var matchQuery = BuildQuery(searchCriteria);
 var poolQuery = BuildPoolsQueryField(searchCriteria);

 // prepare the data for elasticsearch
 var result = await _elasticSearchClient.SearchAsync<ElasticPersonEntity>(
          p => p.Query(q => q
                 .Bool(b => b.Must(poolQuery).Should(matchQuery.ToArray())
                 .MinimumShouldMatch(MinimumShouldMatch.Percentage(75))))).ConfigureAwait(false);

But I could not find anywhere on the internet if you can chain multiple Should and Must clauses and what it happens if you chain them like this.

marc_s · Accepted Answer · 2019-02-14 06:53:10Z

1

According to your description, your query is wrong: you need to mustpoolQuery && matchQuery(75%) so

The .MinimumShouldMatch(MinimumShouldMatch.Percentage(75) should be inside your matchQuery :

I join an example (using my data, but this should solve your problem)

.Query(q => q
                    .Bool(b => b
                        .Must(
                            mu => mu.Term(te => te.CntCd, "FR"),
                            mu => mu.Bool(bo => bo
                                .Should(your should query).MinimumShouldMatch(75)    
                            )
                       )
                    )
                )

edited Feb 14, 2019 at 6:53

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

answered Feb 12, 2019 at 11:09

LeBigCat

1,7801 gold badge14 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

C# elastic search query, match multiple queries

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related