Forums / Setup & design / Complicated fetch...

Complicated fetch...

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.

eZ debug

Timing: Jan 18 2025 18:17:09
Script start
Timing: Jan 18 2025 18:17:09
Module start 'content'
Timing: Jan 18 2025 18:17:10
Module end 'content'
Timing: Jan 18 2025 18:17:10
Script end

Main resources:

Total runtime1.4168 sec
Peak memory usage4,096.0000 KB
Database Queries191

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0063 587.6094180.8438
Module start 'content' 0.00631.2173 768.4531463.9141
Module end 'content' 1.22360.1931 1,232.3672333.5000
Script end 1.4167  1,565.8672 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00390.2748210.0002
Check MTime0.00150.1029210.0001
Mysql Total
Database connection0.00080.059110.0008
Mysqli_queries1.339394.53131910.0070
Looping result0.00280.19491890.0000
Template Total1.380297.420.6901
Template load0.00240.166420.0012
Template processing1.377897.245520.6889
Template load and register function0.00020.011410.0002
states
state_id_array0.00260.186110.0026
state_identifier_array0.00220.154720.0011
Override
Cache load0.00190.1368190.0001
Sytem overhead
Fetch class attribute can translate value0.00300.213530.0010
Fetch class attribute name0.00140.099620.0007
XML
Image XML parsing0.00060.043030.0002
class_abstraction
Instantiating content class attribute0.00000.000420.0000
General
dbfile0.00530.3747210.0003
String conversion0.00000.000430.0000
Note: percentages do not add up to 100% because some accumulators overlap

CSS/JS files loaded with "ezjscPacker" during request:

CacheTypePacklevelSourceFiles
CSS0extension/community/design/community/stylesheets/ext/jquery.autocomplete.css
extension/community_design/design/suncana/stylesheets/scrollbars.css
extension/community_design/design/suncana/stylesheets/tabs.css
extension/community_design/design/suncana/stylesheets/roadmap.css
extension/community_design/design/suncana/stylesheets/content.css
extension/community_design/design/suncana/stylesheets/star-rating.css
extension/community_design/design/suncana/stylesheets/syntax_and_custom_tags.css
extension/community_design/design/suncana/stylesheets/buttons.css
extension/community_design/design/suncana/stylesheets/tweetbox.css
extension/community_design/design/suncana/stylesheets/jquery.fancybox-1.3.4.css
extension/bcsmoothgallery/design/standard/stylesheets/magnific-popup.css
extension/sevenx/design/simple/stylesheets/star_rating.css
extension/sevenx/design/simple/stylesheets/libs/fontawesome/css/all.min.css
extension/sevenx/design/simple/stylesheets/main.v02.css
extension/sevenx/design/simple/stylesheets/main.v02.res.css
JS0extension/ezjscore/design/standard/lib/yui/3.17.2/build/yui/yui-min.js
extension/ezjscore/design/standard/javascript/jquery-3.7.0.min.js
extension/community_design/design/suncana/javascript/jquery.ui.core.min.js
extension/community_design/design/suncana/javascript/jquery.ui.widget.min.js
extension/community_design/design/suncana/javascript/jquery.easing.1.3.js
extension/community_design/design/suncana/javascript/jquery.ui.tabs.js
extension/community_design/design/suncana/javascript/jquery.hoverIntent.min.js
extension/community_design/design/suncana/javascript/jquery.popmenu.js
extension/community_design/design/suncana/javascript/jScrollPane.js
extension/community_design/design/suncana/javascript/jquery.mousewheel.js
extension/community_design/design/suncana/javascript/jquery.cycle.all.js
extension/sevenx/design/simple/javascript/jquery.scrollTo.js
extension/community_design/design/suncana/javascript/jquery.cookie.js
extension/community_design/design/suncana/javascript/ezstarrating_jquery.js
extension/community_design/design/suncana/javascript/jquery.initboxes.js
extension/community_design/design/suncana/javascript/app.js
extension/community_design/design/suncana/javascript/twitterwidget.js
extension/community_design/design/suncana/javascript/community.js
extension/community_design/design/suncana/javascript/roadmap.js
extension/community_design/design/suncana/javascript/ez.js
extension/community_design/design/suncana/javascript/ezshareevents.js
extension/sevenx/design/simple/javascript/main.js

Templates used to render the page:

UsageRequested templateTemplateTemplate loadedEditOverride
1node/view/full.tplfull/forum_topic.tplextension/sevenx/design/simple/override/templates/full/forum_topic.tplEdit templateOverride template
2content/datatype/view/ezxmltext.tpl<No override>extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tplEdit templateOverride template
3content/datatype/view/ezxmltags/paragraph.tpl<No override>extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tplEdit templateOverride template
1content/datatype/view/ezxmltags/line.tpl<No override>design/standard/templates/content/datatype/view/ezxmltags/line.tplEdit templateOverride template
1pagelayout.tpl<No override>extension/sevenx/design/simple/templates/pagelayout.tplEdit templateOverride template
 Number of times templates used: 8
 Number of unique templates used: 5

Time used to render debug report: 0.0001 secs