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
Comment #1
meigwil commentedThis is probably a Date module problem. An issue has been posted here http://drupal.org/node/1066690