ibatis配置文件中循环标记

<select id="searchWorkFlowListWithOperatorSql_Filter"
  parameterClass="java.util.Map" resultMap="WorkFlowListResult">
  <![CDATA[
  SELECT distinct s.*,l.name1,l.description1,l.type1,l.value1,l.name2,l.description2,l.type2,l.value2,l.name3,l.description3,l.type3,l.value3,to_number(s.workflow_no) as wfno FROM adc_workflow_session s,adc_workflow_right r,adc_workflow_paramlist l,adc_workflow_out_param p where s.workflow_no=r.workflow_no and s.workflow_no=p.workflow_no and s.step=r.step and s.workflow_no=l.workflow_no(+) and s.workflow_no=r.workflow_no and s.workflow_no=l.workflow_no(+) and s.step=r.step and (s.status=1 or s.status=2 or s.status =4 )
  ]]>

  <isPropertyAvailable prepend="AND" property="activity_id">
   <iterate property="activity_id" close=")" open="("
    conjunction="or">
    s.activity_id=#activity_id[]#
   </iterate>
  </isPropertyAvailable>
  <isPropertyAvailable prepend="and" property="workflowname">
   s.name=#workflowname#
  </isPropertyAvailable>

</select>