Miscellany

  <statement id="getAlertLogList" resultMap="alertLog">
    SELECT * from alert_logging where id like '%'  
    <dynamic>
      <isNotEmpty prepend=" AND " property="tagId">
        tag_id = #tagId# 
      </isNotEmpty> 
      
      <isNotEmpty prepend=" AND " property="timestampFromOperator">
        timestamp #timestampFromOperator# 
      </isNotEmpty>       
      
      <isNotEmpty prepend=" AND " property="timestampThruOperator">
        timestamp #timestampThruOperator# 
      </isNotEmpty>       
      
      <isNotEmpty prepend=" AND " property="locationStr">
        location_str = #locationStr# 
      </isNotEmpty>

      <isNotEmpty prepend=" AND " property="categoryStr">
        category_str = #categoryStr# 
      </isNotEmpty>
      
      <isNotEmpty prepend=" AND " property="type">
        type = #type# 
      </isNotEmpty>
      
    </dynamic> 
    
    order by timestamp
    <dynamic>
      <isNotEmpty property="limit">
        limit $numberToFetch$
      </isNotEmpty>
    </dynamic>
    
  </statement>