Bug in limiting results from fetching tree?

Previous topic

Setup & design

Next topic

Author	Message
Kjell Inge Sandvik	Thursday 08 September 2005 5:30:48 am Hello I have a code like this: {def $bilder=fetch(content,tree,hash(parent_node_id,77, class_filter_type,include,class_filter_array,array('picture')), limit,6, sort_by,array('published',false()))} to loop through a content tree of pictures. The fetch should only get the 6 most recent additions, but instead it returns all! Is this a bug? BTW: node-id 77 is the topnode of the tree. Sandvik Web & Data
Kristof Coomans	Thursday 08 September 2005 6:05:07 am I think there's a mistake in your template code. You've closed the hash with the parameters after array('picture'), but limit and sort_by should be keys inside the hash. This is the right code: {def $bilder=fetch(content,tree,hash(parent_node_id,77, class_filter_type,include,class_filter_array,array('picture'), limit,6, sort_by,array('published',false())))} independent eZ Publish developer and service provider \| http://blog.coomanskristof.be \| http://ezpedia.org
Kjell Inge Sandvik	Thursday 08 September 2005 6:29:42 am Ah of course! Thank you! My eyes did not notice that one :-) Sandvik Web & Data

Author

Message

Kjell Inge Sandvik

Thursday 08 September 2005 5:30:48 am

Hello

I have a code like this:

{def $bilder=fetch(content,tree,hash(parent_node_id,77, class_filter_type,include,class_filter_array,array('picture')),
limit,6, sort_by,array('published',false()))}

to loop through a content tree of pictures. The fetch should only get the 6 most recent additions, but instead it returns all! Is this a bug?

BTW: node-id 77 is the topnode of the tree.

Sandvik Web & Data

Kristof Coomans

Thursday 08 September 2005 6:05:07 am

I think there's a mistake in your template code. You've closed the hash with the parameters after array('picture'), but limit and sort_by should be keys inside the hash.

This is the right code:

{def $bilder=fetch(content,tree,hash(parent_node_id,77, class_filter_type,include,class_filter_array,array('picture'),
limit,6, sort_by,array('published',false())))}

independent eZ Publish developer and service provider | http://blog.coomanskristof.be | http://ezpedia.org

Kjell Inge Sandvik

Thursday 08 September 2005 6:29:42 am

Ah of course! Thank you! My eyes did not notice that one :-)

Sandvik Web & Data

eZ debug

Timing:	Jan 19 2025 00:20:47
Script start
Timing:	Jan 19 2025 00:20:47
Module start 'layout'
Timing:	Jan 19 2025 00:20:47
Module start 'content'
Timing:	Jan 19 2025 00:20:48
Module end 'content'
Timing:	Jan 19 2025 00:20:48
Script end

Main resources:

Total runtime	0.8886 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.0066	588.0469	152.6406
Module start 'layout'	0.0066	0.0030	740.6875	39.4766
Module start 'content'	0.0096	0.8776	780.1641	539.2656
Module end 'content'	0.8872	0.0014	1,319.4297	12.1250
Script end	0.8886		1,331.5547

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0035	0.3934	16	0.0002
Check MTime	0.0013	0.1515	16	0.0001
Mysql Total
Database connection	0.0014	0.1578	1	0.0014
Mysqli_queries	0.8365	94.1309	57	0.0147
Looping result	0.0007	0.0742	55	0.0000
Template Total	0.8590	96.7	2	0.4295
Template load	0.0023	0.2613	2	0.0012
Template processing	0.8567	96.4041	2	0.4283
Template load and register function	0.0001	0.0132	1	0.0001
states
state_id_array	0.0011	0.1214	1	0.0011
state_identifier_array	0.0007	0.0742	2	0.0003
Override
Cache load	0.0020	0.2250	17	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0007	0.0761	2	0.0003
Fetch class attribute name	0.0012	0.1387	5	0.0002
XML
Image XML parsing	0.0009	0.1043	2	0.0005
class_abstraction
Instantiating content class attribute	0.0000	0.0013	6	0.0000
General
dbfile	0.0008	0.0875	22	0.0000
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
4	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
2	content/datatype/view/ezxmltags/literal.tpl	<No override>	extension/community/design/standard/templates/content/datatype/view/ezxmltags/literal.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