reverse_related_objects and sort order

Next topic

Author	Message
Daniel Guerrier	Wednesday 21 September 2005 9:45:54 pm I am using this code to get the instances of myclass that are pointing to an abject_id of 91. It seems to ignore the sort parameter. When I print the objects it displays the items in the same order regardless of setting the sort published to true or false. Is this the proper behavior? If so, how can I sort the results? {def $objects=fetch( 'content', 'reverse_related_objects', hash( 'object_id', 91, 'attribute_identifier', 'myclass/apointer', 'sort_by', array( 'published', true() ) ) )}
Nathan Kelly	Wednesday 21 September 2005 11:38:32 pm From my understanding I don't think you can use the "sort by" parameter with a "reverse_related_objects" fetch. http://ez.no/doc/ez_publish/technical_manual/3_6/reference/modules/content/fetch_functions/reverse_related_objects I know you can sort the results of a "list" fetch, but from the docs I not sure its possible with RRO? I'm not sure but this: http://ez.no/community/contribs/datatypes/enhanced_objectrelation may help you achieve sorting, I haven't looked into it that far though! Cheers! Pardon me while I burst into flames...
Sam Wong	Saturday 26 November 2005 11:24:06 am Works fine for me. {def $objects=fetch( 'content', 'reverse_related_objects', hash( object_id, $node.contentobject_id, attribute_identifier, 207, 'sort_by', array('published', false()) ) )} Oh, BTW, this is for my related latest news... so naturally false() is for decending.

Author

Message

Wednesday 21 September 2005 9:45:54 pm

I am using this code to get the instances of myclass that are pointing to an abject_id of 91.
It seems to ignore the sort parameter. When I print the objects it displays the items in the same order regardless of setting the sort published to true or false.

Is this the proper behavior? If so, how can I sort the results?

{def $objects=fetch( 'content', 'reverse_related_objects',
                     hash( 'object_id', 91,
                           'attribute_identifier', 'myclass/apointer',
						    'sort_by',  array( 'published', true() )
							) )}

Nathan Kelly

Wednesday 21 September 2005 11:38:32 pm

From my understanding I don't think you can use the "sort by" parameter with a "reverse_related_objects" fetch.

http://ez.no/doc/ez_publish/technical_manual/3_6/reference/modules/content/fetch_functions/reverse_related_objects

I know you can sort the results of a "list" fetch, but from the docs I not sure its possible with RRO?

I'm not sure but this: http://ez.no/community/contribs/datatypes/enhanced_objectrelation
may help you achieve sorting, I haven't looked into it that far though!

Cheers!

Pardon me while I burst into flames...

Sam Wong

Saturday 26 November 2005 11:24:06 am

Works fine for me.

{def $objects=fetch( 'content', 'reverse_related_objects', hash( object_id, $node.contentobject_id, attribute_identifier, 207, 'sort_by', array('published', false()) ) )}

Oh, BTW, this is for my related latest news... so naturally false() is for decending.

eZ debug

Timing:	Jan 18 2025 19:26:31
Script start
Timing:	Jan 18 2025 19:26:31
Module start 'layout'
Timing:	Jan 18 2025 19:26:31
Module start 'content'
Timing:	Jan 18 2025 19:26:31
Module end 'content'
Timing:	Jan 18 2025 19:26:31
Script end

Main resources:

Total runtime	0.0403 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.0134	589.1484	152.6406
Module start 'layout'	0.0134	0.0075	741.7891	39.4766
Module start 'content'	0.0209	0.0160	781.2656	89.4609
Module end 'content'	0.0369	0.0033	870.7266	34.3047
Script end	0.0402		905.0313

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0042	10.4473	14	0.0003
Check MTime	0.0019	4.7256	14	0.0001
Mysql Total
Database connection	0.0018	4.5728	1	0.0018
Mysqli_queries	0.0112	27.7295	3	0.0037
Looping result	0.0000	0.0598	1	0.0000
Template Total	0.0025	6.2	1	0.0025
Template load	0.0018	4.4189	1	0.0018
Template processing	0.0007	1.7688	1	0.0007
Override
Cache load	0.0015	3.6632	1	0.0015
General
dbfile	0.0062	15.5104	8	0.0008
String conversion	0.0000	0.0272	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