Hibernate Community • View topic - Ordering on related object ?

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » NHibernate Users

All times are UTC - 5 hours [ DST ]

Ordering on related object ?

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

MarkC

Post subject: Ordering on related object ?

Posted: Fri Jun 06, 2008 5:40 am

Newbie

Joined: Wed May 21, 2008 9:54 am
Posts: 8

Not sure I can do this, and I can't find any documentation that says either way..

lets say we have a child that has a many to one to its parent, I want to select all children, but ordered by a property of their parent, e.g.

myOrderClause = new Order("Parent.SomeProperty", true)

Is this permissible ? or do I have to write an HQL query that joins to the parent and then do my order within that statement ?

Top

FlukeFan

Post subject:

Posted: Mon Jun 16, 2008 10:59 am

Senior

Joined: Thu Jun 21, 2007 8:03 am
Posts: 127
Location: UK

Hi MarkC,

You should be able to order by the parent column as long as you alias it.

For example:

Code:

IList<Child> children =
    session.CreateCriteria(typeof(Child))
        .CreateAlias("Parent", "Parent")
        .Add(Order.Asc("Parent.SomeProperty"))
        .List<Child>();

Regards,
Richard

Top

Page 1 of 1

[ 2 posts ]

Board index » Hibernate & Java Persistence » NHibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum