I'm working with a view with exposed filters for a directory style page.

One of the filters is a multi-select check list, however, we want the results to return AND results only. It is currently returning OR.

For example: Activity open to: - Men - Women - Older People - Children

So I only want to see results that have both selected.

All the testing I've done returns OR options, so they can have Men OR Women. I want Men AND Women returned.

2 Answers 2


Views' filters default to an OR between all the options selected. If you pick the "Is all of" option, it will change to an AND operator.

enter image description here


You can modify the query as you like before executing it using hook_views_query_alter.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.