Hibernate version: 3

This is probably an easy question - but...

I have a many-to-many relationship between Arrests & Offenses. I want to use criteria to return all Arrests which contain one or more Offenses from a list. Did that sound right? hmm - how about this. Filter a list of Arrests by whether or not they contain given Offenses? I would like to use the Criteria API as I am already using crits to filter given other criteria (and well I like this API).

Shane
ebersoless@yahoo.com

The basic way to do this with criteria would be as follows...



Integer[] ids = {ids to of offense objects to search on};

Criteria criteria = session.createCriteria(Arrest.class);
Criteria offenseCriteria = criteria.createCriteria("offenses");

offenseCriteria.add(Expression.in("id", ids);

Collection<Arrest> arrests = criteria.list();


So in translation... Return a collection of Arrest objects that that manage one or more of the offenses (related by id).

Hope that helps.

BINGO!!
thanks for the help.

Shane

One other thing I should point out...

When you set the criteria on the child element you may find that you get multiple instances of the root element (basically you'll get as many parent instances as there are children). The solution to this in criteria query is to apply a result transformer to the query:

criteria.setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY);