Grouping by an attribute

Next topic

Author	Message
Pablo C. Vergara Castro	Friday 13 August 2004 1:43:39 am Hi to all. I would like to know the way to make fetch that single gives back objects to me grouped by a certain attribute. For example, I have several objects of a class publication that have an attribute dates, and what I want it is to know the way to extract the dates that are different and in addition to solely be able to count them. {... 1999 ...},{... 2000 ...},{... 1999 ...},{... 2001 ...},{... 2000 ...} ===> {1999},{2000},{2001}, (3 attributes)

Author

Message

Friday 13 August 2004 1:43:39 am

Hi to all.

I would like to know the way to make fetch that single gives back objects to me grouped by a certain attribute. For example, I have several objects of a class publication that have an attribute dates, and what I want it is to know the way to extract the dates that are different and in addition to solely be able to count them.

{... 1999 ...},{... 2000 ...},{... 1999 ...},{... 2001 ...},{... 2000 ...} ===> {1999},{2000},{2001}, (3 attributes)

eZ debug

Timing:	Jan 19 2025 13:46:38
Script start
Timing:	Jan 19 2025 13:46:38
Module start 'layout'
Timing:	Jan 19 2025 13:46:38
Module start 'content'
Timing:	Jan 19 2025 13:46:39
Module end 'content'
Timing:	Jan 19 2025 13:46:39
Script end

Main resources:

Total runtime	1.0868 sec
Peak memory usage	4,096.0000 KB
Database Queries	46

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0049	589.1563	152.6250
Module start 'layout'	0.0049	0.0021	741.7813	39.4453
Module start 'content'	0.0069	1.0784	781.2266	398.4063
Module end 'content'	1.0853	0.0015	1,179.6328	8.1641
Script end	1.0868		1,187.7969

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0030	0.2764	16	0.0002
Check MTime	0.0012	0.1107	16	0.0001
Mysql Total
Database connection	0.0007	0.0638	1	0.0007
Mysqli_queries	1.0540	96.9808	46	0.0229
Looping result	0.0004	0.0329	44	0.0000
Template Total	1.0579	97.3	2	0.5290
Template load	0.0020	0.1830	2	0.0010
Template processing	1.0559	97.1558	2	0.5280
Template load and register function	0.0002	0.0138	1	0.0002
states
state_id_array	0.0010	0.0944	1	0.0010
state_identifier_array	0.0011	0.0998	2	0.0005
Override
Cache load	0.0016	0.1486	6	0.0003
Sytem overhead
Fetch class attribute can translate value	0.0005	0.0499	1	0.0005
Fetch class attribute name	0.0006	0.0520	1	0.0006
XML
Image XML parsing	0.0001	0.0132	1	0.0001
class_abstraction
Instantiating content class attribute	0.0000	0.0004	1	0.0000
General
dbfile	0.0014	0.1263	10	0.0001
String conversion	0.0000	0.0005	4	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

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
1	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
1	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 4 Number of unique templates used: 4

Time used to render debug report: 0.0001 secs