Feature request to add back || and &&. Or to allow for dynamic building and joining of queries

[JonathonFord]

Is your feature request related to a problem? Please describe.
I need to build a query based on user input. Basically I want to generate something like this:
GET elasticIndexExample/_search { "query": { "bool":{ "must": [ { "range": { "creationDate": { "gte": "2004-08-02T05:00:00.000Z", "lte": "2004-10-02T05:00:00.000Z", "boost": 2.0 } } }, { "bool":{ "should": [ { "term":{ "customerName": "Wallmart" } }, { "term":{ "customerName": "Petco" } } ], "minimum_should_match": 1 } }, { "bool": { "should": [ { "term":{ "state": "OH" } }, { "term":{ "state": "MI" } } ], "minimum_should_match": 1 } } ] } } }
This query works for what I need. Also each should array doesn't HAVE to be there.

Describe the solution you'd like
I would like to be able to build the should arrays like this for the should arrays:
customerNameShouldQuery.Bool(boolQuery => boolQuery.Should(should => { foreach (var customerName in customerNameArray) { should.AddTerm(term => term.Field(field => field.CustomerName).Value(customerName) ); } }) .MinimumShouldMatch(1) );
Describe alternatives you've considered
The old way of using || to build a should array of term matches is ok, tho I cant set the minimum should match easily
var test = new QueryContainer(); foreach (var customerPO in customerPOs) { test = test || new QueryContainerDescriptor<ElasticLoad>().Term(term => term.CustomerPO, customerPO); }
Additional context
At the very least I dont know how to go about building a should array in the new version 8 off of an array of inputs

[flobernd]

Hi, the implicit operator feature currently only works when using the object initializer syntax, but not when using the fluent API. A feature request has already been opened for this one 🙂

It's well possible to dynamically build bool queries. A potential solution could look like this:

await client.SearchAsync<Person>(x => x
    .Query(x => x
        .Bool(boolQuery => boolQuery
            .Should(customerNameArray.Select<string, Action<QueryDescriptor<Person>>>(customerName => x => x
                .Term(term => term
                    .Field(field => field.CustomerName)
                    .Value(customerName)
                )
            ))
            .MinimumShouldMatch(1)
        )
    )
);

Please let me know if that solves your issue.

[github-actions]

This issue is stale because it has been open 5 days with no activity. Remove stale label or comment or this will be closed in 2 days.

[github-actions]

This issue was closed because it has been stalled for 2 days with no activity.