Criteria query for a collection based on a value in the coll

rtarar · **Joined:** Thu May 26, 2005 1:04 pm **Posts:** 13

I am trying to implement criteria query for a search results for an application.This is pretty trivial when using HQL but I am not able to do the same in criteria queries.

Any help would be greatly appreciated.

How do I write criteria query for this????

Code:

Class A{
    Collection colB

}
Class B {
    Object A
    Date date
}

What I want to do is

Code:

(select a from A inner join B b where b.date = (select max(date) from B where b.a = a)))

rtarar · **Joined:** Thu May 26, 2005 1:04 pm **Posts:** 13

rtarar wrote:

I am trying to implement criteria query for a search results for an application.This is pretty trivial when using HQL but I am not able to do the same in criteria queries.

Any help would be greatly appreciated.

How do I write criteria query for this????

Code:

Class A{
    Collection colB

}
Class B {
    Object A
    Date date
}

What I want to do is

Code:

(select a from A inner join B b where b.date = (select max(date) from B where b.a = a)))

Error in the prev query... read this instead
(select a from A as a inner join B as b where b.date = (select max(date) from B where b.a = a)))

chrigi · **Joined:** Sat Jul 23, 2005 8:31 am **Posts:** 18

the following code should work more or less.

DetachedCriteria maxDate = DetachedCriteria.forClass(B.class)
.setProjection( Property.forName("date").max() );

session.createCriteria(A.class)
.createCriteria("colB", "b")
.add( Property.forName("b.date").eq(maxDate) );