Hi,

I have 2 tables named Forms and FormPages. Forms have one to many relationship to FormPages table. The Forms entity can have multiple FormPages entities in it. I need to retrieve all Forms with the FormPages sorted by a key in the FormPages table named Pageorder . I have written the following code for that:

List formslist =HibernateUtil.getCurrentSession().createCriteria(Forms.class)

.createAlias("formpageses","formpages")

.addOrder(Order.asc("formpages.Pageorder"))
.setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY)

.list();


But this doesn’t sort the Formpages collection based on the Pageorder field in Formpages.

Does anyone know how to do this?

Thanks in advance

Jency

The ResultTransformer will break the collection sorting. Think about the resultset from the query (sorted on B.COL_D):

When the ResultTransformer(DISTINCT_ROOT_ENTITY) is used, it will only return A entities, the collections will be unfiltered and unsorted:

In short, use the ALIAS_TO_ENTITY_MAP ResultTransformer. It's more of a pain to work with, but it will get you what you want.