ElasticSearch with multiple filters

Question

I am trying to build a query that will find all user documents (docType = user) and then filter them based on many filters. Such as location, gender, age, etc. The filters are added / removed based on user input on the search function I'm building.

Below returns no results:

{
    "query": {
        "filtered": {
            "query": {
                "match_all": {}
                },
                "filter": {
                    "and": {
                        "filters": 
                        [
                            {
                                "term": {
                                    "doc.docType": "user"
                                }
                            },
                            {
                                "term": {
                                    "doc.data.profile.location" : "CA"
                                }
                            }
                        ]
                    }
                }
        }
    }
}

Below return results:

{
    "query": {
        "filtered": {
            "query": {
                "field": {
                    "doc.data.profile.location" : "CA"
                }
                },
                "filter": {
                    "and": {
                        "filters": 
                        [
                            {
                                "term": {
                                    "doc.docType": "user"
                                }
                            }
                        ]
                    }
                }
        }
    }
}

The latter, although returning results, isn't going to work in the long run as I may want to include an extra filter for age, gender, etc and I can't seem to add multiple fields. The first query works if I remove the filter for location.

How did you get on with this?

Nathan Smith
– Nathan Smith

2014-05-01 15:20:28 +00:00
Commented May 1, 2014 at 15:20 — Nathan Smith
– Nathan Smith, Commented May 1, 2014 at 15:20
exactly what I needed. Worked a charm!

Martin Currah
– Martin Currah

2014-05-02 16:20:58 +00:00
Commented May 2, 2014 at 16:20 — Martin Currah
– Martin Currah, Commented May 2, 2014 at 16:20

Mustafa Acar · Accepted Answer · 2020-07-14 06:18:16Z

14

Here is how you can write multiple filter query

{
  "query": {
    "bool": {
      "filter": [
        {
          "term" : {
            "id":254
          }
        },
        {
          "term" : {
            "cityId":35
          }
        }
      ],
      "must": [
        {
          "match_all": {}
        }
      ]
    }
  }
}

answered Jul 14, 2020 at 6:18

Mustafa Acar

4223 silver badges10 bronze badges

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

Comments

Nathan Smith · Accepted Answer · 2014-04-30 14:46:16Z

13

The bool filter allows you to chain multiple MUST, SHOULD and SHOULD_NOT requests together. Allowing for you to construct this into one query.

answered Apr 30, 2014 at 14:46

Nathan Smith

8,3673 gold badges29 silver badges44 bronze badges

2 Comments

Martin Currah Over a year ago

Thank you. I will do more research and mark your answer as accepted soon if it turns out to be what I need :)

Raj Rajeshwar Singh Rathore Over a year ago

The bool filter is now replaced by the Bool Query : elastic.co/guide/en/elasticsearch/reference/current/…

Niek · Accepted Answer · 2019-07-15 12:23:50Z

5

I think what you want is a bool query

That way you can chain multiple musts together to get the desired result.

edited Jul 15, 2019 at 12:23

Niek

1,6391 gold badge20 silver badges32 bronze badges

answered Apr 30, 2014 at 14:33

Alcanzar

17.2k7 gold badges45 silver badges60 bronze badges

Collectives™ on Stack Overflow

ElasticSearch with multiple filters

3 Answers 3

Comments

2 Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

2 Comments

Comments

Linked

Related