What is the syntax to to specify a sort on many-to-many collections.
I have a many-to-many collection like this:
<bag name="organizations" table="claim_user_orgs" lazy="true" >
<key column="claim_user_id" />
<many-to-many class="CID.IPath.NewBusinessLayer.organization, CID.IPath.NewBusinessLayer" column="organization_id" />
</bag>
where claim_user_orgs is an association table, and just has 2 columns: claim_user_id and organization_id. I want the collection "organizations" be returned sorted by a column in the organization table, and I would like the sort to happen in the database.
|