Hi All,
I want to maintain Many-to-Many relationship in between Role and menu table, for that I am using association table "ROLE_MENU_ASSOC", in this table I have "active_yn" column, if I want to assign filter on this column like "active_yn = Y". By that way I want to get active 'Y' association, How do I apply this filter on association table.
Here is my Role side mapping code,
Code:
<!-- Many-to-many relation between Role and Menu trough association table --> <set name="menuSet" table="ROLE_MENU_ASSOC" lazy="false">
<key column="GR_ID"/>
<many-to-many column="GM_ID" class="com.greenlight.testxpert.struts.framework.MenusForm"/>
</set>
<!-- associations -->
Please reply,
Thanks & Regards,
Gajendra