Views filter for no date stopped working [#2250221]

I have a view that filters based on a date field. It's set to show content if the date field is later than now or if it is empty. It worked under 2.6; under 2.7, content does not show when the date field is empty. I reverted back to 2.6 and it's working again.
Comments

Comment #1

webby7097 CreditAttribution: webby7097 commented 23 May 2014 at 13:58
Drupal 7.27
Views 7.x-3.7
Date 7.x-2.7
View export (I see the issue in the Block display):
$view = new view();
$view->name = 'alerts';
$view->description = 'Front page view of active alerts.';
$view->tag = 'default';
$view->base_table = 'node';
$view->human_name = 'Alerts';
$view->core = 7;
$view->api_version = '3.0';
$view->disabled = FALSE; /* Edit this to true to make a default view disabled initially */

/* Display: Master */
$handler = $view->new_display('default', 'Master', 'default');
$handler->display->display_options['title'] = 'Alerts';
$handler->display->display_options['use_more'] = TRUE;
$handler->display->display_options['use_more_always'] = FALSE;
$handler->display->display_options['access']['type'] = 'perm';
$handler->display->display_options['cache']['type'] = 'none';
$handler->display->display_options['query']['type'] = 'views_query';
$handler->display->display_options['exposed_form']['type'] = 'basic';
$handler->display->display_options['pager']['type'] = 'some';
$handler->display->display_options['pager']['options']['items_per_page'] = '5';
$handler->display->display_options['pager']['options']['offset'] = '0';
$handler->display->display_options['style_plugin'] = 'default';
$handler->display->display_options['row_plugin'] = 'fields';
$handler->display->display_options['row_options']['inline'] = array(
  'field_alert_start' => 'field_alert_start',
  'field_alert_location' => 'field_alert_location',
);
$handler->display->display_options['row_options']['separator'] = ' | ';
$handler->display->display_options['row_options']['hide_empty'] = TRUE;
/* Header: Global: Text area */
$handler->display->display_options['header']['area']['id'] = 'area';
$handler->display->display_options['header']['area']['table'] = 'views';
$handler->display->display_options['header']['area']['field'] = 'area';
$handler->display->display_options['header']['area']['content'] = '<h1>Alerts</h1>';
$handler->display->display_options['header']['area']['format'] = 'filtered_html';
/* No results behavior: Global: Unfiltered text */
$handler->display->display_options['empty']['area_text_custom']['id'] = 'area_text_custom';
$handler->display->display_options['empty']['area_text_custom']['table'] = 'views';
$handler->display->display_options['empty']['area_text_custom']['field'] = 'area_text_custom';
$handler->display->display_options['empty']['area_text_custom']['label'] = 'No Alerts Text';
$handler->display->display_options['empty']['area_text_custom']['empty'] = TRUE;
$handler->display->display_options['empty']['area_text_custom']['content'] = 'There are no active alerts.';
/* Field: Content: Title */
$handler->display->display_options['fields']['title']['id'] = 'title';
$handler->display->display_options['fields']['title']['table'] = 'node';
$handler->display->display_options['fields']['title']['field'] = 'title';
$handler->display->display_options['fields']['title']['label'] = '';
$handler->display->display_options['fields']['title']['alter']['path'] = 'alerts';
$handler->display->display_options['fields']['title']['alter']['word_boundary'] = FALSE;
$handler->display->display_options['fields']['title']['alter']['ellipsis'] = FALSE;
$handler->display->display_options['fields']['title']['element_type'] = 'strong';
$handler->display->display_options['fields']['title']['element_class'] = 'alert_title';
$handler->display->display_options['fields']['title']['element_label_colon'] = FALSE;
$handler->display->display_options['fields']['title']['hide_empty'] = TRUE;
$handler->display->display_options['fields']['title']['hide_alter_empty'] = FALSE;
/* Field: Content: Alert Date */
$handler->display->display_options['fields']['field_alert_start']['id'] = 'field_alert_start';
$handler->display->display_options['fields']['field_alert_start']['table'] = 'field_data_field_alert_start';
$handler->display->display_options['fields']['field_alert_start']['field'] = 'field_alert_start';
$handler->display->display_options['fields']['field_alert_start']['label'] = '';
$handler->display->display_options['fields']['field_alert_start']['element_label_colon'] = FALSE;
$handler->display->display_options['fields']['field_alert_start']['settings'] = array(
  'format_type' => 'long',
  'fromto' => 'value',
  'multiple_number' => '',
  'multiple_from' => '',
  'multiple_to' => '',
  'show_repeat_rule' => 'show',
);
/* Field: Content: Location */
$handler->display->display_options['fields']['field_alert_location']['id'] = 'field_alert_location';
$handler->display->display_options['fields']['field_alert_location']['table'] = 'field_data_field_alert_location';
$handler->display->display_options['fields']['field_alert_location']['field'] = 'field_alert_location';
$handler->display->display_options['fields']['field_alert_location']['label'] = '';
$handler->display->display_options['fields']['field_alert_location']['element_label_colon'] = FALSE;
/* Sort criterion: Content: Alert Date -  start date (field_alert_start) */
$handler->display->display_options['sorts']['field_alert_start_value']['id'] = 'field_alert_start_value';
$handler->display->display_options['sorts']['field_alert_start_value']['table'] = 'field_data_field_alert_start';
$handler->display->display_options['sorts']['field_alert_start_value']['field'] = 'field_alert_start_value';
$handler->display->display_options['sorts']['field_alert_start_value']['order'] = 'DESC';
$handler->display->display_options['filter_groups']['groups'] = array(
  1 => 'AND',
  2 => 'OR',
);
/* Filter criterion: Content: Published */
$handler->display->display_options['filters']['status']['id'] = 'status';
$handler->display->display_options['filters']['status']['table'] = 'node';
$handler->display->display_options['filters']['status']['field'] = 'status';
$handler->display->display_options['filters']['status']['value'] = 1;
$handler->display->display_options['filters']['status']['group'] = 1;
$handler->display->display_options['filters']['status']['expose']['operator'] = FALSE;
/* Filter criterion: Content: Type */
$handler->display->display_options['filters']['type']['id'] = 'type';
$handler->display->display_options['filters']['type']['table'] = 'node';
$handler->display->display_options['filters']['type']['field'] = 'type';
$handler->display->display_options['filters']['type']['value'] = array(
  'alert' => 'alert',
);
$handler->display->display_options['filters']['type']['group'] = 1;
/* Filter criterion: Workflow: Current state */
$handler->display->display_options['filters']['sid']['id'] = 'sid';
$handler->display->display_options['filters']['sid']['table'] = 'workflow_node';
$handler->display->display_options['filters']['sid']['field'] = 'sid';
$handler->display->display_options['filters']['sid']['value'] = array(
  2 => '2',
);
$handler->display->display_options['filters']['sid']['group'] = 1;
/* Filter criterion: Content: Alert Date - end date (field_alert_start:value2) */
$handler->display->display_options['filters']['field_alert_start_value2_1']['id'] = 'field_alert_start_value2_1';
$handler->display->display_options['filters']['field_alert_start_value2_1']['table'] = 'field_data_field_alert_start';
$handler->display->display_options['filters']['field_alert_start_value2_1']['field'] = 'field_alert_start_value2';
$handler->display->display_options['filters']['field_alert_start_value2_1']['operator'] = 'empty';
$handler->display->display_options['filters']['field_alert_start_value2_1']['group'] = 2;
$handler->display->display_options['filters']['field_alert_start_value2_1']['year_range'] = '-0:+3';
/* Filter criterion: Content: Alert Date - end date (field_alert_start:value2) */
$handler->display->display_options['filters']['field_alert_start_value2']['id'] = 'field_alert_start_value2';
$handler->display->display_options['filters']['field_alert_start_value2']['table'] = 'field_data_field_alert_start';
$handler->display->display_options['filters']['field_alert_start_value2']['field'] = 'field_alert_start_value2';
$handler->display->display_options['filters']['field_alert_start_value2']['operator'] = '>';
$handler->display->display_options['filters']['field_alert_start_value2']['group'] = 2;
$handler->display->display_options['filters']['field_alert_start_value2']['granularity'] = 'minute';
$handler->display->display_options['filters']['field_alert_start_value2']['default_date'] = 'now';
$handler->display->display_options['filters']['field_alert_start_value2']['year_range'] = '-0:+3';

/* Display: Block */
$handler = $view->new_display('block', 'Block', 'block');
$handler->display->display_options['defaults']['header'] = FALSE;
$handler->display->display_options['defaults']['empty'] = FALSE;

/* Display: Page */
$handler = $view->new_display('page', 'Page', 'page_1');
$handler->display->display_options['defaults']['use_more'] = FALSE;
$handler->display->display_options['defaults']['use_more_always'] = FALSE;
$handler->display->display_options['defaults']['use_more_always'] = FALSE;
$handler->display->display_options['use_more_always'] = FALSE;
$handler->display->display_options['defaults']['use_more_text'] = FALSE;
$handler->display->display_options['defaults']['pager'] = FALSE;
$handler->display->display_options['pager']['type'] = 'full';
$handler->display->display_options['pager']['options']['items_per_page'] = '5';
$handler->display->display_options['pager']['options']['offset'] = '0';
$handler->display->display_options['pager']['options']['id'] = '0';
$handler->display->display_options['pager']['options']['quantity'] = '9';
$handler->display->display_options['defaults']['fields'] = FALSE;
/* Field: Content: Title */
$handler->display->display_options['fields']['title']['id'] = 'title';
$handler->display->display_options['fields']['title']['table'] = 'node';
$handler->display->display_options['fields']['title']['field'] = 'title';
$handler->display->display_options['fields']['title']['label'] = '';
$handler->display->display_options['fields']['title']['alter']['word_boundary'] = FALSE;
$handler->display->display_options['fields']['title']['alter']['ellipsis'] = FALSE;
$handler->display->display_options['fields']['title']['element_type'] = 'h4';
$handler->display->display_options['fields']['title']['element_label_colon'] = FALSE;
$handler->display->display_options['fields']['title']['hide_empty'] = TRUE;
$handler->display->display_options['fields']['title']['hide_alter_empty'] = FALSE;
$handler->display->display_options['fields']['title']['link_to_node'] = FALSE;
/* Field: Content: Alert Date */
$handler->display->display_options['fields']['field_alert_start']['id'] = 'field_alert_start';
$handler->display->display_options['fields']['field_alert_start']['table'] = 'field_data_field_alert_start';
$handler->display->display_options['fields']['field_alert_start']['field'] = 'field_alert_start';
$handler->display->display_options['fields']['field_alert_start']['label'] = '';
$handler->display->display_options['fields']['field_alert_start']['element_label_colon'] = FALSE;
$handler->display->display_options['fields']['field_alert_start']['settings'] = array(
  'format_type' => 'long',
  'fromto' => 'value',
  'multiple_number' => '',
  'multiple_from' => '',
  'multiple_to' => '',
  'show_repeat_rule' => 'show',
);
/* Field: Content: Body */
$handler->display->display_options['fields']['body']['id'] = 'body';
$handler->display->display_options['fields']['body']['table'] = 'field_data_body';
$handler->display->display_options['fields']['body']['field'] = 'body';
$handler->display->display_options['fields']['body']['label'] = '';
$handler->display->display_options['fields']['body']['element_label_colon'] = FALSE;
$handler->display->display_options['path'] = 'alerts';
Comment #2

webby7097 CreditAttribution: webby7097 commented 1 August 2014 at 13:48
I tested this with the update to 2.8 today; it also does not work if there is no end date.
Comment #3

webby7097 CreditAttribution: webby7097 commented 1 August 2014 at 18:21
In addition, on another view that uses end date +7 days, I'm now getting this: "The handler for this item is broken or missing and cannot be used. If a module provided the handler and was disabled, re-enabling the module may restore it. Otherwise, you should probably delete this item." Items in that view are no longer filtered by date.
Views filter for no date stopped working

Comments

Comment #1

Comment #2

Comment #3

Thank you to these Drupal contributors

News items

Our community

Documentation

Drupal code base

Governance of community
