>=now filter not working in Views + CCK

greekgirl831 - April 15, 2009 - 18:51
Project:CCK Fieldgroup Table
Version:5.x-1.x-dev
Component:Miscellaneous
Category:support request
Priority:normal
Assigned:greekgirl831
Status:active
Description

I have found several other posts where people have had a similar issue. I've updated to the latest views and cck -dev yet no matter what I try I cannot get my Filters to work properly!

I'm trying to filter a datetime where To date >= now.

When I expose Date:Date everything works properly. When I hide Date:Date it's broken again.

Here is the Query being generated:

--------

SELECT node.nid AS nid,
node.title AS node_title,
node_data_field_event_date.field_event_date_value AS node_data_field_event_date_field_event_date_value,
node_data_field_event_date.field_event_date_value2 AS node_data_field_event_date_field_event_date_value2,
node_data_field_event_date.field_event_date_timezone AS node_data_field_event_date_field_event_date_timezone,
node_data_field_event_date.field_event_date_offset AS node_data_field_event_date_field_event_date_offset,
node_data_field_event_date.field_event_date_offset2 AS node_data_field_event_date_field_event_date_offset2,
node.type AS node_type,
node.vid AS node_vid
FROM node node
LEFT JOIN content_type_event node_data_field_event_date ON node.vid = node_data_field_event_date.vid
WHERE (node.type in ('event')) AND (node.status <> 0)
ORDER BY node_data_field_event_date_field_event_date_value ASC

---------

Any one have any ideas?

I've also attached an image of the settings in my view.

AttachmentSize
Picture 4.png69.98 KB
 
 

Drupal is a registered trademark of Dries Buytaert.