Forums / Setup & design / fetching items with various locations

fetching items with various locations

Author Message

Marko Žmak

Wednesday 28 July 2004 7:27:44 am

I have two folders: "News" and "Science". I would like to display a list of those and only those articles that have this two folders for their location.
Is there any posibility to make a criteria for the fetch function that would fetch only theese folders?

Please help.

--
Nothing is impossible. Not if you can imagine it!

Hubert Farnsworth

Nicolas Heiringhoff

Thursday 29 July 2004 2:40:06 am

Hello,

You could use this code to display the title, intro and body for all the articles in your "News" folder


{* Fetch everything that is under node #296 (children, grand-children, etc.) *}
{let nodes=fetch( 'content', 'tree', hash( 'parent_node_id', 296 ) ) }

{* Loop through the nodes and display their names. *}
{section loop=$nodes}



<br />
    <a href={concat("/content/view/full/",$:item.node_id)|ezurl}>{$:item.data_map.title.data_text}</a>
    
    <br />
    {$:item.data_map.intro.data_text}
    
    <br />
    
    {$:item.data_map.body.data_text}

    <br />    

{/section}



{/let}

simply replace the node id 296 with the node id of your "News"-folder.

For displaying all the articles in your "Science"-folder, simply use the code above another time, with the node id of the "Science"-folder.

this should work.

Nico

http://www.heiringhoff.de

Silke Fox

Thursday 29 July 2004 5:12:16 am

You can also use an array of node ids for fetch functions.

{let nodes=fetch( 'content', 'tree', hash( 'parent_node_id', array( <node1>, <node2> ) ) ) }

Marko Žmak

Thursday 29 July 2004 10:05:02 am

Nicolas, I think that you didn't understand my problem but Silke did.
Thanks Silke, I'll give it a try. Does the fetch function use "AND" or "OR" operator on nodes in the nodes array in your example. For my problem, I need "AND"...

--
Nothing is impossible. Not if you can imagine it!

Hubert Farnsworth

Silke Fox

Thursday 29 July 2004 12:13:29 pm

Marko,
yes, it is "AND".
The result is an array of your "News" and "Science" objects.
That way you can also sort all objects from these two nodes in one list.

Silke

Marko Žmak

Thursday 29 July 2004 2:21:20 pm

Thanks a lot.

--
Nothing is impossible. Not if you can imagine it!

Hubert Farnsworth

eZ debug

Timing: Jan 18 2025 21:00:29
Script start
Timing: Jan 18 2025 21:00:29
Module start 'content'
Timing: Jan 18 2025 21:00:29
Module end 'content'
Timing: Jan 18 2025 21:00:29
Script end

Main resources:

Total runtime0.8154 sec
Peak memory usage4,096.0000 KB
Database Queries205

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0074 588.9453180.8281
Module start 'content' 0.00740.6899 769.7734618.3047
Module end 'content' 0.69730.1180 1,388.0781337.0703
Script end 0.8154  1,725.1484 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00430.5213210.0002
Check MTime0.00170.2071210.0001
Mysql Total
Database connection0.00100.123410.0010
Mysqli_queries0.736890.36152050.0036
Looping result0.00210.26052030.0000
Template Total0.781595.820.3907
Template load0.00220.266520.0011
Template processing0.779395.571020.3896
Template load and register function0.00010.012910.0001
states
state_id_array0.00100.126310.0010
state_identifier_array0.00080.093120.0004
Override
Cache load0.00180.2268320.0001
Sytem overhead
Fetch class attribute can translate value0.00150.189240.0004
Fetch class attribute name0.00160.197480.0002
XML
Image XML parsing0.00210.251640.0005
class_abstraction
Instantiating content class attribute0.00000.0018100.0000
General
dbfile0.00630.7692350.0002
String conversion0.00000.001030.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
4content/datatype/view/ezimage.tpl<No override>extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tplEdit templateOverride template
6content/datatype/view/ezxmltext.tpl<No override>extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tplEdit templateOverride template
3content/datatype/view/ezxmltags/line.tpl<No override>design/standard/templates/content/datatype/view/ezxmltags/line.tplEdit templateOverride template
7content/datatype/view/ezxmltags/paragraph.tpl<No override>extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tplEdit templateOverride template
2content/datatype/view/ezxmltags/literal.tpl<No override>extension/community/design/standard/templates/content/datatype/view/ezxmltags/literal.tplEdit templateOverride template
1pagelayout.tpl<No override>extension/sevenx/design/simple/templates/pagelayout.tplEdit templateOverride template
 Number of times templates used: 24
 Number of unique templates used: 7

Time used to render debug report: 0.0002 secs