cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Michael Gentry <>
Subject Re: Sorting of to many relation Lists
Date Wed, 28 Jul 2010 19:03:05 GMT
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

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,

    List<Person> results = new ArrayList<Person>(getPersons());

    Ordering.orderList(results, orderings);

    return results;


On Wed, Jul 28, 2010 at 2:46 PM, frigo <> 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 :)!

View raw message