how to query on a component property

christophe_grosjean · **Joined:** Fri Sep 02, 2005 10:25 am **Posts:** 5

Hi,

Using the Criteria API, I'd like to know how to query on a component property.

public AuditSegment {

private Date creationDate;
...

}

public APersistentObject {

private AuditSegment auditSegment;
}

I'd like to retrieve all APersistentObject instances that are created since 18/11/2005.

Can somebody help me ? I found no doc on that.

Thanks
Christophe

vw729 · **Joined:** Wed Aug 25, 2004 7:40 pm **Posts:** 65

How about

"form APersistentObject po where po.auditSegment.creationDate =: theDate"

and plug in the date here.

christophe_grosjean · **Joined:** Fri Sep 02, 2005 10:25 am **Posts:** 5

I already saw an example like that one. But I want to use the Criteria API... is it possible ?

hhuber · **Posted:** Tue Nov 22, 2005 10:02 am

Code:

Criteria crit = session.createCriteria( APersistentObject.class );
crit.createCriteria( "auditSegment" ).add( Restrictions.eq( "creationDate", theDate ) );
crit.list();