Help creating a group_by attribute fetch function

Previous topic

Developer

Next topic

Author	Message
H-Works Agency	Friday 29 December 2006 4:20:17 am Hi all, Does an advanced EZP user can tell me how could i create a custom fetch function that would fetch result grouped by childrens attributes ? Thanx for the help. Martin EZP is Great
kracker (the)	Friday 29 December 2006 4:43:28 am Learning about fetch, a very old introduction (good read). <i>http://ez.no/ezpublish/documentation/customization/custom_design/database_connectivity</i> I think after reading this I would seek to add the custom fetch (and or attributes), I needed in the kernel as a ... proof of concept, possibly to be submitted back as a patch. Files to read, 'kernel/content/function_definition.php', 'kernel/content/ezcontentfunctioncollection.php' Default fetch functions, <i>http://ez.no/doc/ez_publish/technical_manual/3_8/reference/template_fetch_functions</i> Fetch Alias features, <i>http://ez.no/doc/ez_publish/technical_manual/3_6/reference/template_functions/miscellaneous/fetch_alias</i> <i>//kracker</i> <b>Related threads</b> <i>http://ez.no/community/forum/general/fetch_unique_content_on_some_attribute http://ez.no/community/forum/general/fetch_list_group_by_or_unique_on_child_attribute </i> Member since: 2001.07.13 \|\| http://ezpedia.se7enx.com/
H-Works Agency	Monday 01 January 2007 6:39:18 am Ok thanx. Its sad its not a built-in feature to be able to group per child attribute. This would definitly solve the problem of managing the color/size/quantity in products in EZP. EZP is Great

Author

Message

H-Works Agency

Friday 29 December 2006 4:20:17 am

Hi all,

Does an advanced EZP user can tell me how could i create a custom fetch function that would fetch result grouped by childrens attributes ?

Thanx for the help.

Martin

EZP is Great

kracker (the)

Friday 29 December 2006 4:43:28 am

Learning about fetch, a very old introduction (good read).
http://ez.no/ezpublish/documentation/customization/custom_design/database_connectivity

I think after reading this I would seek to add the custom fetch (and or attributes),
I needed in the kernel as a ... proof of concept, possibly to be submitted back as a patch.
Files to read, 'kernel/content/function_definition.php', 'kernel/content/ezcontentfunctioncollection.php'

Default fetch functions,
http://ez.no/doc/ez_publish/technical_manual/3_8/reference/template_fetch_functions

Fetch Alias features,
http://ez.no/doc/ez_publish/technical_manual/3_6/reference/template_functions/miscellaneous/fetch_alias

//kracker

Related threads
http://ez.no/community/forum/general/fetch_unique_content_on_some_attribute
http://ez.no/community/forum/general/fetch_list_group_by_or_unique_on_child_attribute

Member since: 2001.07.13 || http://ezpedia.se7enx.com/

H-Works Agency

Monday 01 January 2007 6:39:18 am

Ok thanx.

Its sad its not a built-in feature to be able to group per child attribute.

This would definitly solve the problem of managing the color/size/quantity in products in EZP.

EZP is Great

eZ debug

Timing:	Jan 18 2025 20:53:39
Script start
Timing:	Jan 18 2025 20:53:39
Module start 'layout'
Timing:	Jan 18 2025 20:53:39
Module start 'content'
Timing:	Jan 18 2025 20:53:40
Module end 'content'
Timing:	Jan 18 2025 20:53:40
Script end

Main resources:

Total runtime	0.8079 sec
Peak memory usage	4,096.0000 KB
Database Queries	57

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0065	588.0469	152.6406
Module start 'layout'	0.0065	0.0032	740.6875	39.4922
Module start 'content'	0.0097	0.7968	780.1797	547.6484
Module end 'content'	0.8065	0.0014	1,327.8281	12.1250
Script end	0.8079		1,339.9531

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0034	0.4153	16	0.0002
Check MTime	0.0013	0.1597	16	0.0001
Mysql Total
Database connection	0.0010	0.1221	1	0.0010
Mysqli_queries	0.7499	92.8162	57	0.0132
Looping result	0.0006	0.0766	55	0.0000
Template Total	0.7776	96.2	2	0.3888
Template load	0.0022	0.2706	2	0.0011
Template processing	0.7754	95.9722	2	0.3877
Template load and register function	0.0001	0.0110	1	0.0001
states
state_id_array	0.0007	0.0849	1	0.0007
state_identifier_array	0.0013	0.1571	2	0.0006
Override
Cache load	0.0018	0.2206	29	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0009	0.1098	2	0.0004
Fetch class attribute name	0.0010	0.1262	5	0.0002
XML
Image XML parsing	0.0018	0.2213	2	0.0009
class_abstraction
Instantiating content class attribute	0.0000	0.0018	6	0.0000
General
dbfile	0.0021	0.2650	25	0.0001
String conversion	0.0000	0.0010	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
3	content/datatype/view/ezimage.tpl	<No override>	extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tpl
3	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
7	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
5	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: 20 Number of unique templates used: 6

Time used to render debug report: 0.0001 secs