syntax of data query mixing geolocation and other conditions

Not applicable

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 Solved
0 3 317
1 ACCEPTED SOLUTION

Not applicable

Geolocations are accurate only to the meter, so it appears that it would round to the nearest whole number before returning any results.

View solution in original post

3 REPLIES 3

Not applicable

I haven't tried this, but posibly select * where <data-attribute> >= 10 and location within of <dist> of <lat>,<lon> will work.

Not applicable

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" ?

Not applicable

Geolocations are accurate only to the meter, so it appears that it would round to the nearest whole number before returning any results.