I have a class with a couple of collections..

public class Project
private List<Organisation> organisations;
private List<Person> contacts;

And in a certain case, I'd like to return all Projects for which a supplied Organisation id matches an Organisation in the 'organisations' collection, OR for which a supplied Person ID matches a Person in the 'contacts' collection.

I can run a search on either one of these collections...

Criteria criteria = session.createCriteria(Project.class);
...
criteria.createCriteria("contacts")
.add(Restrictions.like("id", argument.getContactId()));

criteria.createCriteria("organisations")
.add(Restrictions.like("id", argument.getOrganisationId()));

.. but I can't figure out how to do an OR over the two - I'm finding the Criteria API pretty non-intuitive (no doubt it will get easier over time!)

Could anyone recommend an approach for the above ?

thanks,

matt.

Rather than createCriteria for the OR Restrictrictions use the following.



Bascially the createAlias will create a join (inner join by default) to your associations and then the disjunction will do the OR.

The brackets, etc in this above sample may be way off as I didn't compile it or anything but you should be able to get the gist.

Bear in mind that the default join for the create alias is an inner join so you might have to define an outer join type in your case.

Thanks, that helps.

I ended up with this..

criteria.createAlias("contacts", "contactsAlias");
criteria.createAlias("organisations", "organisationsAlias");

criteria.add
(Restrictions.or
((Restrictions.eq("contactsAlias.id",argument.getContactId())),
(Restrictions.eq("organisationsAlias.id", argument.getOrganisationId())) ));