Re: Sorting of to many relation Lists

From: Michael Gentry (mgentr..asslight.net)
Date: Wed Jul 28 2010 - 19:03:05 UTC

  • Next message: frigo: "Re: Sorting of to many relation Lists"

    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:03:56 UTC