Hibernate criteria subquery

kathir_se · **Joined:** Fri Dec 12, 2008 8:59 pm **Posts:** 10

Hi,

I need to construct a subquery using hibernate critera,

am able to create criteria and add resrictions, but using subquery in criteria its confused.

i need query like this

select * from trans a where a.id in (select max(id) from trans b where a.userid=b.userid)

anyone plz suggest reg. this

mmerder · **Posted:** Wed Feb 04, 2009 4:08 am

You can create a subselect using DetachedCriteria:

Code:

  DetachedCriteria d = DetachedCriteria.forClass(Trans.class, "t2").add(Restrictions.eq("userid", "t1.userid")).setProjection(Projections.max("id"));
  session.createCriteria(Trans.class, "t1").add(Property.forName("id").in(d));

Rating is welcome. ;-)