Forums / Setup & design / Group_by parameter in fetch function

Group_by parameter in fetch function

« 
Previous topic
|
Setup & design
|
Next topic
 »
Author Message

Scott Blundell

Wednesday 03 March 2004 4:19:20 am

Does anyone have any examples on how to use the group_by parameter within the fetch function?

It sounds useful but I cannot find any documentation or any examples that use it.

Thanks in advance

Scott

James Packham

Wednesday 03 March 2004 5:33:34 am

There's an example in the blog demo. If you didn't install it look at

kernel/setup/packages/blog/files/default/design.blog/override/templates/archive_navigatorbar.tpl
kernel/setup/packages/blog/files/default/design.blog/override/templates/log_navigationbar.tpl

Regards,

James

Scott Blundell

Wednesday 03 March 2004 7:42:40 am

Thanks for the help, James - it was just what I was after.

Regards

Scott

Alex Jones

Wednesday 03 March 2004 7:44:39 am

It would be nice to see some documentation on <i>group_by</i>. I have no clue as to what it does other than assuming that it will group the returned results. But what are the valid keys that we can group by? Attributes, classes, sections...?

Alex

Alex
[ bald_technologist on the IRC channel (irc.freenode.net): #eZpublish ]

<i>When in doubt, clear the cache.</i>

eZ debug

Timing: Jan 18 2025 02:49:08
Script start
Timing: Jan 18 2025 02:49:08
Module start 'content'
Timing: Jan 18 2025 02:49:09
Module end 'content'
Timing: Jan 18 2025 02:49:09
Script end

Main resources:

Total runtime0.8637 sec
Peak memory usage4,096.0000 KB
Database Queries199

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0069 587.8281180.8281
Module start 'content' 0.00700.7466 768.6563582.9688
Module end 'content' 0.75360.1101 1,351.6250333.3828
Script end 0.8637  1,685.0078 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00420.4904210.0002
Check MTime0.00170.1938210.0001
Mysql Total
Database connection0.00050.057810.0005
Mysqli_queries0.799992.60741990.0040
Looping result0.00160.18791970.0000
Template Total0.835196.720.4176
Template load0.00210.246120.0011
Template processing0.833096.438120.4165
Template load and register function0.00010.017410.0001
states
state_id_array0.00090.108510.0009
state_identifier_array0.00070.086020.0004
Override
Cache load0.00170.2008220.0001
Sytem overhead
Fetch class attribute can translate value0.00140.167040.0004
Fetch class attribute name0.00110.121860.0002
XML
Image XML parsing0.00130.151940.0003
class_abstraction
Instantiating content class attribute0.00000.001460.0000
General
dbfile0.00220.2562330.0001
String conversion0.00000.001030.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
1node/view/full.tplfull/forum_topic.tplextension/sevenx/design/simple/override/templates/full/forum_topic.tplEdit templateOverride template
4content/datatype/view/ezxmltext.tpl<No override>extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tplEdit templateOverride template
5content/datatype/view/ezxmltags/paragraph.tpl<No override>extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tplEdit templateOverride template
2content/datatype/view/ezimage.tpl<No override>extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tplEdit templateOverride template
1content/datatype/view/ezxmltags/line.tpl<No override>design/standard/templates/content/datatype/view/ezxmltags/line.tplEdit templateOverride template
1pagelayout.tpl<No override>extension/sevenx/design/simple/templates/pagelayout.tplEdit templateOverride template
 Number of times templates used: 14
 Number of unique templates used: 6

Time used to render debug report: 0.0001 secs