Hibernate Community • View topic - order by for one to many relationship

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

order by for one to many relationship

Page 1 of 1

[ 4 posts ]

Previous topic | Next topic

Author

Message

subhashini2000

Post subject: order by for one to many relationship

Posted: Tue Jan 04, 2005 4:10 pm

Newbie

Joined: Tue Jan 04, 2005 2:46 pm
Posts: 5

Hibernate version:
2.1.7

I have a scenario where B has zero to many relationship with A.

How do I retrieve list of A sorted by a column/field (other than the associated id column) on B?

Thanks.

Top

drj

Post subject:

Posted: Tue Jan 04, 2005 6:13 pm

Expert

Joined: Fri Nov 07, 2003 4:24 am
Posts: 315
Location: Cape Town, South Africa

Code:

session.createQuery("from A where A.B = x order by A.y").list();

Top

subhashini2000

Post subject:

Posted: Tue Jan 04, 2005 8:11 pm

Newbie

Joined: Tue Jan 04, 2005 2:46 pm
Posts: 5

Looks like the sorting you have given in the example is for a column in A. The issue that i am trying to solve requires sorting that needs to be on B's column when retrieving a list of A in a table.

Thanks.

Top

drj

Post subject:

Posted: Wed Jan 05, 2005 4:39 am

Expert

Joined: Fri Nov 07, 2003 4:24 am
Posts: 315
Location: Cape Town, South Africa

Code:

session.createQuery("from A where A.B = x order by A.B.y").list();

Top

Page 1 of 1

[ 4 posts ]

Board index » Hibernate & Java Persistence » Hibernate 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