Ordering using fields from multiple objects

From: Fredrik Liden (flide..ranslate.com)
Date: Wed Dec 05 2007 - 15:06:17 EST

  • Next message: Robert Zeigler: "Re: Ordering using fields from multiple objects"

    Hi,

    Does anyone have any advice on how to order on fields that span more
    than one table? If I have

    Object1
    Field1
    Field2
    object2 [reference to 1 object 2]

    Object2
    Field1
    Field2

    I'm retrieving a list of Object 1 objects but I would like sort on the
    fields in Object 2 as well.

    Is there any chance that the following would work?

    orderings.add(new Ordering("object2.Field", true));

    Or do I need to create a raw sql query?

    Thanks,

    Fredrik

    This archive was generated by hypermail 2.0.0 : Wed Dec 05 2007 - 15:07:11 EST