How can we help you today?
Query Bug in Backend?
2 CommentsSorted by Oldest First
Also, an ascending sort does work properly. It is only a descending sort with the geolocation query that fails.
/appdata/kid_VTn1d7yTmi/event/?query={"_geoloc":{"$nearSphere":[41.004107798550741,-79.806257851328539],"$maxDistance":100.0}}&resolve_depth=1&sort=attendees&skip=0
/appdata/kid_VTn1d7yTmi/event/?query={"_geoloc":{"$nearSphere":[41.004107798550741,-79.806257851328539],"$maxDistance":100.0}}&resolve_depth=1&sort=attendees&skip=0
Gal
said
almost 5 years ago
Hi, the issue is that when you specify the descending sort parameter, you are using single quotes to delimit your field, which is not valid JSON. If you instead use double quotes, your query will work as expected.
Joel Reed
/appdata/kid_VTn1d7yTmi/event/?query={"_geoloc":{"$nearSphere":[41.004107798550741,-79.806257851328539],"$maxDistance":100.0}}&resolve_depth=1&sort={'attendees' : -1 }&skip=0
Whereas this query does:
/appdata/kid_VTn1d7yTmi/event/?query={"_geoloc":{"$nearSphere":[41.004107798550741,-79.806257851328539],"$maxDistance":100.0}}&resolve_depth=1&sort=attendees&skip=0
As does this query:
/appdata/kid_VTn1d7yTmi/event/?resolve_depth=1&sort={'attendees' : -1 }&skip=0
Could that be a kinvey/mongodb bug or am I missing something here?
jr