Adding two filters with one query in elasticsearch

Question

I am trying to combine a range filter query, a bool-must-match query, and a constant score (terms) filter query all in one query. I have both the range filter query and the bool-must-match query combine so far:

{
  "query": {
    "bool": {
      "must": [
        {
          "match": {
            "market": "Android"
          }
        }
      ],
      "filter": [
        {
          "range": {
            "sold": {
              "gte": "20170601",
              "lte": "20170602"
            }
          }
        }
      ]
    }
  }
}

How do I add this query in there:

{
    "query" : {
        "constant_score" : {
            "filter" : {
                "terms" : { 
                    "price" : [200, 300]
                }
            }
        }
    }
}

Is there a way to combine all three together?

Val · Accepted Answer · 2017-07-11 06:42:45Z

0

You can simply add it in the bool/filter section as filters have a constant score:

{
  "query": {
    "bool": {
      "must": [
        {
          "match": {
            "market": "Android"
          }
        }
      ],
      "filter": [
        {
          "terms": {
            "price": [
              200,
              300
            ]
          }
        },
        {
          "range": {
            "sold": {
              "gte": "20170601",
              "lte": "20170602"
            }
          }
        }
      ]
    }
  }
}

answered Jul 11, 2017 at 6:42

Val

218k14 gold badges377 silver badges384 bronze badges

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

Collectives™ on Stack Overflow

Adding two filters with one query in elasticsearch

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related