Hi everyone, I have a question about filter script for array in ES
I have documents or schema like this:
{
"name": "linh",
"array": [
{
"ts": 1,
"val": 200
},
{
"ts": 2,
"val": 300
},
{
"ts": 3,
"val": 100
}
]}
I want to query documents which have elements in array with ts field > [ts_threshold] and sum of val of these elements > [val_threshold]