I have a many-to-many association mapped through an association table:

<set lazy="true" table="risk_relation" name="relatedChildRisks">
<key column="risk_parent_fk"/>
<many-to-many class="Risk"
column="risk_child_fk"/>
</set>

I want to do filtering on the collection that is based on values in the Risk class, not the risk_relation (association) table. Conceptually, the mapping might look like this:


<set lazy="true" table="risk_relation" name="relatedChildRisks">
<key column="risk_parent_fk"/>
<many-to-many class="Risk"
column="risk_child_fk"
where="type = 'SOME_TYPE_VALUE'" />
</set>

but "where" is not valid in the many-to-many element. This makes sense to me in one-to-many associations, since the where attribute in the set element will be applied to the entity table because there is no intervening join table. But for many-to-many associations I can't figure out how to get to the values of the Risk table.

Is there a way to accomplish this in the mapping so that I don't have to do it programitcally?

Thanks in advance.

Hibernate version:3.0.4

How about

Thanks very much for your reponse. I think that would work, but if I understand filters correctly, I would have to enable that filter on every session in which I wanted to load this association. That wouldn't be optimal for me, because I just want to specify a static filter that is always applied (it would cause data errors if someone forgot to enable it). But if there were some way to enable the filter declaratively, that would probably get me where I need to be.

Does that make sense?

I see your point. But the DTD does have "where" as one of the attributes on the many-to-many element. Wouldnt that work as well? Your initial query said you cant use where. Why do you say so ?

From the DTD,

Well, actually I assumed that it would have a where attribute, but then my (old) xdoclet2 complained, so I looked at the reference doc:
http://www.hibernate.org/hib_docs/v3/re ... s-ofvalues

and did not see it there. But I have to confess that I didn't go all the way to the DTD. The where attribute is there.

Thanks for responding, sorry for using up your time without doing all my research.

Caleb