Group_by parameter in fetch function

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

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0073	589.4609	152.6406
Module start 'layout'	0.0073	0.0039	742.1016	39.4766
Module start 'content'	0.0112	1.0845	781.5781	577.8750
Module end 'content'	1.0957	0.0012	1,359.4531	12.1406
Script end	1.0968		1,371.5938

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0032	0.2942	16	0.0002
Check MTime	0.0013	0.1175	16	0.0001
Mysql Total
Database connection	0.0012	0.1119	1	0.0012
Mysqli_queries	1.0426	95.0527	62	0.0168
Looping result	0.0006	0.0590	60	0.0000
Template Total	1.0580	96.5	2	0.5290
Template load	0.0021	0.1896	2	0.0010
Template processing	1.0559	96.2629	2	0.5279
Template load and register function	0.0002	0.0196	1	0.0002
states
state_id_array	0.0025	0.2317	1	0.0025
state_identifier_array	0.0011	0.1008	2	0.0006
Override
Cache load	0.0017	0.1567	22	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0006	0.0583	3	0.0002
Fetch class attribute name	0.0010	0.0935	6	0.0002
XML
Image XML parsing	0.0014	0.1271	3	0.0005
class_abstraction
Instantiating content class attribute	0.0000	0.0009	6	0.0000
General
dbfile	0.0011	0.1017	22	0.0001
String conversion	0.0000	0.0007	4	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Usage	Requested template	Template	Template loaded
1	node/view/full.tpl	full/forum_topic.tpl	extension/sevenx/design/simple/override/templates/full/forum_topic.tpl
4	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
5	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
2	content/datatype/view/ezimage.tpl	<No override>	extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tpl
1	content/datatype/view/ezxmltags/line.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/line.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 14 Number of unique templates used: 6

Time used to render debug report: 0.0001 secs