<![CDATA[
select
t.collect_handledate as handledate,
t.collect_batchno as batchno,
t.collect_customerno as customerno,
t.collect_handleno as handleno,
t.collect_relatedjnlno as relatedjnlno,
t.collect_companyid as companyid,
t.collect_amount as amount,
t.collect_mode as collectMode,
t.collect_currency as currency,
t.collect_acno as acno, t.collect_status as status,
t.collect_direct as direct,
t.collect_executetimestamp as executetimestamp,
t.collect_cusrefno as cusrefno,
t.collect_submittimestamp as submittimestamp,
t.collect_usagetext as usagetext,
t.collect_responsecode as responsecode,
t.collect_authctrl as authctrl,
t.collect_filialecompanyid as filialecompanyid,
t.collect_filialeacno as filialeacno,
t1.ac_name as CollectedAccountName,
t.collect_voucherno as voucherno,
t.collect_id as id,
t.collect_voucherorgid as voucherorgid,
t.collect_seqauth,
t.collect_checkflag,
t.collect_appendeddata
from bocsh_collection_jnl t,bocsh_companyac t1
where (t.collect_filialecompanyid = t1.company_id
and t.collect_filialeacno = t1.ac_no)
]]>
<include refid="dynamicQueryEntCollectionQueueConditions" />
</select>
<sql id="dynamicQueryEntCollectionQueueConditions">
<dynamic>
<isNotEmpty prepend="and" property="BatchNo">(t.collect_batchno
= #BatchNo#)</isNotEmpty>
<isNotEmpty prepend="and" property="HandleNo">(t.collect_handleno = #HandleNo#)</isNotEmpty>
<isNotEmpty prepend="and" property="HandleNoList">
<iterate property="HandleNoList" open=" (t.collect_id in(" conjunction="," close="))">#HandleNoList[]#</iterate>
</isNotEmpty>
<isNotEmpty prepend="and" property="HandleDate">(
t.collect_handledate = #HandleDate#)</isNotEmpty>
<isNotEmpty prepend="and" property="AccountNoList">
<iterate property="AccountNoList" open=" (t.collect_acno in(" conjunction="," close=")) ">#AccountNoList[]#</iterate>
</isNotEmpty>
<isNotEmpty prepend="and" property="AccountNo">(t.collect_acno = #AccountNo#)</isNotEmpty>
<isNotEmpty prepend="and" property="CompanyID">(t.collect_companyid = #CompanyID#)</isNotEmpty>
<isNotEmpty prepend="and" property="Currency">(
t.collect_currency = #Currency#)</isNotEmpty>
<isNotEmpty prepend="and" property="CollectId">(t.collect_id = #CollectId#)</isNotEmpty>
<isNotEmpty prepend="and" property="CollectIdList">
<iterate property="CollectIdList" open=" (t.collect_id in(" conjunction="," close="))">#CollectIdList[]#</iterate>
</isNotEmpty>
<isNotEmpty prepend="and" property="Status">(t.collect_status = #Status#)</isNotEmpty>
<isNotEmpty property="StatusList">
<iterate property="StatusList" prepend="and" open="( t.collect_status in(" conjunction="," close="))">#StatusList[]#</iterate>
</isNotEmpty>
<isNotEmpty prepend="and" property="BeginDate">
<![CDATA[(t.collect_handledate >= #BeginDate#)]]>
</isNotEmpty>
<isNotEmpty prepend="and" property="EndDate">
<![CDATA[(t.collect_handledate <= #EndDate#)]]>
</isNotEmpty>
<isNotEmpty prepend="and" property="HandleDateList">
<iterate property="HandleDateList" open=" (t.collect_id in(" conjunction="," close="))">#HandleDateList[]#</iterate>
</isNotEmpty>
<isNotEmpty prepend="and" property="CollectMode">(t.collect_mode = #Mode#)</isNotEmpty>
<isNotEmpty prepend="and" property="CollectAccountNo">( t.collect_filialeacno = #CollectAccountNo#)</isNotEmpty>
<isNotEmpty prepend="and" property="CollectDirect">(t.collect_direct = #CollectDirection#)</isNotEmpty>
</dynamic>
</sql>
but after i added "(" and ")" for every sub dynamic clause,is ok!
