Forums / Setup & design / reverse_related_objects and sort order

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 18:27:52

Script start

Timing:

Jan 18 2025 18:27:52

Module start 'content'

Timing:

Jan 18 2025 18:27:52

Module end 'content'

Timing:

Jan 18 2025 18:27:52

Script end

Main resources:

Total runtime

0.0139 sec

Peak memory usage

2,048.0000 KB

Database Queries

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0061	588.9453	180.8281
Module start 'content'	0.0061	0.0039	769.7734	94.0234
Module end 'content'	0.0100	0.0039	863.7969	70.7031
Script end	0.0138		934.5000

Checkpoint

Start (sec)

Duration (sec)

Memory at start (KB)

Memory used (KB)

Script start

0.0000

0.0061

588.9453

180.8281

Module start 'content'

0.0061

0.0039

769.7734

94.0234

Module end 'content'

0.0100

0.0039

863.7969

70.7031

Script end

0.0138

934.5000

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0022	15.4862	12	0.0002
Check MTime	0.0010	7.1821	12	0.0001
Mysql Total
Database connection	0.0007	5.3256	1	0.0007
Mysqli_queries	0.0028	20.4310	4	0.0007
Looping result	0.0000	0.1081	2	0.0000
Template Total	0.0036	26.0	1	0.0036
Template load	0.0008	6.0445	1	0.0008
Template processing	0.0028	19.9334	1	0.0028
Override
Cache load	0.0006	4.0732	1	0.0006
General
dbfile	0.0003	2.0023	10	0.0000
String conversion	0.0000	0.0360	3	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Accumulator

Duration (sec)

Duration (%)

Count

Average (sec)

Ini load

Load cache

0.0022

15.4862

0.0002

Check MTime

0.0010

7.1821

0.0001

Mysql Total

Database connection

0.0007

5.3256

0.0007

Mysqli_queries

0.0028

20.4310

0.0007

Looping result

0.0000

0.1081

0.0000

Template Total

0.0036

26.0

0.0036

Template load

0.0008

6.0445

0.0008

Template processing

0.0028

19.9334

0.0028

Override

Cache load

0.0006

4.0732

0.0006

General

dbfile

0.0003

2.0023

0.0000

String conversion

0.0000

0.0360

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	pagelayout.tpl	<No override>	extension/sevenx/design/simple/templates/pagelayout.tpl
Number of times templates used: 1 Number of unique templates used: 1

Usage

Requested template

Template

Template loaded

Edit

Override

pagelayout.tpl

<No override>

extension/sevenx/design/simple/templates/pagelayout.tpl

Number of times templates used: 1
Number of unique templates used: 1

Time used to render debug report: 0.0001 secs