Complicated fetch...

Next topic

Author	Message
Christian Johansen	Wednesday 05 July 2006 7:08:31 am I'm trying to do a fetch that I'm not sure is possible. I don't know how to do it anyways, so I was hoping for some input. This is my situation: Content structure - Articles - Cat 1 - article 1 - article 2 - ... - Cat 2 - article 1 and so on. These use images stored in the media library through it's related objects. There's no custom image input on the article class, just related objects to store the images. Now what I want to do is to display all images from Category 1 and so on. That is - objects of type "image" related to the children and grandchildren of the current node. Is this possible? I can see a few ways to hack it, but not without generating (literally) a thousand sql queries... Has anyone done anything like it?
Pål Jostein Didriksen	Saturday 08 July 2006 10:28:38 am Well, I'm thinking that it should be possible to do it like this: - fetch content tree, set the class_filter_array to 'article' - loop through the contents and display the related object by using {attribute_view_gui attribute=$node.something} Another possibility could be to create a line view template override for the class article, that will only display the image. Check the line view template you already have for displaying articles, it should give you the code needed to display the images.

Author

Message

Wednesday 05 July 2006 7:08:31 am

I'm trying to do a fetch that I'm not sure is possible. I don't know how to do it anyways, so I was hoping for some input. This is my situation:

Content structure
- Articles
- Cat 1
- article 1
- article 2
- ...
- Cat 2
- article 1

and so on.

These use images stored in the media library through it's related objects. There's no custom image input on the article class, just related objects to store the images. Now what I want to do is to display all images from Category 1 and so on. That is - objects of type "image" related to the children and grandchildren of the current node. Is this possible? I can see a few ways to hack it, but not without generating (literally) a thousand sql queries... Has anyone done anything like it?

Pål Jostein Didriksen

Saturday 08 July 2006 10:28:38 am

Well, I'm thinking that it should be possible to do it like this:

- fetch content tree, set the class_filter_array to 'article'

- loop through the contents and display the related object by using {attribute_view_gui attribute=$node.something}

Another possibility could be to create a line view template override for the class article, that will only display the image. Check the line view template you already have for displaying articles, it should give you the code needed to display the images.

eZ debug

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

Main resources:

Total runtime	0.7311 sec
Peak memory usage	4,096.0000 KB
Database Queries	54

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0049	587.8125	152.6094
Module start 'layout'	0.0049	0.0030	740.4219	39.4141
Module start 'content'	0.0079	0.7218	779.8359	458.8516
Module end 'content'	0.7297	0.0013	1,238.6875	8.1875
Script end	0.7310		1,246.8750

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0032	0.4433	16	0.0002
Check MTime	0.0013	0.1840	16	0.0001
Mysql Total
Database connection	0.0006	0.0878	1	0.0006
Mysqli_queries	0.6905	94.4453	54	0.0128
Looping result	0.0005	0.0698	52	0.0000
Template Total	0.7018	96.0	2	0.3509
Template load	0.0020	0.2708	2	0.0010
Template processing	0.6998	95.7291	2	0.3499
Template load and register function	0.0002	0.0312	1	0.0002
states
state_id_array	0.0007	0.1010	1	0.0007
state_identifier_array	0.0018	0.2446	2	0.0009
Override
Cache load	0.0016	0.2251	19	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0009	0.1168	2	0.0004
Fetch class attribute name	0.0012	0.1626	2	0.0006
XML
Image XML parsing	0.0003	0.0367	2	0.0001
class_abstraction
Instantiating content class attribute	0.0000	0.0013	2	0.0000
General
dbfile	0.0013	0.1774	10	0.0001
String conversion	0.0000	0.0014	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
2	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
3	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.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: 8 Number of unique templates used: 5

Time used to render debug report: 0.0001 secs