How to get filtered and sorted by a distance data from a data table
I'm trying to get filtered and sorted by a distance data from my data table. I'm using REST API.
Following this thread http://support.backendless.com/topic/search-data-by-distance-from-a-location-not-working I've managed to get geo points with related objects which are sorted by distance - every geo point in my category has related list of objects and I'm requesting geo points with includemetedata=true parameter. Now I want to be able to add a where clause so I can filter search results by some properties which that related objects have.
A GeoPoint has a related list of objects of type Shop. Every Shop object has it's opening hours - timeOpen (int) and timeClose (int). I want to find all Shop objects which have timeOpen < 9.
How this can be done using REST API?
Thank you in advance.