Fetch content by Section ID

Author Message

Muhammad Khalid Majeed

Tuesday 04 May 2004 11:41:48 pm

I am create different folder and assign one section more than 1 folder. Now i need to fetch contents from all folders. Now I have option that i set multiple commands like

{let new_release=fetch(content,list, hash( parent_node_id,
$node.parent_node_id, sort_by, array(
published, false() ), class_filter_type, include,
class_filter_array, array( 'article')))}

for each folder. But Is it possible that i can fetch contents from all folder by selecting Section ID? I have try this by no result

{let new_release=fetch(content,list, hash( section_id,
$node.object.section_id, limit,11, sort_by, array(
published, false() ), class_filter_type, include,
class_filter_array, array( 'article')))}

for this My work will be easy and if my folders will increase then my old code will be work.

Muhammad Khalid
Software Engineer
www.webgurru.net

Bruce Morrison

Wednesday 05 May 2004 12:15:06 am

It doesn't appear that you can.

See http://ez.no/ez_publish/documentation/reference/data_fetching/content/list

You can loop through the results of the fetch and only display nodes that belong to a specific section.

Cheers
Bruce http://www.designit.com.au/

My Blog: http://www.stuffandcontent.com/
Follow me on twitter: http://twitter.com/brucemorrison
Consolidated eZ Publish Feed : http://friendfeed.com/rooms/ez-publish

Muhammad Khalid Majeed

Wednesday 05 May 2004 3:06:13 am

Thanks Bruce

But the URL you wrote only documented related lists. there is nothing to fetch contents using section ID. Also I can't understand the idea which you said to loop by section id.

If you have any example code then plz send it. Or have anyother idea.

Muhammad Khalid
Software Engineer
www.webgurru.net

Jan Borsodi

Wednesday 05 May 2004 4:50:13 am

You should be able to do it by using the attribute_filter and matching on 'section',
try the the following fetch

fetch( content, tree,
       hash( parent_node_id, $node.parent_node_id,
             sort_by, array( published, false() ),
	     attribute_filter, array( 'and', array( 'section', '=', $node.object.section_id ) ),
             class_filter_type, include,
	     class_filter_array, array( 'article' ) )  )

This uses <i>tree</i> fetching to fetch all objects under that node and not just the ones as direct chidren.

--
Amos

Documentation: http://ez.no/ez_publish/documentation
FAQ: http://ez.no/ez_publish/documentation/faq

Kevin Myles

Friday 23 July 2004 10:02:25 am

I found this post by Jan very helpful when I wanted to tweak my main menu to only show a particular section in my menu. Of course, it'll work for any fetch.

However i found that I had to replace the $node.object.section_id with the node I wanted, as follows:

      {let menuitems=fetch( 'content', 'list', hash( 'parent_node_id', 2,
                                                   'sort_by', $root_node.sort_array, attribute_filter, array( 'and', array( 'section', '=', 1 ) ),
class_filter_type, include,
                                                   class_filter_array, array( 'folder' ) ) )}

Powered by eZ Publish™ CMS Open Source Web Content Management. Copyright © 1999-2014 eZ Systems AS (except where otherwise noted). All rights reserved.

eZ debug

Timing: Jan 18 2025 19:22:37
Script start
Timing: Jan 18 2025 19:22:37
Module start 'layout'
Timing: Jan 18 2025 19:22:37
Module start 'content'
Timing: Jan 18 2025 19:22:38
Module end 'content'
Timing: Jan 18 2025 19:22:38
Script end

Main resources:

Total runtime0.8676 sec
Peak memory usage4,096.0000 KB
Database Queries67

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0061 587.9141152.6250
Module start 'layout' 0.00610.0029 740.539139.4453
Module start 'content' 0.00900.8568 779.9844635.1094
Module end 'content' 0.86580.0017 1,415.093816.1641
Script end 0.8676  1,431.2578 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00340.3924160.0002
Check MTime0.00140.1610160.0001
Mysql Total
Database connection0.00070.079910.0007
Mysqli_queries0.805792.8604670.0120
Looping result0.00080.0902650.0000
Template Total0.836596.420.4182
Template load0.00220.250220.0011
Template processing0.834396.157020.4171
Template load and register function0.00040.050310.0004
states
state_id_array0.00080.093410.0008
state_identifier_array0.00100.120920.0005
Override
Cache load0.00180.2124350.0001
Sytem overhead
Fetch class attribute can translate value0.00100.113040.0002
Fetch class attribute name0.00150.174770.0002
XML
Image XML parsing0.00190.215340.0005
class_abstraction
Instantiating content class attribute0.00000.001670.0000
General
dbfile0.00110.1290230.0000
String conversion0.00000.000840.0000
Note: percentages do not add up to 100% because some accumulators overlap

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
5content/datatype/view/ezxmltext.tpl<No override>extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tplEdit templateOverride template
9content/datatype/view/ezxmltags/paragraph.tpl<No override>extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tplEdit templateOverride template
4content/datatype/view/ezxmltags/line.tpl<No override>design/standard/templates/content/datatype/view/ezxmltags/line.tplEdit templateOverride template
2content/datatype/view/ezimage.tpl<No override>extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tplEdit templateOverride template
2content/datatype/view/ezxmltags/literal.tpl<No override>extension/community/design/standard/templates/content/datatype/view/ezxmltags/literal.tplEdit templateOverride template
1print_pagelayout.tpl<No override>extension/community/design/community/templates/print_pagelayout.tplEdit templateOverride template
 Number of times templates used: 24
 Number of unique templates used: 7

Time used to render debug report: 0.0001 secs