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 <mgentr..asslight.net>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 <pratser.frigye..mail.com> 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 :)!
> >
>
This archive was generated by hypermail 2.0.0 : Wed Jul 28 2010 - 19:23:35 UTC