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

"Please Note:
  • At the specific request of Ibexa we are changing this projects name to "Exponential" or "Exponential (CMS)" effective as of August, 11th 2025.
  • This project is not associated with the original eZ Publish software or its original developer, eZ Systems or Ibexa".

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