Forums / Setup & design / Group_by date .. how to !?!

Group_by date .. how to !?!

Author Message

Marvix Marx

Thursday 14 June 2007 5:39:37 pm

I cann`t find any place for more info about "Group_by" ... just grouping by date/day .. and its not working also !

{let
        dates=fetch( 'content','tree',hash( 
                                parent_node_id, 2,
                                class_filter_type, 'include',
                                class_filter_array, array('article'),
								sort_by, array('published', true() ),
								group_by, array( "published",  "day" ) ,
                                'limit', 100
								
                                )
                        )
}

with "group_by" or without I get 100 date, 80 of them same date ... how to group them ?!

The sql debug saying " GROUP BY ( ezcontentobject.published / 86400 ) "

but the publish date is time stamp ... that mean even the seconds in there ... will never do group with this way ,,, any one have any idea about this ?

Thanks