Hi,

First of all, i'm sorry for my english, i'm spanish.

I have this mapping:

<class
name="org.jboss.portal.core.impl.role.RoleImpl"
table="jbp_roles">
<cache usage="read-write"/>
<id
name="key"
column="jbp_rid"
type="java.lang.Long">
<generator class="native">
<param name="sequence">user_seq</param>
</generator>
</id>
<property
name="name"
type="java.lang.String"
update="false"
insert="true"
column="jbp_name"
unique="true"/>
<property
name="displayName"
type="java.lang.String"
update="true"
insert="true"
column="jbp_displayname"
unique="true"/>
<set
name="users"
table="jbp_role_membership"
lazy="true"
inverse="true"
cascade="none"
sort="unsorted"
<cache usage="read-write"/>
<key column="jbp_rid"/>
<many-to-many
class="org.jboss.portal.core.impl.user.UserImpl"
column="jbp_uid"
outer-join="false"/>
</set>
</class>

This is a jboss portal's configuration file. And when i select a member and i want to view its roles i need that its roles come ordered by jbp_displayname. How could i do this editing this configuration?

Thanks in advance.

set element has an order-by attribute that is passed directly to the SQL

Then, if i write order-by="jbp_displayname asc" in the set element should get an ordered result?