Hi:

I would like some help about filtering in a set.

########################################################################
<class name="Grupo" table="GRUP">
<id name="id" type="long" column="GRUP_NU_INTERN">
<generator class="assigned"/>
</id>
...
<set name="puertos" table="ELGR">
<key column="GRUP_NU_INTERN"/>
<many-to-many column="ELGR_CO_ELEMEN_DE" class="Puerto"/>
<!-- HELP: ???Select only those with ELGR.TEPL_CO_TIEMPL = 'A' o 'B'??? -->
</set>
</class>
########################################################################
<class name="Puerto" table="ELEQ">
<id name="id" type="long" column="ELEQ_CO_INTERN">
<generator class="assigned"/>
</id>
...
<set name="grupos" table="ELGR">
<key column="ELGR_CO_ELEMEN_DE"/>
<many-to-many column="GRUP_NU_INTERN" class="Grupo"/>
</set>
</class>
########################################################################

GRUP (Grupo)
-------------------
GRUP_NU_INTERN (PK)

ELEQ (Puerto)
-------------------
ELEQ_CO_INTERN (PK)

ELGR (Grupo-Puerto)
-------------------
GRUP_NU_INTERN (PK)
TEPL_CO_TIEMPL (PK)
ELGR_CO_ELEMENT_DE (PK)

####################################

For a "group" I need "ports" with ELGR.TEPL_CO_TIEMPL = 'A' o 'B'


Thanks,

David G.

It looks like you want additional information in your join table.
This is not possible with a many-many.

You can create a normal 'one-to-many' to the join table ad a 'many-to-one' from the join table to 'port' (if I understand the domain correctly).
Maybe you can use the 'where' attribute of the set to filter the 'A'/'B' stuff

Thanks, I'll try

David G.

I worked with:

<set name="..." table="..." where="...">
<key column="..."/>
<one-to-many class="..."/>
</set>

David G.