Hi, It was already proposed in CAY-477 [1]. You can take a look at that patch and apply it locally to have orderings for relationships.
[1] https://issues.apache.org/jira/browse/CAY-477 2010/7/28 frigo <[email protected]> > Thank You for the answer, right know this is the way I do it, but is also > exactly what I want to avoid. I want to let the database do all the > ordering > stuff. > > On Wed, Jul 28, 2010 at 9:03 PM, Michael Gentry <[email protected] > >wrote: > > > It is fairly easy to create a cover method to sort them. For example, > > if you have a Department ->> Person to-many relationship, you can do > > something like this in your Department.java: > > > > public List<Person> getOrderedPersons() > > { > > List<Ordering> orderings = new ArrayList<Ordering>(); > > > > orderings.add(new Ordering(Person.LAST_NAME_PROPERTY, > > SortOrder.ASCENDING)); > > orderings.add(new Ordering(Person.FIRST_NAME_PROPERTY, > > SortOrder.ASCENDING)); > > > > List<Person> results = new ArrayList<Person>(getPersons()); > > > > Ordering.orderList(results, orderings); > > > > return results; > > } > > > > mrg > > > > > > On Wed, Jul 28, 2010 at 2:46 PM, frigo <[email protected]> > wrote: > > > Hi! > > > > > > My problem/question is pretty simple, but somehow I didn't manage to > find > > > the answer to it anywhere. > > > I have a to many relation in my data model, the result of which is > stored > > in > > > a List on the java side. > > > > > > I want to make sure that the objects in this List are ordered by a > > specific > > > attribute(column) of the other table? How can I do that without having > to > > > sort the List every time I get them? I want to see an "ORDER BY > > <something>" > > > at the end of the automatic query! > > > > > > I know how to use ordering in SelectQuery-s, but I want ordering when I > > call > > > one of the automatically generated List<Something> getSomethings(); > > methods. > > > > > > Thanks for you hel! Sorry if the answer is just obvious and is in the > > second > > > line of the documentation :)! > > > > > > -- Andrey
