Retrieving specific row in one-to-many relationship

odupuis · **Joined:** Tue Jun 19, 2007 11:34 am **Posts:** 2

I have a 1st class named ProgramsBasicInfo with 2 parameters:

int ID;

IList ExtendedInfo;
My mapping looks something like this :

Code:

<class name="ProgramsBasicInfo" table="...">
    <id name="ID" column="id">
      <generator class="assigned" />
    </id>
    <bag name="ExtendedInfo">
      <key column="id"/>
      <one-to-many class="ProgramsExtendedInfo"/>
    </bag>
  </class>

In my ProgramsExtendedInfo, I have 3 parameters:

int ID;

string Language;

string OfficialTitle;
Mapping:

Code:

<class name="ProgramsExtendedInfo" table="...">
    <id name="ID" column="id">
      <generator class="assigned" />
    </id>
    <property name="Language" column="Language"/>
    <property name="OfficialTitle" column="OfficialTitle"/>
  </class>

Every ProgramsBasicInfo is associated to 2 ProgramsExtendedInfo - 1 for each language (english and french). Depending on language selection, I'd like to be able to retrieve all ProgramsBasicInfo entries, but only those for that language. But I can't do a where clause on a ProgramsBasicInfo.ExtendedInfo.Language.

Can anyone point me to a solution for this please.

Thank you for your help
Olivier Dupuis

karlchu · **Posted:** Thu Jun 28, 2007 3:40 pm

What you need may be filters. See here:
http://www.hibernate.org/hib_docs/nhibe ... lters.html