tried to set the delta option to 1 in the date sorting criteria
but still output one row for each value in the multiple value date field "date_repeat"

sql output of view

SELECT DISTINCT(node.nid) AS nid, 
node.title AS node_title, 
node.sticky AS node_sticky, 
node_data_field_date_repeat.field_date_repeat_value AS node_data_field_date_repeat_field_date_repeat_value 
FROM mcs__node node  
LEFT JOIN mcs__content_field_date_repeat node_data_field_date_repeat ON node.vid = node_data_field_date_repeat.vid 
WHERE ((node.status <> 0) AND (node.type in ('activity', 'friday_worship', 'gospel_lunch', 'joyful_journey', 'lunch_hour', 'lunch_power'))) 
AND ((DATE_FORMAT(STR_TO_DATE(node_data_field_date_repeat.field_date_repeat_value, '%Y-%m-%dT%T'), '%Y-%m-%d') >= '2009-01-15' 
AND DATE_FORMAT(STR_TO_DATE(node_data_field_date_repeat.field_date_repeat_value, '%Y-%m-%dT%T'), '%Y-%m-%d') <= '2009-02-05')) 
ORDER BY node_sticky DESC, node_data_field_date_repeat_field_date_repeat_value ASC

Comments

karens’s picture

karens commented
Status: Active » Closed (won't fix)

The handling of multiple dates in Views has been changed and doesn't work this way any more. It never made any sense for dates to pick a delta by value.

Josh Benner’s picture

Josh Benner commented

Is this still a bug in the most recent date module versions?

Not having it sort on a delta makes the sorting behavior of multi-value date fields entirely dependent on which row the database decides to kick out. Effectively, sorting on multi-value date fields can yield "undefined" behavior. Use-cases aside, predictable sorting is important.

I think the solution is to either specifically say sorting on multi-value date fields doesn't work, disable sorting on multi-value date fields, or make the delta selection work as expected.