我是OData服务的新手,我编写了一个查询来检索具有空值的特定字段。我在OData中构建了查询,然后将其传递给弹性搜索以检索数据。但是查询似乎无法正常工作。
The query is as follows:
$filter=assignedToEM eq null.
I have also tried giving as: $filter=assignedToEM eq 'null'
The query has been built as :
{
"from" : 0,
"size" : 15,
"query":{
"bool" : {
"must_not" : {
"term" : {
"assignedToEM" : "null"
}
}
}
}
}
In elastic search schema,The not_null value for assignedToEM is given as "_null_".
It would be really helpful if i get a solution for this as soon as possible.
Thanks.
实现此目的的一种方法是改为使用特殊字段名称创建query_string
查询_missing_
,如下所示:
{
"from": 0,
"size": 15,
"query": {
"query_string": {
"query": "_missing_:assignedToEM"
}
}
}
或者也应该使用NOT
像这样的运算符:
{
"from": 0,
"size": 15,
"query": {
"query_string": {
"query": "NOT(assignedToEM:*)"
}
}
}
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句