I have a view that has filters exposed which searches and returns the results for a content type.
I have some entity reference fields (content, taxonomy) that when a user selects multiple values, I want them to be AND and limit the result set. It seems that Views does
IN () no matter what configuration I've set for the filter, which expands the result set as you select more, instead of reducing them to the results that match exactly / only to what has been selected.
For example, if I have an exposed filter for
field nodes and the user ticks 1, 2, 3 and submits, I only want nodes that have 1, 2, and 3 in the values of this reference field. No node that corresponds to one of the values.