Invalid where clause error

[Ayaz_Khan]

Hi @Andriy_Konoz ,

I have done this distance(…) in the old code and it was working fine but suddenly API give me the error that invalid where clause.
https://backendless.com/docs/js/data_search_by_distance.html

then I have read some topics regarding this topic and I got this topic.

How can I sort of geoPoint by distance?

Hello, Yes, you should recreate a new column. To return data in “closest to furthest” please use this query in request: query.whereClause = "distanceOnSphere(location,'POINT(-96.77 32.79)')<=1000'"; query.addProperties( "distanceOnSphere(location,'POINT(-96.77 32.79)') as dist" ); query.setSortBy( "dist" ); Regards, Olha

Then I have changed my code according to new backendless changes can you please suggest to me how can I pass spatial type latitude and longitude column names in distanceOnSphere(…)?

Here is the table columns:-