Multi Range filter for number not working

Elastic Stack Elasticsearch
1

Hi All,

I am using elastic search version 1.4.2.
I am applying range filter which works fine for one range.
"filters" : [ {
"and" : {
"filters" : [ {
"range" : {
"age" : {
"from" : 24.0,
"to" : 36.0,
"include_lower" : true,
"include_upper" : false
}
}
} ]

But when I apply filter for multiple ranges, it does not work. I get wrong results.
"filters" : [ {
"and" : {
"filters" : [ {
"and" : {
"filters" : [ {
"range" : {
"age" : {
"from" : 24.0,
"to" : 36.0,
"include_lower" : true,
"include_upper" : false
}
}
}, {
"range" : {
"age" : {
"from" : 36.0,
"to" : 50.0,
"include_lower" : true,
"include_upper" : false
}
}
} ]
}
} ]
}
} ]

Thanks
Shalini

2

My bad, I should have applied or filter instead of and filter.:grinning: