Negative Value Query/Search
For querying integer values, how do we search/query negative values ?
-u Upper boundary. For example, tcp.port = 40000-u selects all TCP ports above 40000.
l- Lower boundary. For example, tcp.port = l-40000 selects all TCP ports below 40000.
Documented here: https://community.rsa.com/docs/DOC-74675
Example below, this query searches, values from 0 > 1. But nothing below, I need to search values that are negative.
I didn't have any data in a Float64 formatted meta key, but I did have the latitude and longitude keys formatted as Float32. I think they should act the same, but didn't have any actual data to compare. I indexed those keys in my lab and had some negative values in "longdec.dst".
First I issued a query 'longdec.dst < 100'. This query returned no data. Then, I recalled that this makes sense because float32 had decimal points.
Once I changed my query to 'longdec.dst < 100.0', data was returned.
Now, lets try it with a negative. I issued another query 'longdec < -100.0' and also received data.
In conclusion, you may just need to add the decimal point to your query. To query negatives, just include the ( - ) sign with the number value in decimal format. Again..this was against float32, but I suspect it would be the same for float64.