Hi,
I am trying to add a restriction based upon a property of the first element in a collection, comparing it to a list of values. I've tried expressing this a number of ways with the Criteria API, but I haven't yet figured out how to correctly specify the property to apply the restriction to. Essentially what I want to do is this:
Code:
Criteria criteria = session.createCriteria(MyEntity.class);
criteria.add(Restrictions.in("collection[0].property.id", CollectionOfIds));
Where CollectionOfIds is just a Collection containing ID's that should match the restriction's property.
Anyone know how to achieve this using the Criteria API?
Tim