elasticsearch - 根据数组计数过滤弹性数据

Question

我们如何从下面的索引数据中获取至少具有一个电话号码的候选人以及其他条件(如必须和应当)？
使用 flex 版本6. *

        {
            "_index": "test",
            "_type": "docs",
            "_id": "1271",
            "_score": 1.518617,
            "_source": {
                "record": {
                    "createdDate": "2020-10-16T10:49:51.53",
                    "phoneNumbers": [
                        {
                            "type": "Cell",
                            "id": 0,
                            "countryCode": "+1",
                            "phoneNumber": "7845200448",
                            "extension": "",
                            "typeId": 700
                        }
                    ]
                },
                "entityType": "Candidate",                   
                "dbId": "1271",
                "id": "1271"
            }
        }

Answer 1

您可以为此使用exists查询，如下所示，与脚本相比，这是一种轻量级查询:

{
  "query": {
      "exists": {
        "field": "record.phoneNumbers.phoneNumber"
      }
  }
}