Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hi All,

I have two tables example Codes and Type

The Type table id is foriegn key for Codes table.

I have a grid in my Web application.I want to list the type value in my list.It is working fine but while I am trying to sort my Type column.It is sorting based on Id and not value.

Example Table Values:

codes Table:
CodeId---1,2,3,4
TypeId----2,4,1,3(Foriegn Key)

Type Table:
TypeId----1,2,3,4
Value-----Inactive,Active,Deleted,Locked


Can Some one help me on this.
Thanks in Advance.


Feroz.K

Depends on how you've mapped the types. If it's a collection without index column, you can add order-by="value asc" to the collection mapping. But if you use a indexed collection, you have to sort the values before saving.

Thanks Wolfgang for your reply,

I have used diffeent logic for sorting.

Thanks again for your help