Ordering by Nested properties Criteria API

kevin.leahy@drkw.com · **Joined:** Fri Aug 12, 2005 12:13 pm **Posts:** 5

Hi

Has anyone successfully ordered by properties in associated objects? I can't find any reference in the documentation.

E.g. Suppose I have objects Company and Director and I want to order Company objects by Director.surname.

Thanks

Kevin

kochcp · **Posted:** Thu Dec 08, 2005 12:02 pm

there is no reason that it wouldn't work. criteria generates a sql statement just like hql.

kevin.leahy@drkw.com · **Joined:** Fri Aug 12, 2005 12:13 pm **Posts:** 5

I tried it using dot notation which is how I would have expected it to be implemented and it didn't work.
E.g. I have objects A, B.
A has a B called 'b'. B has a property called 'name'.
I tried criteria.addOrder(Order.asc("b.name")). Hibernate complains that it can't find the property b.name.
It's works using properties of A so for example:
criteria.addOrder(Order.asc("somePropertyName")) works fine.
I really want to know if this is possible in Hibernate and then has anyone seen this documented anywhere or has an example so I can get the syntax right.
Thanks
Kevin

cosmin · **Joined:** Fri Nov 25, 2005 12:26 pm **Posts:** 4

I belive u're asking the same thing i'm asking in a thread arround here .

Can anybody shed any light on this ? can it be done or not ?

I was also unable to find anything in the docs about it , but it looks like a big limitation if it couldn't be done ... i'm hoping that i've just missed it

kochcp · **Posted:** Thu Dec 08, 2005 12:52 pm

This will do it!

Code:

Criteria j = session.createCriteria(A.class).createCriteria("b").addOrder(Order.asc("name"));

you have to tell hibernate to look in that class for the property :)

note, make sure to use the attribute name (how it exists in class A) for the second createCriteria, not the class name.

kevin.leahy@drkw.com · **Joined:** Fri Aug 12, 2005 12:13 pm **Posts:** 5

Ahhh. That makes sense. Thank heavens for the forum! Many thanks. Kevin