In 7.x-3.5 views, this may not be possible using the user interface.
Suppose 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
following in 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 an earlier version of the views, the AND / OR parameter of the context filter will be determined by the parameter 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.
source share