Any help would be very much appreciated please.
I have a content type named restaurant and I have three taxonomy term fields (cuisines, neighborhoods and occasions) in it. I've created a view to expose these 3 fields as checkboxes for users to search restaurants accordingly.
Cuisines and Neighborhoods are required fields in the node, but not occasions. The problem is that if there is a restaurant that has not been tagged with an occasion, that restaurant will not show in the search results because in my filter criteria, I've selected "is one of" > all the terms in occasions.
I need help to turn this occasion filter as an optional one, where a node that has not been tagged with an occasion will appear when the user select a cuisine or neighborhood where this node is listed in.
I believe that this can be done via hook_views_query_alter but I don't know how.