Need help with HQL query

joarobles · **Joined:** Mon Sep 13, 2010 1:08 pm **Posts:** 5

Hi people, I have a simple class, called Person, as follows:

Code:

public class Person {
    private Integer id;
    private String name;
    private List<PersonState> states;
    ...
}

And each PersonState is defined like:

Code:

public class PersonState {
    private Integer id;
    private State state;
    private Date date;
    ...
}

And State is a simple class, containing only an id and name, and I have all the mapping files configured and working.

I want to get those Persons whose last PersonState (based on it's date) has an State with id = 5 (for instance), so what would be the HQL query like? Thanks!

overmeulen · **Joined:** Fri Jan 28, 2011 11:44 am **Posts:** 117

You need to use a group by / having clause.
Something like that: ... group by ... having date = max(date)