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
– ghusse, Commented Apr 27, 2017 at 12:13

klaydze · Accepted Answer · 2017-05-02 07:57:13Z

2

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);

answered May 2, 2017 at 7:57

klaydze

98116 silver badges37 bronze badges

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

Comments

ghusse · Accepted Answer · 2017-04-27 13:22:08Z

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, 2017 at 13:22

ghusse

3,2202 gold badges24 silver badges30 bronze badges

2 Comments

klaydze Over a year ago

Thanks! Will try to convert it using NEST 😃

Russ Cam Over a year ago

NEST reference documentation for terms query: elastic.co/guide/en/elasticsearch/client/net-api/current/…

Collectives™ on Stack Overflow

Build multiple filter in Elasticsearch

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related