I have a bunch of "training courses" that reference a "centre" content type that has the location information.
The GMap style is set to get the longitude and latitude from the centre type, via the relationship. However as there may be multiple courses at a single centre, I only want to show each centre once. the DISTINCT view option is no good, as that would choose a distinct "course". The ability to have distinct location results would be very useful. Any ideas how to accomplish this ?

Comments

functions’s picture

functions commented

Are you using the views module? I am also trying to create a view that only shows each location (city or province) once within the query results. Please post back here if you find a solution, and I'll do the same.

exobuzz’s picture

exobuzz commented

Yes. I am using views. I don't know of any solution without using own SQL or modifying the views parts of the location module to incorporate this.

amedee-1’s picture

amedee-1 commented

I suggest using a marker manager like Clusterer or ClusterMarker.
See http://drupal.org/node/530328#comment-1919830 for a comparison.
It doesn't work for me because I *do* want to see multople nodes on the same location, but as it is currently, it would be exactly what you need.
If my feature request gets fixed, it should become optional so that it still works for you.

exobuzz’s picture

exobuzz commented

Thanks for the reply. We already useClusterMarker, but that didn't help me only show a location once. Also the problem is we show a list of results in addition to the map, so we need to solve it at the sql level really. (It isnt actually a ongoing issue now as I am no longer presenting the data in the same way but it was an issue at the time).

johnv’s picture

johnv
Primary language Dutch
commented
Status: Active » Closed (won't fix)

Closing this very old issue. Please reopen if it is still valid.