Untitled

  <statement id="getList" resultMap="woResultsWithStrings">
    select distinct 
    concat(user_info.first_name, ' ', user_info.last_name) as assigned_to_user_str,
    suppliers.company_name as assigned_to_supplier_str,
    tag.mnemonic as mnemonic, 
    tag_categories.name as category_str, 
    locations.name as location_str, 
    workorder.* 
    from tag_categories, locations, tag, workorder   
    left join user_info on workorder.assigned_to_user = user_info.id 
    left join suppliers on workorder.assigned_to_supplier = suppliers.supplier_id 
    where 
    workorder.category = tag_categories.id and 
    workorder.location = locations.id and
    tag.tag_id = workorder.tag_id
    
    <dynamic>
      <isNotEmpty prepend=" AND " property="tagId"> 
        workorder.tag_id = #tagId#     
      </isNotEmpty>  
      <isNotEmpty prepend=" AND " property="dateCompletedOperator">
        workorder.date_completed $dateCompletedOperator$ <!-- #dateCompleted# -->
      </isNotEmpty>
      <isNotEmpty prepend=" AND " property="dateCompleted"> 
        date_completed = #dateCompleted# 
      </isNotEmpty> 
      <isNotEmpty prepend=" AND " property="prevMaintOperator">
        workorder.prev_maint  $prevMaintOperator$ 
      </isNotEmpty> 
      
      <isGreaterThan prepend=" AND " property="location" compareValue="0"> 
        workorder.location = #location# 
      </isGreaterThan> 
      
      <isGreaterThan prepend=" AND " property="category" compareValue="0"> 
        workorder.category = #category# 
      </isGreaterThan>       
      

      <isNotEmpty prepend=" AND " property="assignedToUser"> 
        assigned_to_user = #assignedToUser#     
      </isNotEmpty>    
      <isNotEmpty prepend=" AND " property="assignedToSupplier"> 
        assigned_to_supplier = #assignedToSupplier# 
      </isNotEmpty>
      <isNotEmpty property="orderBy">
        order by #orderBy# desc
      </isNotEmpty>      
    </dynamic> 
    
  </statement>