>=now filter not working in Views + CCK
| Project: | CCK Fieldgroup Table |
| Version: | 5.x-1.x-dev |
| Component: | Miscellaneous |
| Category: | support request |
| Priority: | normal |
| Assigned: | greekgirl831 |
| Status: | active |
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.
| Attachment | Size |
|---|---|
| Picture 4.png | 69.98 KB |
