function emfield_views_handler_filter_is_not_null in Embedded Media Field 6.2

Same name and namespace in other branches

1. 5 emfield.module \emfield_views_handler_filter_is_not_null()
2. 6.3 deprecated/emfield-deprecated.inc \emfield_views_handler_filter_is_not_null()
3. 6 emfield.module \emfield_views_handler_filter_is_not_null()

Custom filter for provider NOT NULL.

File

./emfield.module, line 655

Embedded Media Field is a CCK-based framework for 3rd party media files.

Code

function emfield_views_handler_filter_is_not_null($op, $filter, $filterinfo, &$query) {
  if ($op == 'handler') {
    $query
      ->ensure_table($filterinfo['table']);
    if ($filter['value']) {
      $qs = "%s.%s <> '' AND %s.%s IS NOT NULL";
    }
    else {
      $qs = "%s.%s = '' OR %s.%s IS NULL";
    }
    $query
      ->add_where($qs, $filterinfo['table'], $filterinfo['content_db_info']['columns']['provider']['column'], $filterinfo['table'], $filterinfo['content_db_info']['columns']['provider']['column']);
  }
}