Filter on nested object to return all fields under nested object with value zero

Elastic Stack Elasticsearch
1

I need to filter on an index that have nested object called params, this object contains dynamic fields how to return only docs that contain fields with zero value under params nesetd object
Ex:
"params": {
"ePwrV":[
28.183
],
"di16":[
1
],
"rssi1":[
55
],
"di15":[
0
],
"di14":[
0
],
"di13":[
0
],
"di12":[
0
],
"di11":[
0
],
"di10":[
0
],
"di2":[
0
],
"di1":[
1
],
"ai4":[
733
],
"di4":[
0
],
"di3":[
0
],
"di6":[
0
],
"di5":[
1
],
"lac1":[
3718
],
"di8":[
1
],
"protocol":[
"bce"
],
"di7":[
1
],
"di9":[
0
],
"iPwrV":[
4.121
],
"cid1":[
39572
],
"odometer":[
1116211952
],
"spd":[
45
],
"sat":[
12
],
"ta":[
0
],
"hdop":[
1
],
"mcc1":[
420
],
"protocol.keyword":[
"bce"
],
"mnc1":[
3
]
}
Note: This fields is dynamic as some records may have other fields.

2

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.