Hi,

I am using criteria api for search functionality in my application. I am stuck due to some sorting issues.

I have a project object which has a collection of team members. Team members are assigned different roles like Architect, Lead, Programmer, etc and presence of any role is not mandatory. A project may or may not have team members.

In search results I am displaying the Architect's name (if any) along with other properties of project. Now I want to sort the result (list of project objects) on the basis of Architect's name.

I think I can achieve this through HQL but I would like to do this using criteria api. I'll appreciate any help.

thanks
rohit

try this,

List projectList = session.createCriteria(Project.class)
.createAlias("tblMember","member")
.addOrder(Order.asc("member.name")).list()


if not working, post with ur mappings and xml files


thanks

thanks for reponse.

This will not work for following reasons:

1. A project may or may not have team members, hence the join need to be a outer join (which I think is possible to create after a bug fix in 3.1).

2. I need to sort results on the basis of Architect's name and a project's team will have members other than Architect. Solution will sort the result on the basis of name of all members.


thanks
rohit

can u post with table desc(with sample records) and
sample result u like to have ?