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 :)! > > >
