ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From kiran vuppla <kirankumar_vup...@yahoo.com>
Subject pass parameters to from one select to other select statement
Date Mon, 18 Aug 2008 21:45:47 GMT
 
Can some one please let me know how to pass the "map" set of parameters from one select to
the another select that is provided in the first ResultMap?
 
<resultMap id="DistributionResult" class="Distribution">
 <result property="totalProducts" column="TOTAL_PRODUCTS"/>
 <result property="totalAmt" column="TOTAL_AMT"/>
 <result property="merchant.id"  column="TERM_ID"/> 
 <result property="max" column="{merchantId = TERM_ID}" select="merchant.getMaxValue"/>
</resultMap>
 
<select id="getDistribution" parameterClass="map" resultMap="DistributionResult">
SELECT COUNT(*) as TOTAL_PRODUCTS
    , SUM(a.amount) as TOTAL_AMT
    , A.TERMID as TERM_ID
       FROM tbl a, tbl b
       WHERE a.termid = b.id  
       <iterate property="merchants" open=" and a.SATHCDHACCTKEY in (" close = ")"
conjunction=","> 
       #merchants[]# 
      </iterate>
AND a.dtathdate BETWEEN #startDate# AND #endDate# group by A.TERMID 
</select>
 
I want to use the same "map" from the above select statement
 
<select id="getMaxVALue" resultClass="string">
SELECT MAX(subTbl.cnt1) as MAX_VALUE from (SELECT COUNT(A.KEY ) as cnt1
FROM ath a, merchantterminal m WHERE A.SATHTERMID = M.LID and M.LID = #merchantId# 
 <iterate property="merchants" open=" and a.KEY in (" close = ")" conjunction=",">

       #merchants[]# 
      </iterate>
AND a.dtathdate BETWEEN #startDate# AND #endDate# group by to_char(a.dtathdate,'YYYYMMDD')
) subTbl
</select>
 
Thanks
KV


      
Mime
View raw message