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
Comment #1
dawehnerthe Date modul creates some or-groups for themself. Perhaps this should be there, first.
Comment #2
LxT CreditAttribution: LxT commentedI'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.
Comment #3
dawehner1) This is a duplicate of http://drupal.org/node/721358
So i updated the issue again. Please first check the issue queue.
Comment #4
JKingsnorth CreditAttribution: JKingsnorth commentedSo marking this as a duplicate.