How to fetch nodes that belong to differents sections ?

Next topic

Author	Message
Benjamin Lemoine	Thursday 18 May 2006 9:31:16 am Hi ! I've differents scattered nodes in my main tree that belong to differents sections. I want to know if there is a solution wich permits to fetch these nodes according to a section? ex: fetch('content', 'node', hash('parent_node_id', 2, 'section_id', 6)) Thanks.
Stuart Fenton	Thursday 18 May 2006 10:10:35 am Yes you can add a section id to the fetch statement. Have a look here: http://ez.no/products/ez_publish/documentation/customization/tips_tricks/fetch_function_examples Regards Fats -- Stuart stuart@grandmore.com http://www.grandmore.com
Benjamin Lemoine	Thursday 18 May 2006 11:38:07 pm Thanks for your reply, but this fetch function only permit to sort nodes by section. What I want is fetch nodes that belong to one particular section. Any ideas ?
Łukasz Serwatka	Thursday 18 May 2006 11:45:12 pm Hi Benjamin, You can use object_list http://ez.no/doc/ez_publish/technical_manual/3_7/reference/modules/section/fetch_functions/object_list Personal website -> http://serwatka.net Blog (about eZ Publish) -> http://serwatka.net/blog
Benjamin Lemoine	Friday 19 May 2006 12:17:45 am Thanks, it works ! But now, is it possible to limit to one level? Example: - My tree \| Main \| \|-- Folder1 \|----- Subfolder \|----- Article \| \|-- Folder 2 \|----- Subfolder1 \|----- Subfolder2 \| \|-- Folder 3 \|----- Subfolder1 \|----- Subfolder2 \| \|-- ........ I want to make a menu that only contains Folder 1 and Folder 3. So I've created a section that contains Folders 1 & 3. And, with fetch object by section_id, it displays : - Folder 1 - Subfolder - Article - Folder 3 - Subfolder - Subfolder Can I limit the fetch to the first level ?

eZ debug

Timing:	Jan 19 2025 00:35:56
Script start
Timing:	Jan 19 2025 00:35:56
Module start 'layout'
Timing:	Jan 19 2025 00:35:56
Module start 'content'
Timing:	Jan 19 2025 00:35:57
Module end 'content'
Timing:	Jan 19 2025 00:35:57
Script end

Main resources:

Total runtime	1.0550 sec
Peak memory usage	4,096.0000 KB
Database Queries	65

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0076	588.1563	152.6563
Module start 'layout'	0.0076	0.0030	740.8125	39.5078
Module start 'content'	0.0105	1.0433	780.3203	605.6484
Module end 'content'	1.0539	0.0011	1,385.9688	12.1094
Script end	1.0550		1,398.0781

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0036	0.3398	16	0.0002
Check MTime	0.0014	0.1294	16	0.0001
Mysql Total
Database connection	0.0017	0.1565	1	0.0017
Mysqli_queries	0.9938	94.1982	65	0.0153
Looping result	0.0006	0.0614	63	0.0000
Template Total	1.0075	95.5	2	0.5038
Template load	0.0020	0.1872	2	0.0010
Template processing	1.0055	95.3096	2	0.5028
Template load and register function	0.0001	0.0140	1	0.0001
states
state_id_array	0.0077	0.7254	1	0.0077
state_identifier_array	0.0020	0.1864	2	0.0010
Override
Cache load	0.0018	0.1667	52	0.0000
Sytem overhead
Fetch class attribute can translate value	0.0008	0.0737	3	0.0003
Fetch class attribute name	0.0010	0.0927	7	0.0001
XML
Image XML parsing	0.0014	0.1306	3	0.0005
class_abstraction
Instantiating content class attribute	0.0000	0.0013	7	0.0000
General
dbfile	0.0011	0.1060	24	0.0000
String conversion	0.0000	0.0007	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
5	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
11	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
2	content/datatype/view/ezimage.tpl	<No override>	extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tpl
6	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: 26 Number of unique templates used: 6

Time used to render debug report: 0.0001 secs