Closed (fixed)
Project:
Date
Version:
6.x-2.x-dev
Component:
Code
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
2 Apr 2009 at 16:03 UTC
Updated:
14 Jul 2010 at 16:30 UTC
Hi,
I've got a problem with the AND/ORs for view querys: My view querys a field for dates. Now when I've a spanning date used to filter the views query, the AND/Or in this part of the query
WHERE ((DATE_FORMAT(FROM_UNIXTIME(node_data_field_date.field_date_value), '%Y-%m-%d') >= '2009-04-02') AND (DATE_FORMAT(FROM_UNIXTIME(node_data_field_date.field_date_value2), '%Y-%m-%d') >= '2009-04-02')
is taken from the setting of the date field, instead of the filter's and/or setting. The filter is described as this:
Datum: Date (node) Inhalt: Datum (field_date) - From date
OR Inhalt: Datum (field_date) - To date >= now
and the whole views query
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,
node.vid AS node_vid,
node_revisions.title AS node_revisions_title,
node_revisions.nid AS node_revisions_nid,
node_revisions.teaser AS node_revisions_teaser,
node_revisions.format AS node_revisions_format
FROM termine_node node
LEFT JOIN termine_content_type_date node_data_field_date ON node.vid = node_data_field_date.vid
INNER JOIN termine_term_node term_node ON node.vid = term_node.vid
LEFT JOIN termine_node_revisions node_revisions ON node.vid = node_revisions.vid
WHERE ((DATE_FORMAT(FROM_UNIXTIME(node_data_field_date.field_date_value), '%Y-%m-%d') >= '2009-04-02') AND (DATE_FORMAT(FROM_UNIXTIME(node_data_field_date.field_date_value2), '%Y-%m-%d') >= '2009-04-02') AND ((DATE_FORMAT(FROM_UNIXTIME(node_data_field_date.field_date_value), '%Y') <= '2009' AND DATE_FORMAT(FROM_UNIXTIME(node_data_field_date.field_date_value2), '%Y') >= '2009')) AND ((DATE_FORMAT(FROM_UNIXTIME(node_data_field_date.field_date_value), '%Y') <= '2009' AND DATE_FORMAT(FROM_UNIXTIME(node_data_field_date.field_date_value2), '%Y') >= '2009')))
AND (term_node.tid IN (6, 5, 1, 3, 2, 4))
ORDER BY node_data_field_date_field_date_value ASC
If you need more infos, the view or sth else, just ask :)
Keep up the good work!
Comments
Comment #1
arlinsandbulte commentedping
Is this still valid?
If there are no replies/support in a couple of months, I will close this issue.
Comment #2
arlinsandbulte commentedclosing as per #1