Build multiple filter in Elasticsearch

Question

Can you suggest how do I build a query based on multiple filter. Currently, I want to implement a search functionality using the following filters:

ProductName
Countries (array)
Cities (array)

The requirements is that, when counties or cities has no selected value, the query assumes that you are searching all countries and cities. If there are selected counties and cities, then the result should be base on the selected counties and cities.

I have the query below to start with.

static void Main(string[] args)
{   
    var uri = new Uri("http://localhost:9200");
    var connectionPool = new SingleNodeConnectionPool(uri);
    var settings = new ConnectionSettings(connectionPool);

    var client = new ElasticClient(settings);

    if (counties.Count > 0) 
    {
        foreach(string country in counties)
        {
            // Add a query to be added in client.Search     
        }
    }

    if (cities.Count > 0)
    {
        foreach(string city in cities)
        {
            // Add a query to be added in client.Search
        }
    }

    client.Search<Product>(s => s
                            .Query(q => q
                                .Bool(b => b
                                    .Must(mu => mu
                                        .Match(m => m
                                            .Field(f => f.ProductName)
                                            .Query("some text")
                                        ),
                                        .
                                    )
                                )
                            )
                        );
}

Do you have fields for cities and for countries? What do they contain? — ghusse, Apr 27 '17 at 12:13

score 2 · Accepted Answer · answered May 02 '17 at 07:57

I just answer my own question. Currently, I came with this approach.

var sd = new SearchDescriptor<object>();
var qc = new QueryContainer();
var qd = new QueryContainerDescriptor<object>();

sd.From(0);
sd.Size(100);
sd.Index("Products");
sd.Type("Product");

if (!string.IsNullOrEmpty(title))
{
    qc = qd.Match(m1 => m1
        .Field("title")
        .Query(title)
    );
}

if (countries.Count > 0)
{
    qc = qd.Terms(t => t
            .Field("country")
            .Terms(countries.ToArray())
        );
}

if (cities.Count > 0)
{
    qc = qd.Terms(t => t
            .Field("city")
            .Terms(cities.ToArray())
        );
}

sd.Query(q => q
        .Bool(b => b
            .Must(qc)
        )
    );

var result = client.Search<object>(s => s = sd);

score 1 · Answer 2 · answered Apr 27 '17 at 13:22

1

You can use the terms query:

{
  "query": {
    "bool": {
      "must": [
        { "match": { "field": "productName", "query": "some text"}},
        // Only add this filter if the array is not empty
        { "terms": { "Country": ["Canada", "France"]}},
        // Same here
        { "terms": { "City": ["Ottawa", "Paris"]}},
      ]
    }
  }
}

answered Apr 27 '17 at 13:22

ghusse

3,200
2
22
30

Thanks! Will try to convert it using NEST – klaydze Apr 28 '17 at 01:12
NEST reference documentation for `terms` query: https://www.elastic.co/guide/en/elasticsearch/client/net-api/current/terms-query-usage.html – Russ Cam Apr 28 '17 at 13:02

Build multiple filter in Elasticsearch

2 Answers2