C# Elasticsearch空值查询 不是NULL

Question

查询出图片标记的2条为空的数据

Answer 1

可以使用TERM的全字查询
--造数据
POST /_bulk
{"index":{"_index":"testtest","_type":"testtype","_id":"1"}}
{"doctorNumber":"11341","doctorName":""}
{"index":{"_index":"testtest","_type":"testtype","_id":"2"}}
{"doctorNumber":"11342","doctorName":""}
{"index":{"_index":"testtest","_type":"testtype","_id":"3"}}
{"doctorNumber":"1","doctorName":"1234"}

--查询
GET testtest/testtype/_search
{
"query": {
"term": {
"doctorName.keyword": {
"value": ""
}
}
}
}

--结果
{
"took": 1,
"timed_out": false,
"_shards": {
"total": 5,
"successful": 5,
"skipped": 0,
"failed": 0
},
"hits": {
"total": 2,
"max_score": 0.2876821,
"hits": [
{
"_index": "testtest",
"_type": "testtype",
"_id": "2",
"_score": 0.2876821,
"_source": {
"doctorNumber": "11342",
"doctorName": ""
}
},
{
"_index": "testtest",
"_type": "testtype",
"_id": "1",
"_score": 0.2876821,
"_source": {
"doctorNumber": "11341",
"doctorName": ""
}
}
]
}
}