HAVING using Criteria

FritFrut · **Joined:** Mon Apr 24, 2006 1:43 pm **Posts:** 22

Is it possible to generate HAVING using Criteria API? Something like this

Code:

Select ShopperId,
 Sum(Total) as STotal,
 Min(Date) as MinDate
From Orders
 Group by ShopperId,
 HAVING Sum(Total) < 10000
 And Min(Date) > '2007-01-01'

Thanks in advance, Tom

batmat · **Posted:** Fri Mar 23, 2007 1:07 pm

Having is not yet available in the Criteria API (see Java Persistence with Hibernate book, page 678).

Without the having part, it would be something like:

Code:

getSession().createCriteria(Orders.class).setProjection(Projections.projectionList().
            add(Projections.sum("total")).
            add(Projections.min("date")));

Sorry :)

FritFrut · **Joined:** Mon Apr 24, 2006 1:43 pm **Posts:** 22

I thought so... too bad. Thanks for the reply

Tom