[Resolved] Order View by Distance

[Author]

Posts

[umbertoZ]

Hi, I want to build a view with a map, serch filter by distance and then I want to display the result ordered by distance (the closest location first).

Is this possible?

I read this thread:
https://toolset.com/forums/topic/displaying-and-order-by-distance/
and this doc:
https://toolset.com/course-lesson/filtering-and-ordering-map-markers-by-distance/

But it is not clear. I don't understand if the view is supposed to order it by distance by default or not.

I built a test view and it doesn't seem to order the locations correctly.

Can you help me?

cheers

[Nigel]

It should work, and mostly does, though we have had a couple of clients reporting that it doesn't.

In those cases we've narrowed the problem down to the SQL query that calculates the distance returning null (instead of the distance), but haven't determined precisely what circumstances are required for it to fail.

Can I get access to your site to be able to see if the same is happening in your case? If so it will give us a little more ammo to throw at the problem.

Let me mark your next reply as private so that we can get log-in credentials from you—you may want to create a temporary admin user for us to use that you can later delete. And be sure to have a current backup of your site.

Can you also confirm the url of where you have this set up?

[Nigel]

Actually, I think the issue here is much more basic.

I hadn't noticed before now, but you cannot order the results by distance when using blocks to create the View, the option is only available in the legacy editor (screenshot).

And even in the legacy editor, the distance option is missing if you try to add front-end sorting controls.

The documentation you linked to ("Filtering and Ordering Map Markers by Distance in WordPress") makes no mention of how to order by distance.

I'm creating internal tickets to add the missing option to Blocks, and to update the documentation.

In the meantime you will have to create a View using the legacy editor to be able to order by distance.

(You can create the View in the legacy editor but still insert it into a blocks-based page with the View block, and add the map using the Map block, with the marker source set to the new legacy View.)

[umbertoZ]

My issue is resolved now. Thank you!