The nearSphere function is working, after I renamed the column to "Location" !!!
Now I am just asking of what is the correct "where" syntax for the below
which I will construct dynamically
If I put the below in the "where" in the Test tab, of the Query Service
================================
{"Location": {"$nearSphere": [23.791376,38.002788], "$maxDistanceInKilometers": 0.5}}
================================
It retuns one record which is correct
and if i put this
================================
{"$or": [{"Type": "Food"},{"Type": "Dance"}]} and {"Location": {"$nearSphere": [23.791376,38.002788], "$maxDistanceInKilometers": 0.5}}
================================
returns 3 records, which is not correct. It returns all Food or Dance Type regardless of distance.
So the "where" clause is not correct.
I want to achieve to return only all of the type Food OR Dance, that are in 0.5 Km radius.
Thanks.