Fetch reverse related objects and sort_by attribute

«

Previous topic

|

|

Next topic

»

Author	Message
Ulrich L.	Monday 22 January 2007 2:58:05 pm Hi, as the documentation states: when using "fetch(content, reverse_related_objects...)" it is not possible to perform sort_by with the attribute parameter, as it is possible with "fetch(content, list, ...)" This is really a pity! Does anybody have a good suggestion how to use "fetch(content, reverse_related_objects...)" AND to perform sorting by attribute in a different way? I really need this... Thanks, Ulrich eZ 3.8.5
Andreas Kaiser	Tuesday 23 January 2007 12:07:30 pm I have some problems getting inside a template the nice url to a "related object" - and looking around I found these: Perhaps these posts help you out: http://ez.no/community/forum/general/object_relations Perhaps this contribution helps: http://ez.no/community/contribs/datatypes/enhanced_objectrelation eZ Partner in Madrid (Spain) Web: http://www.atela.net/
Ulrich L.	Wednesday 24 January 2007 6:35:31 am Thanks. I don't intend to join EOR since eZpublish manages to cover pretty much of that functionality out of the box today. The forum thread is interesting. In the middle of it somebody explains that for sorting he creates a sort function, written in PHP and located in index.php. Is this the only way to go for me, too?
Xavier Dutoit	Wednesday 24 January 2007 11:54:14 pm Hi, I suggest to create a custom sort template function (that could be used to sort any node/object table). Eg : {$unsorted_objects = fetch(content, reverse_related_objects...) $sorted = {$unsorted\|sort('your_attribute',true())} X+ http://www.sydesy.com

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 16:25:27
Script start
Timing:	Jan 18 2025 16:25:28
Module start 'layout'
Timing:	Jan 18 2025 16:25:28
Module start 'content'
Timing:	Jan 18 2025 16:25:28
Module end 'content'
Timing:	Jan 18 2025 16:25:28
Script end

Main resources:

Total runtime	0.0157 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.0055	588.1563	152.6563
Module start 'layout'	0.0055	0.0029	740.8125	39.4922
Module start 'content'	0.0084	0.0049	780.3047	89.4766
Module end 'content'	0.0133	0.0023	869.7813	34.3047
Script end	0.0157		904.0859

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0025	15.6987	14	0.0002
Check MTime	0.0011	6.8677	14	0.0001
Mysql Total
Database connection	0.0008	4.7814	1	0.0008
Mysqli_queries	0.0022	13.7506	3	0.0007
Looping result	0.0000	0.1716	1	0.0000
Template Total	0.0020	12.7	1	0.0020
Template load	0.0008	5.3554	1	0.0008
Template processing	0.0011	7.2853	1	0.0011
Override
Cache load	0.0006	3.7945	1	0.0006
General
dbfile	0.0002	1.4121	8	0.0000
String conversion	0.0000	0.0501	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