Can you add a query restriction upon a child in a one to many association where only those matching children are returned in the result set?

We have a one-to-many from an unnormalised table to itself where the parent is a collection of properties resulting from an audit event. i.e an AuditEvent (EntityLog).



Is it possible to filter the set returned to only include AuditProperties which meet some criteria. At the moment AuditEvents are returned complete with all audit properties if only one AuditProperty matches.

Hibernate Version: 3.2.1.ga
DB: MSSQL2000
Query:

Note that the code is from a class which extends DetachedCriteria

For example:

With the following rows, I would get one audit event (expected) containing two AuditProperties (unexpected) p1 and p3.



I can post more details, but I tried to keep it simple.

Thanks,

Wayne.

I don't want to jump on a dead thread but I ran into this and could not find much about it. So this might help others down the track.

Maybe this will make a difference for you:
createAlias("propertyAudits", "pa", CriteriaSpecification.LEFT_JOIN);

Don't ask me why it just seems to work for a similar Criteria I am doing. And it will not work if you specify INNER_JOIN or leave it out - which defaults to INNER_JOIN I think.

Not the best solution as INNER_JOIN would be preferred in the Criteria I am doing but beggars can't be choosers.