cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From frigo <pratser.frig...@gmail.com>
Subject Re: Sorting of to many relation Lists
Date Wed, 28 Jul 2010 19:22:47 GMT
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 <mgentry@masslight.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.frigyes@gmail.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 :)!
> >
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message