Closed (fixed)
Project:
Date
Version:
6.x-2.0-rc6
Component:
Code
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
10 Feb 2009 at 17:58 UTC
Updated:
27 Feb 2009 at 07:40 UTC
First, sorry for my english.
I'm trying to make data browser for events archive. My events is CCK nodes with Date fields: "from" & optionally "to" parts. I'm looked at default date browser view and make similar thing (see attached view-date-arg.gif).
But i always get empty result. SQL in preview looks like:
SELECT node.nid AS nid,
node_data_field_date.field_date_value AS node_data_field_date_field_date_value,
node_data_field_date.field_date_value2 AS node_data_field_date_field_date_value2,
node.type AS node_type
FROM node node
LEFT JOIN content_type_event node_data_field_date ON node.vid = node_data_field_date.vid
WHERE ((node.status <> 0) AND (node.type in ('event')) AND (node.moderate = 0))
AND (((DATE_FORMAT(STR_TO_DATE(node_data_field_date.field_date_value, '%Y-%m-%dT%T'), '%Y-%m') <= '2008-10' AND DATE_FORMAT(STR_TO_DATE(node_data_field_date.field_date_value2, '%Y-%m-%dT%T'), '%Y-%m') >= '2008-10')) OR ((DATE_FORMAT(STR_TO_DATE(node_data_field_date.field_date_value, '%Y-%m-%dT%T'), '%Y-%m') <= '2008-10' AND DATE_FORMAT(STR_TO_DATE(node_data_field_date.field_date_value2, '%Y-%m-%dT%T'), '%Y-%m') >= '2008-10')))
ORDER BY node_data_field_date_field_date_value ASC
I think checking start date for "<= arg" and end date for "=> arg" at same time is buggy.
| Comment | File | Size | Author |
|---|---|---|---|
| view-date-arg.gif | 82.39 KB | fairwind@drupal.ru |
Comments
Comment #1
karens commentedYou have selected both the from date and the to date in the argument. The description right below those fields says not to select both of them. If that doesn't solve your problem you need to check the latest Date module code to see if there is still a problem there.
Comment #2
fairwind@drupal.ru commentedThanks.
One more thing i'm missing: i need to delete filter by this fields :)
All works now.