Hello I have been really loving hibernate. My only problem now is I need to filter a collection/set that belongs to a parent class. The parent class has a set of child objects that need to be filtered based on another table. The problem is the <filter> tags have a condition statement that seems to only work with fields within the child table, not a table that joins with it. So is it possible to filter objects in a collection by declaring it as a list instead of a set and using the index function on the collection ?

You can use a subselect in the filter condition.

Ok awesome um the only problem is I have been having difficulty with getting the subselect to work with the set. what is the syntax?


<set name="tireProducts" lazy="false" inverse="true" >
<subselect>select id,prod_id from ModelYearProduct myp</subselect>

<key column="tire_model"/>

<one-to-many class="com.tiresport.dataobject.TireProductDO" />

<filter name="makeYearVehicleFilter"
condition="tireproduc0_.prod_id = myp.prod_id and
myp.id = :makeYearVehicleParam"/>
</set>



If you see my subselect I need the id field from the ModelYearProduct table which joins with the child TireProduct table through the prod_id field. That id field represents a make, year and vehicle pair that links with a product.

When I tried fetching the set it had a problem because the subselect wasn't being called and it couldn't find the alias 'myp'.