<?xml version='1.0' encoding='windows-1252' ?>
<!DOCTYPE ViewObject SYSTEM "jbo_03_01.dtd">

<ViewObject
   Name="StaffListByEmailNameRole"
   Extends="oracle.srdemo.model.queries.StaffList"
   Where="USER_ROLE IN (&#39;technician&#39;,&#39;manager&#39;) AND USER_ROLE LIKE LOWER(:Role)||&#39;%&#39; AND EMAIL LIKE LOWER(REPLACE(:EmailAddress,&#39;*&#39;,&#39;%&#39;))||&#39;%&#39; AND UPPER(FIRST_NAME) LIKE UPPER(REPLACE(:TheFirstName,&#39;*&#39;,&#39;%&#39;))||&#39;%&#39; AND UPPER(LAST_NAME) LIKE UPPER(REPLACE(:TheLastName,&#39;*&#39;,&#39;%&#39;))||&#39;%&#39;"
   OrderBy="last_name, first_name"
   BindingStyle="OracleName"
   CustomQuery="false"
   ComponentClass="oracle.srdemo.model.queries.StaffListByEmailNameRoleImpl"
   MsgBundleClass="oracle.srdemo.model.queries.common.StaffListByEmailNameRoleRowImplMsgBundle"
   ComponentInterface="oracle.srdemo.model.queries.common.StaffListByEmailNameRole"
   ClientProxyName="oracle.srdemo.model.queries.client.StaffListByEmailNameRoleClient"
   FetchMode="FETCH_AS_NEEDED"
   UseGlueCode="false" >
   <DesignTime>
      <Attr Name="_version" Value="10.1.3.36.73" />
      <Attr Name="_codeGenFlag2" Value="Access|Coll|Msg|VarAccess" />
   </DesignTime>
   <Variable
      Name="EmailAddress"
      Kind="where"
      Type="java.lang.String" >
   </Variable>
   <Variable
      Name="Role"
      Kind="where"
      Type="java.lang.String" >
   </Variable>
   <Variable
      Name="TheFirstName"
      Kind="where"
      Type="java.lang.String" >
   </Variable>
   <Variable
      Name="TheLastName"
      Kind="where"
      Type="java.lang.String" >
   </Variable>
</ViewObject>
