Fetch only nodes with children

Next topic

Author	Message
Zdenek Ziegler	Thursday 15 June 2006 5:17:53 am Hello, is it possible to fetch only nodes with children - can I use attribute filter or how to do this? Thanks in advance, Zdenek
Matthew Carroll	Saturday 24 June 2006 11:02:18 am I don't think that you can use an attribute filter to do that. An extended_attribute_filter, maybe, but much easier, I think, would be to fetch all the nodes then 'filter' them in the template, using children_count. Assuming you've fetched the array of nodes as $list, something like: {foreach $list as $listitem} {if ne( $listitem.children_count, 0 )} ...... {/if} {/foreach} http://ez.no/doc/ez_publish/technical_manual/3_8/reference/objects/ezcontentobjecttreenode Hope that helps... Matthew http://carroll.org.uk
Milad P	Sunday 25 June 2006 7:36:49 am how do you limit the loop? Eq. After that i have fetched and checked with children_count that the objecvt have a child, then i only want it to show say top three objects. How do i limit it? //Milad

Author

Message

Thursday 15 June 2006 5:17:53 am

Hello,
is it possible to fetch only nodes with children - can I use attribute filter or how to do this?
Thanks in advance,
Zdenek

Matthew Carroll

Saturday 24 June 2006 11:02:18 am

I don't think that you can use an attribute filter to do that. An extended_attribute_filter, maybe, but much easier, I think, would be to fetch all the nodes then 'filter' them in the template, using children_count. Assuming you've fetched the array of nodes as $list, something like:

{foreach $list as $listitem}
{if ne( $listitem.children_count, 0 )}
......
{/if}
{/foreach}

http://ez.no/doc/ez_publish/technical_manual/3_8/reference/objects/ezcontentobjecttreenode

Hope that helps...
Matthew

http://carroll.org.uk

Milad P

Sunday 25 June 2006 7:36:49 am

how do you limit the loop?

Eq. After that i have fetched and checked with children_count that the objecvt have a child, then i only want it to show say top three objects. How do i limit it?

//Milad

eZ debug

Timing:	Jan 30 2025 00:54:40
Script start
Timing:	Jan 30 2025 00:54:40
Module start 'layout'
Timing:	Jan 30 2025 00:54:40
Module start 'content'
Timing:	Jan 30 2025 00:54:40
Module end 'content'
Timing:	Jan 30 2025 00:54:40
Script end

Main resources:

Total runtime	0.0179 sec
Peak memory usage	2,048.0000 KB
Database Queries	3

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0053	588.1250	151.2109
Module start 'layout'	0.0054	0.0034	739.3359	36.6484
Module start 'content'	0.0087	0.0074	775.9844	90.2344
Module end 'content'	0.0162	0.0017	866.2188	29.9922
Script end	0.0178		896.2109

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0027	15.2716	14	0.0002
Check MTime	0.0011	6.2670	14	0.0001
Mysql Total
Database connection	0.0006	3.4214	1	0.0006
Mysqli_queries	0.0033	18.5371	3	0.0011
Looping result	0.0000	0.1293	1	0.0000
Template Total	0.0012	6.9	1	0.0012
Template load	0.0010	5.3433	1	0.0010
Template processing	0.0003	1.5088	1	0.0003
Override
Cache load	0.0006	3.6226	1	0.0006
General
dbfile	0.0024	13.4416	8	0.0003
String conversion	0.0000	0.0440	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	Edit	Override
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 1 Number of unique templates used: 1

Time used to render debug report: 0.0001 secs