The query I am trying to get to work is

select r
from QuoteRequest r
where r.coverSheet.actions['Provider_In'].parameter.stringValue = '123456'

that is - each QuoteRequest has a coversheet component which has a Map called actions whose values are the parameters i am interested in

here is the mapping


<component name="coverSheet" class="com.lab.model.quote.CoverSheet">
<parent name="quoteRequest"/>
<component name="statusCode" class="com.lab.model.StatusCode">
<property name="code" column="status_code"/>
</component>
<property name="notes" column="notes"/>
<property name="lastStatusChangeTime" type="timestamp" column="last_status_change_time"/>
<property name="lastStatusCheckTime" type="timestamp" column="last_status_check_time"/>
<map name="actions" table="coveractions" lazy="true" cascade="delete">
<key column="request_id"/>
<index column="action_id" type="com.lab.model.coversheet.actions.CoverSheetAction"/>
<composite-element class="com.lab.model.Change">
<many-to-one name="initiator" class="com.lab.model.employee.Employee" column="employee_id" update="false"/>
<property name="timeStamp" column="timestamp" type="timestamp" update="false"/>
<nested-composite-element name="parameter" class="com.lab.common.Parameter">
<property name="stringValue" column="string_1" update="false"/>
<property name="dateValue" column="date_1" update="false"/>
<property name="booleanValue" column="boolean_1" update="false"/>
<property name="moneyValue" column="money_1" type="big_decimal" update="false"/>
</nested-composite-element>
</composite-element>
</map>
</component>

The query gives me a QueryException - illegally dereferenced collection element. The query I am after corresponds to the sql

select *
from quote_requests r
inner join coveractions c on r.id = c.request_id
and c.action_id = 1060
and c.string_1 = '123456'

what version of Hibernate? (should be 2.1beta6)

yep, its 2.1beta6

BTW the CoverSheetAction class is a PersitentEnum, can I reference that in the HQL i.e actions[CoverSheetAction.PROVIDER_IN]

ok just had a quick look at the code and this syntax is not supported for composite-elements. Use:

Brilliant! that works well except that I have to replace the string 'Provider_In' by the actions integer id. No big deal, easy enough for me to change to integer identifiers in the queries.

thanks