sort unique children

Next topic

Author	Message
Milad P	Thursday 31 May 2007 11:07:52 am I want to list my latest forum topics on the first page. Currently I use the fetch code below, but I get same topic back serveral times. How can i sort uniquelly in my node so that only one forum_reply from each forum_topic will be listed? {def $children = fetch('content', 'tree', hash('parent_node_id', 321, main_node_only, true(), class_filter_type, 'include', class_filter_array, array('forum_topic'), sort_by, array('modified', false()), limit,10 ))}
Bruce Morrison	Thursday 31 May 2007 4:20:36 pm Hiya Try adding 'main_node_only', true() Cheers Bruce My Blog: http://www.stuffandcontent.com/ Follow me on twitter: http://twitter.com/brucemorrison Consolidated eZ Publish Feed : http://friendfeed.com/rooms/ez-publish
Milad P	Friday 01 June 2007 12:53:19 am I have tried that, but the problem is that every forum_reply has already a unique main_node_id.

Author

Message

Thursday 31 May 2007 11:07:52 am

I want to list my latest forum topics on the first page. Currently I use the fetch code below, but I get same topic back serveral times. How can i sort uniquelly in my node so that only one forum_reply from each forum_topic will be listed?

    {def $children = fetch('content', 'tree', hash('parent_node_id', 321, main_node_only, true(), class_filter_type, 'include', class_filter_array, array('forum_topic'), sort_by, array('modified', false()), limit,10 ))}

Bruce Morrison

Thursday 31 May 2007 4:20:36 pm

Hiya

Try adding

'main_node_only', true()

Cheers
Bruce

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

Milad P

Friday 01 June 2007 12:53:19 am

I have tried that, but the problem is that every forum_reply has already a unique main_node_id.

eZ debug

Timing:	Jan 31 2025 01:35:25
Script start
Timing:	Jan 31 2025 01:35:25
Module start 'layout'
Timing:	Jan 31 2025 01:35:25
Module start 'content'
Timing:	Jan 31 2025 01:35:25
Module end 'content'
Timing:	Jan 31 2025 01:35:25
Script end

Main resources:

Total runtime	0.0251 sec
Peak memory usage	6,144.0000 KB
Database Queries	3

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0055	588.0078	151.1953
Module start 'layout'	0.0055	0.0049	739.2031	220.6719
Module start 'content'	0.0104	0.0131	959.8750	997.8672
Module end 'content'	0.0235	0.0016	1,957.7422	29.9922
Script end	0.0251		1,987.7344

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0027	10.6899	14	0.0002
Check MTime	0.0011	4.2824	14	0.0001
Mysql Total
Database connection	0.0007	2.8141	1	0.0007
Mysqli_queries	0.0030	12.1060	3	0.0010
Looping result	0.0000	0.0959	1	0.0000
Template Total	0.0012	4.6	1	0.0012
Template load	0.0009	3.6228	1	0.0009
Template processing	0.0003	0.9994	1	0.0003
Override
Cache load	0.0006	2.2532	1	0.0006
General
dbfile	0.0002	0.9681	8	0.0000
String conversion	0.0000	0.0446	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