CODEWITHSUNDEEP
elasticsearch
Martin Currah
Martin Currah

Reputation: 517

ElasticSearch with multiple filters

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.

Upvotes: 14

Views: 57183

Answers (3)

Mustafa Acar
Mustafa Acar

Reputation: 422

Here is how you can write multiple filter query

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

Upvotes: 14

Alcanzar
Alcanzar

Reputation: 17165

I think what you want is a bool query

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

Upvotes: 5

Nathan Smith
Nathan Smith

Reputation: 8347

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

Upvotes: 13

Related Questions