Hello
I've some problem with following mapping.
My class ReportForm has a field zsr which has a relation many-to-one to a look-up table users. When I display this class I would like also to have some information from this other table. I've tried with this mapping but the result is that none of the joined properties are fetched:
Code:
<class name="ReportForm" table="report">
<id name="reportId" column="REPORT_ID"/>
<property name="zsr" column="ZSR"/>
<property name="patient" column="PATIENT"/>
<join table="users" inverse="true" optional="true">
<key column="ZSR" update="false"/>
<property name="name" column="NAME" update="false" insert="false"/>
</join>
</class>
Could you kind give me some suggestion how to do it correctly?
Thanks a lot
Patrick