Filtering with negative values
We have a facet that contains numeric values (both positive and negative).
Our struggle is, say we have the following facet values, 65, 100, -65, -85 etc.
If we filter by -65, even the positive 65 value gets returned, which is not desired. What we want is only the filtered value i.e -65 to show up.
We noticed that the field is being indexed as a String type in Coveo. Has that something to do with the filtering behavior?
What is the recommended practice/solution in these cases?
If the field is string inside Coveo, "-65" is indexed as " 65" (space 65) and is the same as positive "65". It is then normal that your filters are behaving like this.
You must find out why the field is created as string inside Coveo and fix this.