Jul 12, 2019 6:21 PM
We are building a resource locator. The user can filter on services provided and we'd like them to be able to order the results by distance from a searched address. The filters work, the geolocation works* (the build that is not yet pushed to the url above), and the orderBy distance is not.
This is the query in the code:
And according to hsDebug=true* this is how the query is sent:
What am I missing that is causing the orderBy to not work?
**Thank you to @mcoley for the hsDebug=true tip. That extension is a lifesaver!
Solved! Go to Solution.
Jul 15, 2019 10:56 AM
Thanks @stefen -- removing the mi doesn't change the ordering of the returned rows. Sort of related, when I remove the additional filters, and try to sort everything, I get this error:
Does that mean there's an error with my location column? There are no blanks in the column and the lat, lon is properly formed (ie no missing commas, valid data).