Hi, it looks like the optional "WHERE" attribute in Class mapping is ignored if this Class is used as a collection. In this case the "WHERE" attribute should be also added to the Collection mapping as well:
Code:
<map name="States" >
<key column="CountryID" />
<index column="Name" type="String"/>
<one-to-many class="d001.State, d001" />
</map>
... would ignore any "where" attributes if present in State class mapping.
Code:
<map name="States" where="active=1">
<key column="CountryID" />
<index column="Name" type="String"/>
<one-to-many class="d001.State, d001" />
</map>
... would work fine.
So some parts of the class mapping for State are ignored in this case? Is it a feature or a bug?