I have 2,557,378 records in my index. i am trying to apply few conditions with numericFilters
I need to select all values as below
- A = numberOfEmployeesMin
- B = totalFundingAmount
- C = mentions
I used Filter condition as below:
{
"numericFilters": [
"mentions>0 OR numberOfEmployeesMin > 50 OR totalFundingAmount >0"
]
}
But the or condition not work fine. it return results like mentions>0 AND numberOfEmployeesMin > 50 AND totalFundingAmount >0
How can i solve this?