Hibernate Community • View topic

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

criteria and sort

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

*alexandre*

Post subject: criteria and sort

Posted: Sun Sep 21, 2008 3:06 pm

Beginner

Joined: Tue Jun 06, 2006 3:37 am
Posts: 29

Hi,

I would like to know if it's possible to sort a result from a criteria based on many to many relation (and normal column)

like I've an Affaire entity that contain representants
and I would like to sort (or order I think it's similar) like this way

Criteria.addOrder("participants.name")

Thanks in advance

Top

*alexandre*

Post subject:

Posted: Mon Sep 22, 2008 2:35 am

Beginner

Joined: Tue Jun 06, 2006 3:37 am
Posts: 29

I'v tryed to create an alias for the collection

Code:

Criteria criteria = session.createCriteria(Affaire.class);
      criteria.createAlias("requerants", "affaire_requerant", CriteriaSpecification.LEFT_JOIN);
      criteria.addOrder(Order.desc("affaire_requerant.libelleFr"));

but I got the following exception