Hi, I'm having some problems with a query, I hope someone can lend me a hand, it's driving me nuts...

I have a model object like this:

ParentObject
..some attributes
- Collection<ChildObject> childCollection

The childCollection is mapped as a many-to-many relation with a join table. I need to retrieve the ParentObject fetching the childCollection but the childCollection must contain only certain elements depending on inner properties.

like
ChildObject.OtherEntity.property = someValue.

I've tried with filters, but I don't get it to work because of the join table of the relationship.

I'm using xml based configuration in Hibernate 3.

Thank you.