this used to work perfectly, i really dont know what changed that it doesnt work anymore.
this is the where caluse of the REST API request:
{"category":{"$in":["glasses","books","electronics","fashion"]}, "company":{"$in":["dr.staff","magnet"]},"location": {"$nearSphere": {"__type": "GeoPoint","latitude": 32.066157,"longitude": 34.777821},"$maxDistanceInKilometers": 500}}
it will return only the records that matches the given category, company and in the given distance of 500 KM.
the location column in the REST DB is of type geolocation. the data of the location rows matches my current location (for debugging) so it should come up.
if i ommit the location column i get a full results set response.
if i try to use the location part, empty results set.
how can i debug it and understand what's wrong?
Thanks
Adi