Hello developers,

I have an object, lets say `Parent`. In this Parent I have a lazy `Set` of `Child` objects. `Child` object has a field `ChildName`. `ChildName` has a field `name`. I would like to get `Parents` (using Criteria) and order their `Children` by their `ChildName.name`. How to do it? Mapping Set only allows to order-by column, so ie. by `Child.name`, not `Child.ChildName.name`.

Best regards,
Konrad Billewicz

You can sort elements in collection using such mapping
<set name="detailedTasks" cascade="all" lazy="true" sort="DetailedTasksComparator">
sort="class name where described comparator for Child class"
then for adding elements to collection in parent object you should use implementation of sortable collection, TreeSet in this case.

There is described well
http://www.hibernate.org/hib_docs/v3/reference/en/html/collections.html#collections-sorted

Tomorow at work I will test it, but it looks very nice. I had searched documentation previously but haven't found this chapter. Thank you for your help.

Best regards,
Konrad Billewicz