Hello,

I would like to map/fetch a max date from the many side of a 1:m relationship. So when I fetched a Customer, for instance, the MAX order date for all Orders related to the Customer would be populated in a MaxOrderDate field of that Customer object.

The SQL would look like this:



Does anyone know of a way to do this without writing the HQL or SQL?

Many thanks!

I was able to do this in the declarative mapping using <property name="MaxOrderDate" formula="(select max(OrderDate) from Orders o where o.CustomerID=CustomerID)" ...

However, this requires hard-coding the db schema into the mapping which is hard to maintain. Does anyone know of another way to do it?