my filters look like this

(
Node: Published or admin
AND Node: Type exposed
) AND (
Node: Type <> Calendar event
OR Date: Date (node) (Content: Date (field_date) - From date) Exposed Popup Day
)

this is the correct representation of what I specify. However, the generated SQL is this. Please scroll to the end and note the underlined part

SELECT node.nid AS nid, gmaps_content_point.vid AS gmaps_content_point_vid, gmaps_content_point.map_type AS gmaps_content_point_map_type, gmaps_content_point.latitude AS gmaps_content_point_latitude, gmaps_content_point.longitude AS gmaps_content_point_longitude, gmaps_content_point.elevation AS gmaps_content_point_elevation, gmaps_content_point.x AS gmaps_content_point_x, gmaps_content_point.y AS gmaps_content_point_y, gmaps_content_point.z AS gmaps_content_point_z, gmaps_content_point.privacy AS gmaps_content_point_privacy, gmaps_content_point.bounds AS gmaps_content_point_bounds, gmaps_content_point.pov AS gmaps_content_point_pov, gmaps_content_point.search AS gmaps_content_point_search, node.vid AS node_vid, node.uid AS node_uid, node.type AS node_type, node.title AS node_title, node.sticky AS node_sticky FROM node node LEFT JOIN content_field_date node_data_field_date ON node.vid = node_data_field_date.vid LEFT JOIN gmaps_content_point gmaps_content_point ON node.vid = gmaps_content_point.vid WHERE ((node.status <> 0 OR (node.uid = ***CURRENT_USER*** AND ***CURRENT_USER*** <> 0) OR ***ADMINISTER_NODES*** = 1) AND (node.type in ('calendar_event', 'profile', 'study_group'))) AND (node.type not in ('calendar_event')) AND (DATE_FORMAT(ADDTIME(node_data_field_date.field_date_value, SEC_TO_TIME(-28800)), '%Y-%m-%d') >= '2010-03-03')

the Node: Type <> Calendar event is not grouped with the the date condition and AND'ed instead of OR'ed.

Comments

dawehner’s picture

Project: Views (for Drupal 7) » Date
Version: 6.x-3.0-alpha2 » 6.x-2.x-dev
Component: User interface » Code

the Date modul creates some or-groups for themself. Perhaps this should be there, first.

LxT’s picture

Project: Date » Views (for Drupal 7)
Version: 6.x-2.x-dev » 6.x-3.0-alpha2
Component: Code » User interface

I'm also seeing instances where params in filter fields aren't saved. For example:

1) add a Node:Type filter. expose filter. select "is one of" and check 2 or 3 content types. check "optional", uncheck "force single", check "Limit list to selected items" Update and save. When you edit the view again, you'll see that "Limit list to selected items" is not checked.

2) add a Date (node) filter. select a date field. add some condition, like >= now. update. the filter will now show "Date: Date (node) Missing date fields!" because the date field you selected was not saved.

dawehner’s picture

Project: Views (for Drupal 7) » Date
Version: 6.x-3.0-alpha2 » 6.x-2.x-dev
Component: User interface » Code

1) This is a duplicate of http://drupal.org/node/721358

So i updated the issue again. Please first check the issue queue.

JKingsnorth’s picture

Status: Active » Closed (duplicate)

So marking this as a duplicate.