Already searched and read other threads regarding this issue. Trying to create a block with 6 upcoming events.

Did an upgrade to the latest -dev and still having problems. Tried changing granularity, less than or equal to, etc.

"Date: Date (node) Content: Date (field_date) - From date > now" does not work. Fields are not filtered...but displayed based on the updated date.

Exported view attached.

Ideas for fixing would be much appreciated.

CommentFileSizeAuthor
view.txt9.98 KBharper1983

Comments

Anonymous’s picture

Sorry, I used the wrong settings. Comment deleted.

joergvk’s picture

Priority: Normal » Critical

I experience exactly the same issue. This was working with an earlier version of date: a view of upcoming events filtered by a date field that has a from and to date. When I expose the filter and enter a date manually, everything works fine. This is the SQL generated:

SELECT node.nid AS nid,
   node.title AS node_title,
   node_data_field_termin.field_termin_value AS node_data_field_termin_field_termin_value,
   node_data_field_termin.field_termin_value2 AS node_data_field_termin_field_termin_value2,
   node.type AS node_type,
   node.vid AS node_vid
 FROM snh_node node 
 LEFT JOIN snh_content_field_termin node_data_field_termin ON node.vid = node_data_field_termin.vid
WHERE ((node.type in ('event')) AND (node.status <> 0) AND (node.language in ('***CURRENT_LANGUAGE***')))
    AND (DATE_FORMAT(node_data_field_termin.field_termin_value2, '%Y-%m-%d') <= '2009-10-06')
   ORDER BY node_data_field_termin_field_termin_value ASC

When I use "now" as a default, there is not even anything referring to the date in the SQL-Query where clause.

SELECT node.nid AS nid,
   node.title AS node_title,
   node_data_field_termin.field_termin_value AS node_data_field_termin_field_termin_value,
   node_data_field_termin.field_termin_value2 AS node_data_field_termin_field_termin_value2,
   node.type AS node_type,
   node.vid AS node_vid
 FROM snh_node node 
 LEFT JOIN snh_content_field_termin node_data_field_termin ON node.vid = node_data_field_termin.vid
WHERE (node.type in ('event')) AND (node.status <> 0) AND (node.language in ('***CURRENT_LANGUAGE***'))
   ORDER BY node_data_field_termin_field_termin_value ASC

I'm quite frustrated by drupal, because of the many serious bugs popping up all the time and all over the place. If there is something stated in the documentation (or even in the admin interface as in this case) to work a certain way, there obviously should exist a unit test to make sure this stays true for all future releases.

The lack of testing on the developer side makes a huge overhead of testing on the admin user side neccesary. I and thousands of other drupal admins do not want to write a selenium test for every simple functionality that the documenation says would be there, to make sure it actually stays there. But I have to do so - or drop drupal for future projects.

arlinsandbulte’s picture

Status: Active » Fixed

I could not reproduce.
I think this has been fixed (I remember some other issues regarding this)
If I am wrong, feel free to re-open this issue.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.