HQL select question

xobo · **Posted:** Thu Sep 08, 2005 5:22 am

Hibernate version: 2
Hi,
Have a problem with selecting using HQL,
model:

Code:

class Accomodation {
     Employee employee ;
     Calendar date;
}

I need to get all Accomodations where for every employee is the latest date;
example: if there are two accomodation for one employee it should be one with the latest date.
So, seems that accomodations should be grouped by employee, but how to select the most latest records I don't know.

kochcp · **Posted:** Thu Sep 08, 2005 10:27 am

criteria should do it

Code:

Criteria crit = session.createCriteria(Accomodation.class);
crit.addOrder(Order.asc("date"));  //or descending, i can never remember
crit.setMaxResults(1);
Accomodation acc = (Accomodation) crit.list.iterator().next();

kochcp · **Posted:** Thu Sep 08, 2005 10:29 am

you can add more criteria to specify which employee to run it on also :)