IBATIES 高级应用动态组合条件_ibaties option(compile)-CSDN博客

本文链接：https://blog.csdn.net/deng11342/article/details/6891738

<select id="searchApproving" parameterClass="paginator" resultClass="java.util.HashMap">
  SELECT WC.ID AS caseinstanceID, WC.PROCESSDEFINITION AS processDefinitionID, WC.VERSION AS version , WCP.STRINGVALUE AS strSUBJECT,

  to_char(flow_lostfile.submittime,'yyyy-MM-dd HH:mm:ss') as submittime,
  flow_lostfile.submitername as submitername,
  flow_lostfile.submitdivision as submitdivision,
  flow_lostfile.submitdept as submitdept

  FROM WF_CASEINSTANCE WC, WF_CONTEXTPROPERTY WCP, flow_lostfile flow_lostfile ,
  (SELECT DISTINCT(WW.CASEINSTANCE) FROM WF_WORKITEM WW WHERE WW.ACTUALDEALUSERNAME = #paramDto.userId:VARCHAR# OR WW.CHARGECONDITIONVALUE = #paramDto.userId:VARCHAR#)WFC
  WHERE 1=1
  <dynamic prepend="AND" open="(" close=")">

    <isNotEmpty prepend="$paramDto.dfs_lianjie$" property="paramDto.dfs_submitername" >
               FLOW_LOSTFILE.SUBMITERNAME LIKE '%'||#paramDto.dfs_submitername#||'%'
             </isNotEmpty>
             <isNotEmpty prepend="$paramDto.dfs_lianjie$" property="paramDto.dfs_submitdivision" >
               FLOW_LOSTFILE.SUBMITDIVISION = #paramDto.dfs_submitdivision#
             </isNotEmpty>
             <isNotEmpty prepend="$paramDto.dfs_lianjie$" property="paramDto.dfs_lostman" >
               FLOW_LOSTFILE.LOSTMAN LIKE '%'||#paramDto.dfs_lostman#||'%'
             </isNotEmpty>
             <isNotEmpty prepend="$paramDto.dfs_lianjie$" property="paramDto.dfs_lostdept" >
               FLOW_LOSTFILE.LOSTDEPT = #paramDto.dfs_lostdept#
             </isNotEmpty>

         <isNotEmpty prepend="$paramDto.dfs_lianjie$" property="paramDto.dfs_begintime" >
               FLOW_LOSTFILE.SUBMITTIME <![CDATA[ >= ]]> to_date(#paramDto.dfs_begintime#,'yyyy-MM-dd')
             </isNotEmpty>
             <isNotEmpty prepend="$paramDto.dfs_lianjie$" property="paramDto.dfs_endtime" >
               FLOW_LOSTFILE.SUBMITTIME <![CDATA[ <= ]]> to_date(#paramDto.dfs_endtime#,'yyyy-MM-dd')
             </isNotEmpty>

  </dynamic>
  AND WFC.CASEINSTANCE = WC.ID AND flow_lostfile.CASEINSTANCEID = WC.ID
  AND WC.STATUS = 'New'
  AND WC.ID = WCP.CASEINSTANCE AND WCP.ID = 'strSubject'
</select>