Sorting "sub" criteria

grantstoltz · **Joined:** Tue May 27, 2008 4:13 pm **Posts:** 1

i am pulling information from two tables. i have the two tables joined and now i need to sort first based off of an integer in "table2" and then by an integer in "table1". the following code works for me, but there is no sorting involved. any help would be appreciated.

Code:

return getSession().createCriteria(getModelClass())
      .setFetchMode("adapterInstances", FetchMode.JOIN)
      .setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY)
      .list();

Cameron McKenzie · **Posted:** Wed May 28, 2008 9:45 am

Why not just throw in a few Order commands.

Quote:

An Order object is created by using one of the two static methods in the Order class, namely the static asc(String) and desc(String) methods. Basically, you just chose whether you want your list to be sorted in ascending order, or descending order, and pass to the appropriate method the name of the field on which you want to sort.

Order order = Order.asc("loginName");