Question

How would you combine a bool query with a range filter to find documents with price between 10 and 50, must have in_stock true, and should have discount greater than 20%?

Accepted Answer

{"bool": {"filter": [{"range": {"price": {"gte": 10, "lte": 50}}}, {"term": {"in_stock": true}}], "should": [{"range": {"discount": {"gt": 20}}}]}}

Answer

{"bool": {"should": [{"range": {"price": {"gte": 10, "lte": 50}}}], "must": [{"term": {"in_stock": true}}], "filter": [{"range": {"discount": {"gt": 20}}}]}}

Answer

{"bool": {"must": [{"range": {"price": {"gte": 10, "lte": 50}}}], "filter": [{"term": {"in_stock": true}}], "must_not": [{"range": {"discount": {"gt": 20}}}]}}

Answer

{"bool": {"must_not": [{"range": {"price": {"gte": 10, "lte": 50}}}], "should": [{"term": {"in_stock": true}}], "filter": [{"range": {"discount": {"gt": 20}}}]}}

How would you combine a bool query with a range filter to find documents with price between 10 and 50, must have in_stock true, and should have discount greater than 20%?

Step 1: Use filter for price range and in_stock

Step 2: Use should for discount boosting

Final Answer:

Quick Check:

Want More Practice?