I have a collection c with lat itude, lon gitude fields: c.lat, c.lon
How to get records closer to a given lat/lon: SELECT * FROM c ORDER BY: (c.lat-lat)+(c.lon-lon)
Either by wix-data-sql or by wix-data.query?
(the right distance would be obviously the adding sqrt(power)… but it’s to illustrate the point how to use the expressions)…
Or is there any other way how to list the closest points?
Thanks