I am trying to: Ultimately, I'm trying to display the location closest to another location (through a URL parameter). I'm trying to achieve this by returning the first location from a view, ordered by distance from a URL parameter. It is working for some locations, but for others, the ordering is incorrect.
Link to a page where the issue can be seen: I have setup a private page on my server where I'm trying to debug this at [private]
I expected to see: A list of locations with ascending distance values.
Instead, I got: A list of locations with distances out of order.
I had to remove my original screenshot and URL -- I didn't realize this thread would be visible to the world. Please email me and I'll respond with sensitive info.
Hi, URLs you share in the forum are always obscured from other Users. Only you and the support team here can see them, for privacy. I'll be glad to take a look if you let me know where I can find the View with distance filter.
Have you tried these troubleshooting steps?
- Temporarily deactivate all plugins except Types, Views and Maps, and activate a default theme like Twenty Twenty
- Test again. If you need to place the View on another page for testing, that's fine
- If the problem is solved, reactivate the other plugins and your theme one by one until the problem returns
Let me know what you find out and please share a URL for the test View.
I have disabled all plugins except for views, types and maps. I have also switched to twenty twenty.
hidden link
You will see the URL includes a parameter for location. The location is one of the addresses in the list; so you would assume it would be the first location listed. I have included a column which shows the distance from the URL parameter. As you can see, the list is not ordered properly.
I've requested permission to access the Duplicator package on Drive. I'd like to do a bit more investigation there because I don't see anything obviously wrong here. Please open up access there so I can take a closer look.
I just discovered the map addresses are cached. I blasted every row in wp_toolset_maps_address_cache, then went through each location and re-saved the address info to re-prime the cache, now everything is sorting the way it's supposed to.
Okay interesting, I tried clearing cache on a few of the addresses but not all. It didn't seem to make a difference. So if clearing the cache has solved the problem, I think we can consider this one closed. Feel free to resolve here or let me know if the problem resurfaces.
