So I ended up having to do a lot of filtering on the JOIN & WHERE statements instead of using just the $args array.
This reply has been marked as private.
While that makes perfect sense, it works if I am only doing a zipcode search. Unfortunately my search is actually using multiple custom fields beyond just zipcode (and thus which location IDs). Users can do a search for a Dentist in a zipcode, so I also have to match a custom field where a doctor has that specialty assigned to them as well. In doing so, I have to make “relation” an “AND” statement, your code requires it be an “OR” statement.
Looks like I will have to do a completely custom SQL statement for this.
I have custom post types for each doctor and each office. I have a field group assigned to doctors that lets you choose which locations they work at using a Relationship field.
How would using the repeater with I assume a single Relationship field be any different than just allowing multiple relationships in terms of making the query better?
