Hello,
i would need to know if there is any way how to specify OrderBy clause for certain table, where the attribute to be used for sorting is an attribute of a dependent table.
Better would be to give an example. Lets have a db table Task with column priority_id. The column priority_id is filled from a table Priorities (it is a lookup table with 2 columns - id, title). There is of course defined relationship between these 2 tables in Hibernate.
And now when fetching records from the Task table i need to sort them by their priority, but not by the priority_id attribute. I need to use title column of the Priorities table for sorting.
I can't alter the data of the Priorities table, that the order of ids will correspond to the order of titles.

I'm new to Hibernate, so I hope this is not a silly question.

thanx for any hep

You could do that by using a criteria query and using a Alias for your priority association.
I suppose your TaskClass looks like that...
public class Task{
Long id;
Priority priority;
....
}
public class Priority{
Long id;
String title;
....
}






I'm not sure whether you need the alias, in this case of association I guess you can do it without. I like to use the alias in this kind of queries.....


simon

thanx a lot, that helped in the case which i described.
But it doesn't work in the case of more deep references e.g. over one table.

Example:
Table Task and dependent table Participant and its dependent table UserRole.
And now i want to display all tasks also with the atribute roleName (column of the UserRole table) and sort by this attribute. Is it possible to do so with the same or similar technique? I was not sucessfull with that...

thanx for any hint

Ok, I guess I know what you wanna do, the following code does sort the result by the roleName attribtue you described above.




yours simon