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

arlinsandbulte’s picture

Status: Active » Postponed (maintainer needs more info)

ping
Is this still valid?

If there are no replies/support in a couple of months, I will close this issue.

arlinsandbulte’s picture

Status: Postponed (maintainer needs more info) » Closed (fixed)

closing as per #1