Drupal 7 Views contextual filters OR logic

Question

Contextual filters are applied in AND logic. Is there any way to have two or more contextual filters in OR logic?

Answer 1

In views 7.x-3.5 this may not be possible using the UI.

Assume your module name is my_module

Add the following to your my_module.module file

<?php
function my_moudle_views_api() {
  return array(
    'api' => 3,
  );
}
?>

and

the following to my_module.views.inc

<?php
function eb_mine_views_query_alter(&$view, &$query) {
  if ($view->name == 'statuser') {
    dsm($query, 'before');
    $query->where[0]['type'] = 'OR';
    dsm($query, 'after');
  }
}
?>

Source : http://drupal.org/node/1451218#comment-6136692

Whereas in the earlier version of views, the AND/OR option of the contextual filter would be decided by that of the first group of static filters in the view.

Grouping of contextual filters
Even though contextual filters do not appear in the "and/or" user interface for sorting and grouping regular filters, contextual filters are always added to the first group of filters. Thus the order of the groups can cause the contextual filter to have entirely different effects on the results of a view that has contextual filters. Even though differences might not be apparent through the user interface.

Multiple contextual filters are therefore always in the same "and/or" group of filters, and can not be placed in different groups. There is an effort to add this feature.