<bag name="itemsForSale" inverse="true">
<key column="SELLER_ID"/>
<one-to-many class="Item"/>
<loader query-ref="loadItemsSoldByUser"/> <!-- Custom SQL! -->
</bag>
<sql-query name="loadItemsSoldByUser">
<load-collection alias="i" role="User.itemsForSale"/>
select
{i.*}
from
ITEM i
where
i.SELLER_ID = ?
</sql-query>
I have 2 questions about the loadItemsSoldByUser
1. "i.SELLER_ID = ?". Is the parameter passed by "<key column="SELLER_ID"/>"
2. how can I add some runtime parameters? For example, "AND i.UPDATE_TIME < ?", the parameter is available only at runtime, such as login date of the logined user.
|