Need advice on complex views sorting

We encourage users to post events happening in the community to the community events group on https://www.drupal.org.
pglatz's picture

I have a gmap/location view that creates a map and a list of results in a table, displaying details of nodes of a custom content type. There are three exposed filters for zip code (location), and two taxonomy fields. Right now it works fine for finding locations, but if I add a taxonomy term, only fields that exactly match the location and terms are displayed.

What I'd like to have is a fuzzier search, ordered by closest matches. The first taxo term would be the primary field, followed by location and the second taxo term.

If only one or two fields are exact matches, I want to indicate so in the table, and if no fields match, the row would not be displayed.

I believe this is going to require a query alter to change the ordering, and some way of knowing how close each result matches. If this is something you have done before, I'd appreciate any suggestions or guidance. I have a moderate budget for this and would be glad to compensate you for help with a solution.

SF Bay Area

Group categories

Resources

user group

Group notifications

This group offers an RSS feed. Or subscribe to these personalized, sitewide feeds:

Hot content this week