I cannot manage to make a javascript query on custom data mixing geolocation and other conditions.
1. this query work : select * where location within of <dist> of <lat>,<lon>
2. but this more complex query does NOT work :
select * where <data-attribute> gte 10 and location within of <dist> of <lat>,<lon>
So my question is what is the syntax of the data query ?
Solved! Go to Solution.
Geolocations are accurate only to the meter, so it appears that it would round to the nearest whole number before returning any results.
I haven't tried this, but posibly select * where <data-attribute> >= 10 and location within of <dist> of <lat>,<lon> will work.
your answer make me think to make some test with float and integer values, and it appears that :
when <data-attribute> is a float, gte does not work well, only >= works better, except than only the digit before the . is taken into account.
So 1.2 is interpreted as 1.0
Is it the "normal behavior" ?
Geolocations are accurate only to the meter, so it appears that it would round to the nearest whole number before returning any results.