{ "_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 }