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

eZ debug

Timing: Jan 20 2025 06:45:08
Script start
Timing: Jan 20 2025 06:45:08
Module start 'content'
Timing: Jan 20 2025 06:45:08
Module end 'content'
Timing: Jan 20 2025 06:45:08
Script end

Main resources:

Total runtime0.1414 sec
Peak memory usage4,096.0000 KB
Database Queries141

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0055 590.3594180.8438
Module start 'content' 0.00550.0058 771.203189.7891
Module end 'content' 0.01130.1300 860.9922518.7734
Script end 0.1413  1,379.7656 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00332.3589200.0002
Check MTime0.00130.9086200.0001
Mysql Total
Database connection0.00080.548910.0008
Mysqli_queries0.095967.85561410.0007
Looping result0.00120.83371390.0000
Template Total0.129691.710.1296
Template load0.00090.625910.0009
Template processing0.128891.068410.1288
Override
Cache load0.00070.463210.0007
Sytem overhead
Fetch class attribute can translate value0.00090.616810.0009
XML
Image XML parsing0.00030.212110.0003
General
dbfile0.00574.0172200.0003
String conversion0.00000.005130.0000
Note: percentages do not add up to 100% because some accumulators overlap

CSS/JS files loaded with "ezjscPacker" during request:

CacheTypePacklevelSourceFiles
CSS0extension/community/design/community/stylesheets/ext/jquery.autocomplete.css
extension/community_design/design/suncana/stylesheets/scrollbars.css
extension/community_design/design/suncana/stylesheets/tabs.css
extension/community_design/design/suncana/stylesheets/roadmap.css
extension/community_design/design/suncana/stylesheets/content.css
extension/community_design/design/suncana/stylesheets/star-rating.css
extension/community_design/design/suncana/stylesheets/syntax_and_custom_tags.css
extension/community_design/design/suncana/stylesheets/buttons.css
extension/community_design/design/suncana/stylesheets/tweetbox.css
extension/community_design/design/suncana/stylesheets/jquery.fancybox-1.3.4.css
extension/bcsmoothgallery/design/standard/stylesheets/magnific-popup.css
extension/sevenx/design/simple/stylesheets/star_rating.css
extension/sevenx/design/simple/stylesheets/libs/fontawesome/css/all.min.css
extension/sevenx/design/simple/stylesheets/main.v02.css
extension/sevenx/design/simple/stylesheets/main.v02.res.css
JS0extension/ezjscore/design/standard/lib/yui/3.17.2/build/yui/yui-min.js
extension/ezjscore/design/standard/javascript/jquery-3.7.0.min.js
extension/community_design/design/suncana/javascript/jquery.ui.core.min.js
extension/community_design/design/suncana/javascript/jquery.ui.widget.min.js
extension/community_design/design/suncana/javascript/jquery.easing.1.3.js
extension/community_design/design/suncana/javascript/jquery.ui.tabs.js
extension/community_design/design/suncana/javascript/jquery.hoverIntent.min.js
extension/community_design/design/suncana/javascript/jquery.popmenu.js
extension/community_design/design/suncana/javascript/jScrollPane.js
extension/community_design/design/suncana/javascript/jquery.mousewheel.js
extension/community_design/design/suncana/javascript/jquery.cycle.all.js
extension/sevenx/design/simple/javascript/jquery.scrollTo.js
extension/community_design/design/suncana/javascript/jquery.cookie.js
extension/community_design/design/suncana/javascript/ezstarrating_jquery.js
extension/community_design/design/suncana/javascript/jquery.initboxes.js
extension/community_design/design/suncana/javascript/app.js
extension/community_design/design/suncana/javascript/twitterwidget.js
extension/community_design/design/suncana/javascript/community.js
extension/community_design/design/suncana/javascript/roadmap.js
extension/community_design/design/suncana/javascript/ez.js
extension/community_design/design/suncana/javascript/ezshareevents.js
extension/sevenx/design/simple/javascript/main.js

Templates used to render the page:

UsageRequested templateTemplateTemplate loadedEditOverride
1pagelayout.tpl<No override>extension/sevenx/design/simple/templates/pagelayout.tplEdit templateOverride template
 Number of times templates used: 1
 Number of unique templates used: 1

Time used to render debug report: 0.0001 secs