I just upgraded both Date and Views and not my date filter no longer work. The Live Preview query out shows the where clause doesn't have the date filter in it:

SELECT node.nid AS nid,
   node.title AS node_title,
   node_data_field_event_date.field_event_date_value AS node_data_field_event_date_field_event_date_value,
   node_data_field_event_date.field_event_date_value2 AS node_data_field_event_date_field_event_date_value2,
   node.type AS node_type,
   node.vid AS node_vid
 FROM node node 
 INNER JOIN users users ON node.uid = users.uid
 LEFT JOIN content_type_event node_data_field_event_date ON node.vid = node_data_field_event_date.vid
 WHERE node.type in ('event')
   ORDER BY node_data_field_event_date_field_event_date_value ASC

I deleted the filter and added it again and still the query came out the same.

Comments

merlinofchaos’s picture

Project: Views (for Drupal 7) » Date
Version: 6.x-2.4 » 6.x-2.x-dev

Problematic, but if it's a date filter you need to file this against date.module and then KarenS can pull her hair out wondering what I broke. =)

chromeyellow’s picture

I believe that this issue does not exist in 6.x-2.x-dev as of the April 2 snapshot. However, it *does* seem to be a problem in 6.x-2.1 (and duplicates http://drupal.org/node/426990 - same op's original date.module report). So when this got bounced back from views.module it became a dupe, with wrong version.

Mark this as dupe and stick to http://drupal.org/node/426990?

jpetso’s picture