How to search in elasticsearch with filtering by attributes?

Question

Yii

There is an index, it contains a collection with the following mapping:

{
  "sitcenter": {
    "mappings": {
      "periodical": {
        "properties": {
          "access_index": {
            "type": "integer"
          },
          "category_id": {
            "type": "integer"
          },
          "keywords": {
            "type": "text"
          },
          "keywords_kk": {
            "type": "text"
          },
          "publish_date": {
            "type": "date"
          }
        }
      }
    }
  }
}

I'm trying to search for the word bus* while it is necessary that access_index be equal to or less than 10 The
request was made like this:

{
  "size": 50,
  "query": {
    "bool": {
      "should": {
        "wildcard": {
          "keywords": {
            "value": "автобус*",
            "boost": 2
          }
        }
      },
      "filter": {
        "range": {
          "access_index": {
            "lte": 10
          }
        }
      }
    }
  }
}

Finds everything that matches the filter access_index <= 10, and does not take into account the wildcard, if I remove the filter, then everything is searched correctly. What am I doing wrong? Tell.
And another question, how to add a condition to the filter that the category_id can be 30, 38, 49 (as in SQL IN)

Answer 1

This is how it works on elasticsearch version 6.0.0

{
  "query": { 
    "bool": { 
      "must": {
        "wildcard": {
          "keywords": {
            "value": "автобус*",
            "boost":2
          }
        }
      },
      "filter": [ 
        { "terms":  { "category_id": [33, 35] }}, 
        { "range": { "access_index": { "lte": 30 }}} 
      ]
    }
  }
}