6.0.0-alpha10
5/14/25

[#14782] support sort option for RDO objects
Summary support sort option for RDO objects
Queue Horde Framework Packages
Type Enhancement
State Accepted
Priority 1. Low
Owners
Requester birnbacs (at) gmail (dot) com
Created 02/19/2018 (2641 days ago)
Due 02/28/2018 (2632 days ago)
Updated 03/02/2018 (2630 days ago)
Assigned
Resolved
Milestone
Patch No

History
03/02/2018 04:32:31 PM Jan Schneider State ⇒ Accepted
 
02/19/2018 07:40:50 AM birnbacs (at) gmail (dot) com Comment #1
State ⇒ New
Priority ⇒ 1. Low
Type ⇒ Enhancement
Summary ⇒ support sort option for RDO objects
Due ⇒ 02/28/2018
Queue ⇒ Horde Framework Packages
Milestone ⇒
Patch ⇒ No
Reply to this comment
Horde RDO permits to define relationships over different db tables and 
makes access easy. With a ONE:MANY relationship between data types A 
and B, accessing a B from a given A is as easy as A->B[i].

In some cases it is desirable to have the returned multitude of B 
objects in a predetermined order. For instance, elements B might each 
have an element x and A->B could return the collection of elements B 
sorted by x in descending order:

A->B[0]->x > A->B[1]->x > A->B[2]->x ...

Ralf Lang suggested in the dev mailinglist  that this could be 
implemented through the mapper or in the Rdo_Query object. He details 
that eager relations are implemented as joins while lazy relations are 
essentially an automated way to implement the above. So the requested 
feature would require two implementations.

It seems to me that in both variants the sorting should be done on the 
DB side to avoid unnecessary overhead.

Saved Queries