json - Elasticsearch查询在 bool 值中使用范围时引发错误

Question

我正在使用status field和range查询 flex 搜索，但出现错误:

"type": "parsing_exception","reason": "[status] query malformed, no start_object after query name"

查询如下:

{
  "_source": {
    "includes": []
  },
  "query": {
    "bool": {
      "must": [
        {
            "status": "IN_PROGRESS"
        },
        {
          "range": {
            "requestDate": {
              "gte": "2018-10-01T08:00:00.000Z",
            }
          }
        }
      ]
    }
  },
  "sort": {
    "requestDate": {
      "order": "desc"
    }
  }
}

Answer 1

错误是您尚未针对状态字段指定查询类型-术语或匹配。因此，如果status是文本数据类型，则应执行匹配查询:

{
  "_source": {
    "includes": []
  },
  "query": {
    "bool": {
      "must": [
        {
          "match":{            "status": "IN_PROGRESS"
        }},
        {
          "range": {
            "requestDate": {
              "gte": "2018-10-01T08:00:00.000Z",
            }
          }
        }
      ]
    }
  },
  "sort": {
    "requestDate": {
      "order": "desc"
    }
  }

}