full-text search, boolean logic, and range filters

PUT /products
{
  "mappings": {
    "properties": {
      "name": { "type": "text" },
      "description": { "type": "text" },
      "price": { "type": "float" },
      "category": { "type": "keyword" },
      "in_stock": { "type": "boolean" }
    }
  }
}

POST /products/_doc
{
  "name": "Ergonomic Office Chair",
  "description": "Comfortable chair with lumbar support",
  "price": 199.99,
  "category": "Furniture",
  "in_stock": true
}

GET /products/_search
{
  "query": {
    "bool": {
      "must": [
        { "match": { "name": "chair" } },
        { "term": { "in_stock": true } }
      ],
      "filter": {
        "range": { "price": { "lte": 200 } }
      }
    }
  },
  "aggs": {
    "categories": {
      "terms": { "field": "category" }
    }
  }
}