Dear experts,
I'm using views to create a list of dates to for a whole year. Therefore I configured a filter using the date year range: '-0:+1' to filter the events of current and the next year. This filter has no effect on the results. Absolute ranges as '2011:2012' have also no effect!
Please have a look at the settings (open attached jpg).
This view creates the following query:
Italicized
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_data_field_date.field_date_rrule AS node_data_field_date_field_date_rrule,
node.language AS node_language,
node_data_field_date.delta AS node_data_field_date_delta,
node.type AS node_type,
node.vid AS node_vid,
node.title AS node_title
FROM node node
LEFT JOIN content_field_date node_data_field_date ON node.vid = node_data_field_date.vid
WHERE node.type in ('date')
ORDER BY node_data_field_date_field_date_value ASC
Thanks for your help and advices.
Comment | File | Size | Author |
---|---|---|---|
#3 | views1.JPG | 88.38 KB | iceman2202 |
#3 | ViewExport.txt | 6.31 KB | iceman2202 |
Comments
Comment #1
dawehnerPlease export your view. A jpg doesn't really help, especially if you don't have uploaded it :)
Comment #2
dawehnerAs you can read on http://drupal.org/node/571990 if there is a field provided by another module it should be linked against the other module.
As it's on the jpg it's the date module.
Comment #3
iceman2202 CreditAttribution: iceman2202 commentedSorry, I did not recognize that I forgot the attachment.
Here the export of the view:
Thanks.
Comment #4
iceman2202 CreditAttribution: iceman2202 commentedIs there anybody there who can give me a hint how to solve this problem. Otherwise I must delete a lot of events.
It would be very nice to get this view work as intended.
Thanks.
Comment #5
DamienMcKennaWe're sorry but the D6 release of Date module is no longer being supported. You are encouraged to update to Drupal 7 or 8, or direct questions to Drupal Answers.