es nested嵌套查询

{
  "_source": [
    "DATE",
    "NEWS_ID",
    "COMPSCORELIST"
  ],
  "query": {
    "bool": {
      "must": [
        {
          "range": {
            "DATE": {
              "from": "2021-09-25T00:00:00+08:00",
              "include_lower": true,
              "include_upper": true,
              "to": "2021-09-25T23:59:59+08:00"
            }
          }
        },
        {
          "nested": {
            "path": "COMPSCORELIST",
            "query": {
              "bool": {
                "must": {
                  "exists": {
                    "field": "COMPSCORELIST"
                  }
                }
              }
            }
          }
        }
      ]
    }
  },
  "sort": {
    "DATE": "desc"
  },
  "size": 100
}