how to add multiple conditions in ElasticSearch conditionally?

Question

on the following filter query:

 var searchResults = _client.Search<MyIndexable>(s => s
        .Query(q => q
            .Bool(b => b
                .Must(
                    subQuery => subQuery.QueryString(qs => qs.OnFields(f => f.Title, f => f.Description).Query(searchTerm + "*"")),
                    subQuery => subQuery.Term(f => f.field1, "some string"),
                    subQuery => subQuery.Term(f => f.field2 , "some Guid")))));

I wanted to add each filter below conditinally under Must. like

 if (request.field2)
     ubQuery.Term(f => f.field1, "some string"

can anyone help me to do this?.

bittusarkar · Accepted Answer · 2016-01-12 18:48:59Z

1

It can be done in Nest. See the code below:

var funcs = new List<Func<QueryDescriptor<MyIndexable>, QueryContainer>>();
funcs.Add(subQuery.QueryString(qs => qs.OnFields(f => f.Title, f => f.Description).Query(searchTerm + "*"")));

if (request.field2) // I believe this is some bool variable
{
    funcs.Add(subQuery => subQuery.Term(f => f.field1, "some string"));
}

funcs.Add(subQuery => subQuery => subQuery.Term(f => f.field2 , "some Guid"));

var searchResults = _client.Search<MyIndexable>(s => s
    .Query(q => q
        .Bool(b => b
            .Must(funcs.ToArray()))));

answered Jan 12, 2016 at 18:48

bittusarkar

6,3674 gold badges35 silver badges51 bronze badges

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

4 Comments

Sasi Over a year ago

bittusarkar, how do I get subQuery instance to add filter Under BoolFilterDescriptor(Must) on the above case ?. like I need to add ExistFilter instead of QueryString and then terms filters conditionally ?

Sasi Over a year ago

"filter": { "bool": { "must": [ { "exists": { "field": "Cid" } }, { "exists": { "field": "prf" } }, { "term": { "IsActive": true } },

bittusarkar Over a year ago

You don't need to define subQuery anywhere. It is part of the Func definition. The code that I've pasted is syntactically correct. You can replace QueryString with any other query you want to implement.

Sasi Over a year ago

oh..yes I got it. in my case I used FilterDescriptor instead of QueryDescriptor per above json filter string.. and its working fine. Thank you for your help

schellingerht · Accepted Answer · 2016-01-12 18:09:09Z

0

It's difficult for you because of method chaining.

It's more handable to set the configuration in json. Because json is a string, it's simple to break it and insert conditions, etc.

Example:

$config = '{
    "query":
    {';

if (condition) {
    $config .= '"match":
    {
        "foo": "bar"
    }';   
}

$config .= '
    }
}';

Of course, you're free to choose the way to build a json string.

edited Jan 12, 2016 at 18:09

answered Jan 12, 2016 at 18:04

schellingerht

5,8062 gold badges30 silver badges56 bronze badges

Collectives™ on Stack Overflow

how to add multiple conditions in ElasticSearch conditionally?

2 Answers 2

4 Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Related