Seeking Negation of Range in int64 Array Query
TLDR Akashchellakumar asked how to find the negation of a range in an int64 array. Kishore Nallan responded that there is currently no method available.
Oct 14, 2022 (14 months ago)
We have an int64 array named rental_date_int, we are applying filter_by=rental_date_int:=[1665819798..1666251798].
The filter mentioned above query works fine. But what we need is to find the negation of the range. Is there any way ?
Kishore Nallan05:17 AM
Indexed 3015 threads (79% resolved)
Negation Support in int64 Array Value
Akashchellakumar asked about negation in int64 array value. Jason suggested using a negative sign but Kishore Nallan confirmed negation isn't supported for numbers yet.
Filtering Int64 Array with "not in" Function
Maxi asked how to filter an int64 array with "not in." Jason suggested using `field:!=[1,2,3]`.
Issues with Array Filtering in Numeric Fields
Robert couldn't use negation operator for integer array filtering. Kishore Nallan clarified it only works on strings and booleans.