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

dawehner’s picture

Status: Active » Fixed
Issue tags: -date format, -group by, -repeating date, -date formatter

That'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.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.