I have a content type with a title, datetime (Date module) and body field.

When creating a a calendar-like view, nothing is displayed if I choose the datetime field as a content type. I filtered on the node type, and ordered by the datetime field ASC. If I removed the datetime field from the Fields, it would show the content type (with the ORDER BY and filter in place).

Here is the SQL generated without the datetime field:

SELECT node.title AS node_title, node.nid AS nid, 'node' AS field_data_body_node_entity_type
FROM 
{node} node
WHERE (( (node.type IN  ('eitem_calendr')) ))
LIMIT 10 OFFSET 0
SELECT node.title AS node_title, node.nid AS nid, field_data_field_datetime.delta AS field_data_field_datetime_delta, field_data_field_datetime.language AS field_data_field_datetime_language, field_data_field_datetime.bundle AS field_data_field_datetime_bundle, field_data_field_datetime.field_datetime_value AS field_data_field_datetime_field_datetime_value, field_data_field_datetime.field_datetime_value2 AS field_data_field_datetime_field_datetime_value2, field_data_field_datetime.revision_id AS field_data_field_datetime_revision_id, 'node' AS field_data_body_node_entity_type, 'node' AS field_data_field_datetime_node_entity_type
FROM 
{node} node
LEFT JOIN {field_data_field_datetime} field_data_field_datetime ON node.nid = field_data_field_datetime.entity_id AND (field_data_field_datetime.entity_type = :views_join_condition_0 AND field_data_field_datetime.deleted = :views_join_condition_1)
WHERE (( (node.type IN  ('eitem_calendr')) AND (field_data_field_datetime.language = 'en') ))
LIMIT 10 OFFSET 0

I'm very new to Drupal so I hope this is enough information. Please ask if you need anything else.

I'm using the 7.x-1.0-alpha2 version of Date.

Comments

meigwil’s picture

Status: Active » Closed (duplicate)

This is probably a Date module problem. An issue has been posted here http://drupal.org/node/1066690