how to map collection using subselect?

quentincompson · **Joined:** Tue Jun 06, 2006 11:20 am **Posts:** 2

the subselect does not seem to work in the part of this mapping. i think i may have misunderstood how to use this attribute.

Code:

<set name="foo" inverse="true" order-by="DBID" batch-size="30"  subselect=" where MOD(SOMECOL,5)=0 " >
<key> <column name="SOMEID" precision="22" scale="0" not-null="true" /></key><one-to-many class="Entity" /></set>

georgef · **Joined:** Fri Jun 02, 2006 1:23 am **Posts:** 27

Instead of using the "subselect" attribute, which i don't see in the docs, try the "where" clause.

Quote:

where (optional) specify an arbitrary SQL WHERE condition to be used when retrieving or removing the collection (useful if the collection should contain only a subset of the available data)

So it should be like,

Code:

quentincompson · **Joined:** Tue Jun 06, 2006 11:20 am **Posts:** 2

yup that was it.

georgef wrote:

Instead of using the "subselect" attribute, which i don't see in the docs, try the "where" clause.

Quote:

where (optional) specify an arbitrary SQL WHERE condition to be used when retrieving or removing the collection (useful if the collection should contain only a subset of the available data)

So it should be like,

Code: