According to the documentation here: https://solspace.com/docs/super_search/search_syntax/#custom_fields
I should be able to pass values from multiple custom fields into my search query. For example, I want to pass the following:
These custom fields are relationship fields, where I'm trying to filter on the exact title of each relationship. So, I have a service named "Surgery" and a location named "My Medical Center". Trying each one of these individually works - I get the expected results.
Both of these queries work:
But in combination, it does not work. Any help on this would be great!
I'm using SuperSearch 2.2.3 and EE 2.10.1. I'm trying to pass two values in the search string - these are the only two search criteria I'm passing - there are no keywords or any other parameters.
This search string is intended to find all doctors with a relationship to a "Generic Hospital Name". It works correctly - the search results show only doctors with a relationship to "Generic Hospital Name":
This search string is intended to find all doctors with a relationship to "Primary Care". It works correctly - the search results show only doctors with a relationship to "Primary Care":
I need to combine these in the event that someone needs to find a doctor specializing in "Primary Care" at "Generic Hospital Name". So, this is my search string for that:
This does not work. I get ALL doctors who work at "Generic Hospital Name", however, they are NOT ALL "Primary Care" doctors.
If I remove exact on doctors_services like this:
The results for this returns a mixed bag of doctors. The -exact on doctors_locations doesn't limit the doctors from "Generic Hospital Name" nor does it return accurate results for doctors_services. I'd expect to see doctors with services that include the words "Primary" or "Care", but the first doctor in the list specializes in "Lung Transplants" and "Abdominal Surgery".
If I remove -exact from doctors_locations like this:
I also get a mixed bag of the results that does not seem to obey either doctors_services or doctors_locations.
Removing exact from both doctors_services and doctors_locations does not produce a comprehensible list of search results either.
So I can pass -exact on doctors_locations OR doctors_services just as long as they do not exist in the same query. doctors_locations-exact works by itself, doctors_services-exact works by itself, but not together.