Hey, I have a quick question about sortorder when using building a query using criterias.

I have an Hoering object with an Hoeringstype object and I would like to sort the Hoering's by the Hoeringstype.name property. Is this possible ?
I've tried to do an addOrder(Order.asc("hoeringstype.name")) to my criteria, but that throws an
org.hibernate.QueryException: could not resolve property: hoeringstype.name of: com.nnit.hoeringsportal.domain.Hoering

If I just addOrder(Order.asc("hoeringstype")) then I get the results sorted by the foreign key (and my Hoeringstype isnt in alphabetical order in the database because the user can create new types on the fly).

Is there another way to set the order of my Criteria to achieve this ?

/Steen

heh, never mind...that will teach me to search the forums more throughly first...its been covered a few times already.

create an alias and order by that one instead....

/Steen

It's annoying though, isn't it?

Please have a look on this thread and my proposed fix.

Regards
Joerg