I need to search for an entity that has a composite key but only by one of its keys. How do I do this?

Here is my mapping:

<hibernate-mapping>
<class name="database.entity.Title" table="VTITLE">
<composite-id name="id" class="database.entity.TitleId">
<key-property name="ltbDistrictCd" type="string">
<column name="LTB_DISTRICT_CD" length="2"/>
</key-property>
<key-property name="titleNmbr" type="string">
<column name="TITLE_NMBR" length="11"/>
</key-property>
</composite-id>
<property name="dcmntDistrictCd" type="string">
<column name="DCMNT_DISTRICT_CD" length="2" not-null="true"/>
</property>

...
</hibernate-mapping>


I'm trying to do a search in the DB by only "titleNmbr". How do I do this when my "id" is in a separate class (TitleID)??

Regards!

-Jon

Nevermind I just figured it out. Easy.

To reference the column you want to restrict on you need to put in its fully qualified name.

In the case of mine it would be ...Restriction.eq("id.titleNmbr")...

:)