I spent quite a bit of time searching around for a solution as I'm not seeing any relevant bugs being reported in the issue queues.
Using Views 7.x-3.0-rc3; Ctools 7.x-1.0-rc1; Date & DateViews 7.x-2.0-alpha4;
The content type uses repeating dates
Creating a view with three fields
Just Date (Hidden) (Group by) (Same Data as Just Time - Displayed Differently using a custom date format)
Just Time (Same Data as Just Date - Displayed Differently using a custom date)
Event Title
Here's what displays (I've fiddled with using distinct and aggregate by in advanced)
Monday, November 21
2:45pm test event
Monday, November 21
4:00pm test2 event
Tuesday, November 22
2:45pm test event
Tuesday, November 22
4:00pm test2 event
Here's how I want it to display
Monday, November 21
2:45pm test event
4:00pm test2 event
Tuesday, November 22
2:45pm test event
4:00pm test2 event
Any ideas? In an older version of date and views I've recreated this functionality, but the newer versions only give you two options for the date formatter (date/time and time ago) could that be the issue? It seems like it is treating each entry as distinct and not grouping at all....
I'll include the query if that helps:
Query SELECT field_data_field_event_date.delta AS field_data_field_event_date_delta, field_data_field_event_date.field_event_date_value AS field_data_field_event_date_field_event_date_value, node.title AS node_title, node.nid AS nid_1, MIN(node.nid) AS nid, 'node' AS field_data_field_event_date_node_entity_type
FROM
{node} node
LEFT JOIN {field_data_field_event_date} field_data_field_event_date ON node.nid = field_data_field_event_date.entity_id AND (field_data_field_event_date.entity_type = 'node' AND field_data_field_event_date.deleted = '0')
WHERE (( (node.status = '1') AND (node.type IN ('event')) AND (DATE_FORMAT(field_data_field_event_date.field_event_date_value, '%Y-%m-%d') >= '2011-11-21' AND DATE_FORMAT(field_data_field_event_date.field_event_date_value, '%Y-%m-%d') <= '2011-11-22') ))
GROUP BY field_data_field_event_date_delta, field_data_field_event_date_field_event_date_value, node_title, nid_1
LIMIT 10 OFFSET 0
It seems like it may be a bug, but I'm pretty new to Drupal so I could be wrong...
Comments
Comment #1
dawehnerThat's technical actually a feature request, as the date module doesn't support grouping currently. Additional i'm pretty sure that there are issues for that in the date issue queue already.
Based on that let's update the status.