ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Larry Meadors <larry.mead...@gmail.com>
Subject Re: Is there a way to construct an sqlmap that takes a List as well as another variable?
Date Fri, 29 Apr 2005 18:21:02 GMT
Make the list part of a bean or Map?

Larry


On 4/29/05, Abeyratne, Sam <sam.abeyratne@cingular.com> wrote:
> 
>  Hey All,
> 
>  Here is the scenario. My sql has an iterate tag which iterates a select 
> statement based on a list of sid values I am passing. In addition, I want to 
> pass another variable. I tried a few options such as passing a ParameterMap, 
> extra ParameterClass, etc, but haven't had any luck. I have enclosed an 
> example SQL for reference. The '$[]$' will take a list of sids. I want to be 
> able to specify another value in the where clause (i.e., ?data?). The 
> iterate with the single list works fine. I am having issues when I try to 
> introduce another variable.
> 
>  Any insight would be much appreciated.
> 
>  Thanks!
> 
> Sam
> 
>  select
> 
> interface_name as SYSTEM_NAME,
> 
> sum(backlog_val) as BACKLOG_VAL,
> 
> sum(backlog_last1) as BACKLOG_LAST1,
> 
> sum(backlog_last2) as BACKLOG_LAST2,
> 
> sum(backlog_last3) as BACKLOG_LAST3
> 
> from
> 
> (
> 
> <iterate open="(" close=")" conjunction="UNION ALL">
> 
> select
> 
> a.interface_name,
> 
> sum(decode(i.BACKLOG_VAL,'',0,i.BACKLOG_VAL)) as BACKLOG_VAL,
> 
> sum(decode(i.BACKLOG_LAST1,'',0,i.BACKLOG_LAST1)) as BACKLOG_LAST1,
> 
> sum(decode(i.BACKLOG_LAST2,'',0,i.BACKLOG_LAST2)) as BACKLOG_LAST2,
> 
> sum(decode(i.BACKLOG_LAST3,'',0,i.BACKLOG_LAST3)) as BACKLOG_LAST3
> 
> from INTERFACE_STATUS@$[]$ i,
> 
> ( select distinct interface_name
> 
> from interface@$[]$
> 
> where category=?data?
> 
> )a
> 
> where SYSTEM_NAME is not null
> 
> and a.interface_name = i.system_name
> 
> group by a.interface_name
> 
> </iterate>
> 
> )
> 
> group by interface_name
>

Mime
View raw message