filter view by multiple cck text fields with AND operator

and here is the problem - filters for cck text fields have only "Is one of" and "Is none of" operators. And I need "Is all of" operator

Please file a bug. This feature is a must-have.

But not yet. Let's first try to prepare a patch. Open 'text.module' and change:

'operator' => 'views_handler_operator_or',

to:

'operator' => 'views_handler_operator_andor',

And clear the cache. (Views caches these definitions so we must clear the cache.)

You should now see an "Is All Of" operator too. Please test it extensively, and if it works include this info in your bug report.

(BTW, I wonder if the 'CCK taxonomy' module has this 'Is All Of' feature.)

(BTW#2, remember to include the 'Node: Distinct' filter because you don't want duplicate nodes when using the 'Is One Of' (OR) operator.)

is there any hope to make this filter not an multiple values list, but as a group of checkboxes?

I wouldn't be surprised is somebody has already written a module that converts multi-selects to checkboxes. If not, create a module and implement hook_form_alter:

function mymodule_form_alter($form_id, &$form) {
  if ($form_id == 'views_filters') {
    if ($form['#view_name'] == 'restaurants' /* put your view name here */ ) {
      // it might be 'filter1' or 'filter2' in your case
      $form['filter0']['#type'] = 'checkboxes';
    }
  }
}

We need to get rid of the first checkbox ('All'), but I don't have time right now, have to go....