I am trying to use a Criteria object to order a list of data. I tried to create a associated criteria but that didnt work. I am trying to get a list of Select * from someclass order by max (someotherclass.property) desc. Any hints would be greatly appreciated. The sql that I am getting is not even close. I am sure this is possible I just dont have the knowledge yet to do it.


Here is the mapping for the parent:
<class name="namespace.someClass" table="SomeTable">
<id name="id" type="long" column="ID">
<generator class="identity" />
</id>
<property name="caseID" column="CASEID" type="string" />
<set name="events" cascade="all" inverse="true" lazy="false"
order-by="ID asc" batch-size="1" outer-join="auto">
<key column="RFR_ID" />
<one-to-many class="someotherClass" />
</set>
</class>

Thanks
Heath

hi,

in hbm.xml file after </class>, add
<query name="queryName">
<![CDATA[
from someClass reference order by reference.propertyName asc
] ]>
</query>
</hibernate-mapping>

here someClass="your pojo class"
reference="any name"
propertyName="valid propertyName",

getting List-->
List<someClass> someList=(SomeClass)session.getNamedQuery("queryName").list();


if it useful dont forget to rateme

regars,

The problem with that solution is that I am trying to use only the Criteria object.

hi

use this

List<someClass> someList=(SomeClass)session.createCriteria(someClassName.Class).addOrder(Order.desc(propertyNameString));

hope your problem solved.

regards,

Actually to solve this problem, you would need a subquery in your orderBy-Part, which is not possible using criteria.

If you still want to stick with criteria, you could do something like that:


This is not a really efficient solution, since it makes a join and iterates the whole resultset to get the distinct someClass-objects. Maybe anybody knows a better solution using criteria?

I incidentally found a JIRA-issue, which helps solving this problem.

So you can use this subclass of order to define a custom order. The big disadvantage with this solution is, that you have to know the sql-column- and table-names.