function filefield_views_handler_filter_is_not_null in FileField 5.2

Custom filter for filefield NOT NULL

1 string reference to 'filefield_views_handler_filter_is_not_null'

filefield_field_settings in ./filefield.module

Implementation of hook_field_settings().

File

./filefield.module, line 946

Defines a file field type.

Code

function filefield_views_handler_filter_is_not_null($op, $filter, $filterinfo, &$query) {
  if ($op == 'handler') {
    $query
      ->ensure_table($filterinfo['table']);
    if ($filter['value']) {
      $qs = '%s.%s > 0';
    }
    else {
      $qs = '%s.%s = 0 OR %s.%s IS NULL';
    }
    $query
      ->add_where($qs, $filterinfo['table'], $filterinfo['field'], $filterinfo['table'], $filterinfo['field']);
  }
}