There is a standard set of operators for simple field types:

Is Equal To
Contains
Contains Any Word
Contains All Words
Starts With
Ends With
Does Not Contain

But if you try to test for an empty field, there will be fail, because filter with empty value will be ignored. I think cause of it is the code in function views_handler_filter_like (module views.module):

 switch (trim($filter['value'])) {
    case (''):
      return;
      break;
}

(But I don't shure about it.)

I suppose that it would be better if:
1) to the standard set of operators will be added operator Is Empty;
or
2) will be removed a ban from empty filter's value.

Issue was rised here:
http://drupal.org/node/140180 ,
http://drupal.org/node/141055 .

Simple solution: Operator='Contains', value='_'. But it is now: a) not documented; b) not very user frendly and correct technically.
(as it seems to me).

Comments

sun’s picture

sun
Primary language German
Location Karlsruhe
commented
Status: Active » Closed (won't fix)

Sorry, unfortunately this request is way too specific. Please have a look at the issue queue - Views maintainers are buried already. You might want to try to get further support at http://drupal.org/support. Additionally, the answer to your question might be covered in the handbooks at http://drupal.org/handbook/modules/views already.
If you were able to solve this issue on your own in the meantime, you might want to add the involved steps to this closed issue, so other users searching for a similar solution might find it.