Maybe, since you've resolved the error with userid you should now change
all your properties in the same manner. Did I mention in my last note
that capital first letters are generally used as uninstantiated object
names?
Diran
Somasundaram Pitchaiah wrote:
>Hi meindert,
>I tried replacing UserId by userid in the XML file.but that didn't help.
>It still gives :
>There is no WRITEABLE property named 'DeviceId' in class
>'com.indidge.common.model.idtracksdevices.AppUser
>
>The error occurs while parsing auto generated
>XML(AppUser_SqlMap.xml).Following are the lines in that xml in the
>resultMap element:
>
><resultMap id="abatorgenerated_AppUserResult"
>class="com.indidge.common.model.idtracksdevices.AppUser">
> <result column="UserId" property="UserId" jdbcType="BIGINT" />
> <result column="FirstName" property="FirstName" jdbcType="VARCHAR" />
>
>a query in that XML;
>
><select id="abatorgenerated_selectByPrimaryKey"
>resultMap="abatorgenerated_AppUserResult"
>parameterClass="com.indidge.common.model.idtracksdevices.AppUserKey">
> select UserId, FirstName,
> from idTracksDevices.AppUser
> where UserId = #UserId#
> </select>
>
>I need to parse this XML file so as to get the DAOManager Instance.
>I have attached SQlMap.XML,AppUser classes.
>
>Expecting ur help!
>
>Thank You!
>
>Regards,
>Somu
>
>
>
>
>____________________________________________________________________
>The property is called 'userId'
>
>MEINDERT
>
>-----Original Message-----
>From: Somasundaram Pitchaiah [mailto:[EMAIL PROTECTED]
>Sent: 06 April 2006 10:53 AM
>To: user-java@ibatis.apache.org
>Cc: [EMAIL PROTECTED]
>Subject: There is no WRITEABLE property called 'UserId' in AppUser
>
>Hi Every body,
>I'm facing problem while using the auto generated SQLmap files
>generated by abator in eclipse.
>
>I'm using abator plugin for eclipse(3.1) Given a table AppUser,abator
>generates the following classes automatically:
>
>-AppUserDAO
>-AppUserImpl
>-AppUser_Sqlmap.xml
>
>I'm trying to use these classes to insert & select some values from Db
>for AppUser table.
>
>The error I get is that it gives"there is no WRITEABLE property called
>UserId in AppUser.This happens while trying to read AppUser_Sqlmap.xml.
>But I have the getter & setter method for the field 'Userid' in
>AppUser class(auto-generated).
>
> Files Attached:
>-Screenshot .doc(screenshot of the error)
>-AppUser_Sqlmap.xml
>-AppUser
>-SampleAction.java(action class)
>
>Expecting ur help!
>
>Thank you!
>
>Regards,
>Somu
>
>
>------------------------------------------------------------------------
>
>package com.indidge.common.model.idtracksdevices;
>
>import java.util.Date;
>
>public class AppUser extends AppUserKey {
>
> /**
> * This field was generated by Abator for iBATIS.
> * This field corresponds to the database column idTracksDevices.AppUser.FirstName
> *
> * @abatorgenerated Thu Apr 06 19:22:19 GMT+05:30 2006
> */
> private String FirstName;
>
> /**
> * This field was generated by Abator for iBATIS.
> * This field corresponds to the database column idTracksDevices.AppUser.MiddleInitial
> *
> * @abatorgenerated Thu Apr 06 19:22:19 GMT+05:30 2006
> */
> private String MiddleInitial;
>
> /**
> * This field was generated by Abator for iBATIS.
> * This field corresponds to the database column idTracksDevices.AppUser.LastName
> *
> * @abatorgenerated Thu Apr 06 19:22:19 GMT+05:30 2006
> */
> private String LastName;
>
> /**
> * This field was generated by Abator for iBATIS.
> * This field corresponds to the database column idTracksDevices.AppUser.EmailAddr
> *
> * @abatorgenerated Thu Apr 06 19:22:19 GMT+05:30 2006
> */
> private String EmailAddr;
>
> /**
> * This field was generated by Abator for iBATIS.
> * This field corresponds to the database column idTracksDevices.AppUser.Title
> *
> * @abatorgenerated Thu Apr 06 19:22:19 GMT+05:30 2006
> */
> private String Title;
>
> /**
> * This field was generated by Abator for iBATIS.
> * This field corresponds to the database column idTracksDevices.AppUser.Department
> *
> * @abatorgenerated Thu Apr 06 19:22:19 GMT+05:30 2006
> */
> private String Department;
>
> /**
> * This field was generated by Abator for iBATIS.
> * This field corresponds to the database column idTracksDevices.AppUser.Login
> *
> * @abatorgenerated Thu Apr 06 19:22:19 GMT+05:30 2006
> */
> private String Login;
>
> /**
> * This field was generated by Abator for iBATIS.
> * This field corresponds to the database column idTracksDevices.AppUser.Passwd
> *
> * @abatorgenerated Thu Apr 06 19:22:19 GMT+05:30 2006
> */
> private String Passwd;
>
> /**
> * This field was generated by Abator for iBATIS.
> * This field corresponds to the database column idTracksDevices.AppUser.Priv
> *
> * @abatorgenerated Thu Apr 06 19:22:19 GMT+05:30 2006
> */
> private Integer Priv;
>
> /**
> * This field was generated by Abator for iBATIS.
> * This field corresponds to the database column idTracksDevices.AppUser.Active
> *
> * @abatorgenerated Thu Apr 06 19:22:19 GMT+05:30 2006
> */
> private Short Active;
>
> /**
> * This field was generated by Abator for iBATIS.
> * This field corresponds to the database column idTracksDevices.AppUser.SystemAddUser
> *
> * @abatorgenerated Thu Apr 06 19:22:19 GMT+05:30 2006
> */
> private String SystemAddUser;
>
> /**
> * This field was generated by Abator for iBATIS.
> * This field corresponds to the database column idTracksDevices.AppUser.SystemAddDate
> *
> * @abatorgenerated Thu Apr 06 19:22:19 GMT+05:30 2006
> */
> private Date SystemAddDate;
>
> /**
> * This field was generated by Abator for iBATIS.
> * This field corresponds to the database column idTracksDevices.AppUser.LastChangeUser
> *
> * @abatorgenerated Thu Apr 06 19:22:19 GMT+05:30 2006
> */
> private String LastChangeUser;
>
> /**
> * This field was generated by Abator for iBATIS.
> * This field corresponds to the database column idTracksDevices.AppUser.LastChangeDate
> *
> * @abatorgenerated Thu Apr 06 19:22:19 GMT+05:30 2006
> */
> private Date LastChangeDate;
>
> /**
> * This method was generated by Abator for iBATIS.
> * This method returns the value of the database column idTracksDevices.AppUser.FirstName
> *
> * @return the value of idTracksDevices.AppUser.FirstName
> *
> * @abatorgenerated Thu Apr 06 19:22:19 GMT+05:30 2006
> */
> public String getFirstName() {
> return FirstName;
> }
>
> /**
> * This method was generated by Abator for iBATIS.
> * This method sets the value of the database column idTracksDevices.AppUser.FirstName
> *
> * @param FirstName the value for idTracksDevices.AppUser.FirstName
> *
> * @abatorgenerated Thu Apr 06 19:22:19 GMT+05:30 2006
> */
> public void setFirstName(String FirstName) {
> if (FirstName != null) {
> FirstName = FirstName.trim();
> }
> this.FirstName = FirstName;
> }
>
> /**
> * This method was generated by Abator for iBATIS.
> * This method returns the value of the database column idTracksDevices.AppUser.MiddleInitial
> *
> * @return the value of idTracksDevices.AppUser.MiddleInitial
> *
> * @abatorgenerated Thu Apr 06 19:22:19 GMT+05:30 2006
> */
> public String getMiddleInitial() {
> return MiddleInitial;
> }
>
> /**
> * This method was generated by Abator for iBATIS.
> * This method sets the value of the database column idTracksDevices.AppUser.MiddleInitial
> *
> * @param MiddleInitial the value for idTracksDevices.AppUser.MiddleInitial
> *
> * @abatorgenerated Thu Apr 06 19:22:19 GMT+05:30 2006
> */
> public void setMiddleInitial(String MiddleInitial) {
> if (MiddleInitial != null) {
> MiddleInitial = MiddleInitial.trim();
> }
> this.MiddleInitial = MiddleInitial;
> }
>
> /**
> * This method was generated by Abator for iBATIS.
> * This method returns the value of the database column idTracksDevices.AppUser.LastName
> *
> * @return the value of idTracksDevices.AppUser.LastName
> *
> * @abatorgenerated Thu Apr 06 19:22:19 GMT+05:30 2006
> */
> public String getLastName() {
> return LastName;
> }
>
> /**
> * This method was generated by Abator for iBATIS.
> * This method sets the value of the database column idTracksDevices.AppUser.LastName
> *
> * @param LastName the value for idTracksDevices.AppUser.LastName
> *
> * @abatorgenerated Thu Apr 06 19:22:19 GMT+05:30 2006
> */
> public void setLastName(String LastName) {
> if (LastName != null) {
> LastName = LastName.trim();
> }
> this.LastName = LastName;
> }
>
> /**
> * This method was generated by Abator for iBATIS.
> * This method returns the value of the database column idTracksDevices.AppUser.EmailAddr
> *
> * @return the value of idTracksDevices.AppUser.EmailAddr
> *
> * @abatorgenerated Thu Apr 06 19:22:19 GMT+05:30 2006
> */
> public String getEmailAddr() {
> return EmailAddr;
> }
>
> /**
> * This method was generated by Abator for iBATIS.
> * This method sets the value of the database column idTracksDevices.AppUser.EmailAddr
> *
> * @param EmailAddr the value for idTracksDevices.AppUser.EmailAddr
> *
> * @abatorgenerated Thu Apr 06 19:22:19 GMT+05:30 2006
> */
> public void setEmailAddr(String EmailAddr) {
> if (EmailAddr != null) {
> EmailAddr = EmailAddr.trim();
> }
> this.EmailAddr = EmailAddr;
> }
>
> /**
> * This method was generated by Abator for iBATIS.
> * This method returns the value of the database column idTracksDevices.AppUser.Title
> *
> * @return the value of idTracksDevices.AppUser.Title
> *
> * @abatorgenerated Thu Apr 06 19:22:19 GMT+05:30 2006
> */
> public String getTitle() {
> return Title;
> }
>
> /**
> * This method was generated by Abator for iBATIS.
> * This method sets the value of the database column idTracksDevices.AppUser.Title
> *
> * @param Title the value for idTracksDevices.AppUser.Title
> *
> * @abatorgenerated Thu Apr 06 19:22:19 GMT+05:30 2006
> */
> public void setTitle(String Title) {
> if (Title != null) {
> Title = Title.trim();
> }
> this.Title = Title;
> }
>
> /**
> * This method was generated by Abator for iBATIS.
> * This method returns the value of the database column idTracksDevices.AppUser.Department
> *
> * @return the value of idTracksDevices.AppUser.Department
> *
> * @abatorgenerated Thu Apr 06 19:22:19 GMT+05:30 2006
> */
> public String getDepartment() {
> return Department;
> }
>
> /**
> * This method was generated by Abator for iBATIS.
> * This method sets the value of the database column idTracksDevices.AppUser.Department
> *
> * @param Department the value for idTracksDevices.AppUser.Department
> *
> * @abatorgenerated Thu Apr 06 19:22:19 GMT+05:30 2006
> */
> public void setDepartment(String Department) {
> if (Department != null) {
> Department = Department.trim();
> }
> this.Department = Department;
> }
>
> /**
> * This method was generated by Abator for iBATIS.
> * This method returns the value of the database column idTracksDevices.AppUser.Login
> *
> * @return the value of idTracksDevices.AppUser.Login
> *
> * @abatorgenerated Thu Apr 06 19:22:19 GMT+05:30 2006
> */
> public String getLogin() {
> return Login;
> }
>
> /**
> * This method was generated by Abator for iBATIS.
> * This method sets the value of the database column idTracksDevices.AppUser.Login
> *
> * @param Login the value for idTracksDevices.AppUser.Login
> *
> * @abatorgenerated Thu Apr 06 19:22:19 GMT+05:30 2006
> */
> public void setLogin(String Login) {
> if (Login != null) {
> Login = Login.trim();
> }
> this.Login = Login;
> }
>
> /**
> * This method was generated by Abator for iBATIS.
> * This method returns the value of the database column idTracksDevices.AppUser.Passwd
> *
> * @return the value of idTracksDevices.AppUser.Passwd
> *
> * @abatorgenerated Thu Apr 06 19:22:19 GMT+05:30 2006
> */
> public String getPasswd() {
> return Passwd;
> }
>
> /**
> * This method was generated by Abator for iBATIS.
> * This method sets the value of the database column idTracksDevices.AppUser.Passwd
> *
> * @param Passwd the value for idTracksDevices.AppUser.Passwd
> *
> * @abatorgenerated Thu Apr 06 19:22:19 GMT+05:30 2006
> */
> public void setPasswd(String Passwd) {
> if (Passwd != null) {
> Passwd = Passwd.trim();
> }
> this.Passwd = Passwd;
> }
>
> /**
> * This method was generated by Abator for iBATIS.
> * This method returns the value of the database column idTracksDevices.AppUser.Priv
> *
> * @return the value of idTracksDevices.AppUser.Priv
> *
> * @abatorgenerated Thu Apr 06 19:22:19 GMT+05:30 2006
> */
> public Integer getPriv() {
> return Priv;
> }
>
> /**
> * This method was generated by Abator for iBATIS.
> * This method sets the value of the database column idTracksDevices.AppUser.Priv
> *
> * @param Priv the value for idTracksDevices.AppUser.Priv
> *
> * @abatorgenerated Thu Apr 06 19:22:19 GMT+05:30 2006
> */
> public void setPriv(Integer Priv) {
> this.Priv = Priv;
> }
>
> /**
> * This method was generated by Abator for iBATIS.
> * This method returns the value of the database column idTracksDevices.AppUser.Active
> *
> * @return the value of idTracksDevices.AppUser.Active
> *
> * @abatorgenerated Thu Apr 06 19:22:19 GMT+05:30 2006
> */
> public Short getActive() {
> return Active;
> }
>
> /**
> * This method was generated by Abator for iBATIS.
> * This method sets the value of the database column idTracksDevices.AppUser.Active
> *
> * @param Active the value for idTracksDevices.AppUser.Active
> *
> * @abatorgenerated Thu Apr 06 19:22:19 GMT+05:30 2006
> */
> public void setActive(Short Active) {
> this.Active = Active;
> }
>
> /**
> * This method was generated by Abator for iBATIS.
> * This method returns the value of the database column idTracksDevices.AppUser.SystemAddUser
> *
> * @return the value of idTracksDevices.AppUser.SystemAddUser
> *
> * @abatorgenerated Thu Apr 06 19:22:19 GMT+05:30 2006
> */
> public String getSystemAddUser() {
> return SystemAddUser;
> }
>
> /**
> * This method was generated by Abator for iBATIS.
> * This method sets the value of the database column idTracksDevices.AppUser.SystemAddUser
> *
> * @param SystemAddUser the value for idTracksDevices.AppUser.SystemAddUser
> *
> * @abatorgenerated Thu Apr 06 19:22:19 GMT+05:30 2006
> */
> public void setSystemAddUser(String SystemAddUser) {
> if (SystemAddUser != null) {
> SystemAddUser = SystemAddUser.trim();
> }
> this.SystemAddUser = SystemAddUser;
> }
>
> /**
> * This method was generated by Abator for iBATIS.
> * This method returns the value of the database column idTracksDevices.AppUser.SystemAddDate
> *
> * @return the value of idTracksDevices.AppUser.SystemAddDate
> *
> * @abatorgenerated Thu Apr 06 19:22:19 GMT+05:30 2006
> */
> public Date getSystemAddDate() {
> return SystemAddDate;
> }
>
> /**
> * This method was generated by Abator for iBATIS.
> * This method sets the value of the database column idTracksDevices.AppUser.SystemAddDate
> *
> * @param SystemAddDate the value for idTracksDevices.AppUser.SystemAddDate
> *
> * @abatorgenerated Thu Apr 06 19:22:19 GMT+05:30 2006
> */
> public void setSystemAddDate(Date SystemAddDate) {
> this.SystemAddDate = SystemAddDate;
> }
>
> /**
> * This method was generated by Abator for iBATIS.
> * This method returns the value of the database column idTracksDevices.AppUser.LastChangeUser
> *
> * @return the value of idTracksDevices.AppUser.LastChangeUser
> *
> * @abatorgenerated Thu Apr 06 19:22:19 GMT+05:30 2006
> */
> public String getLastChangeUser() {
> return LastChangeUser;
> }
>
> /**
> * This method was generated by Abator for iBATIS.
> * This method sets the value of the database column idTracksDevices.AppUser.LastChangeUser
> *
> * @param LastChangeUser the value for idTracksDevices.AppUser.LastChangeUser
> *
> * @abatorgenerated Thu Apr 06 19:22:19 GMT+05:30 2006
> */
> public void setLastChangeUser(String LastChangeUser) {
> if (LastChangeUser != null) {
> LastChangeUser = LastChangeUser.trim();
> }
> this.LastChangeUser = LastChangeUser;
> }
>
> /**
> * This method was generated by Abator for iBATIS.
> * This method returns the value of the database column idTracksDevices.AppUser.LastChangeDate
> *
> * @return the value of idTracksDevices.AppUser.LastChangeDate
> *
> * @abatorgenerated Thu Apr 06 19:22:19 GMT+05:30 2006
> */
> public Date getLastChangeDate() {
> return LastChangeDate;
> }
>
> /**
> * This method was generated by Abator for iBATIS.
> * This method sets the value of the database column idTracksDevices.AppUser.LastChangeDate
> *
> * @param LastChangeDate the value for idTracksDevices.AppUser.LastChangeDate
> *
> * @abatorgenerated Thu Apr 06 19:22:19 GMT+05:30 2006
> */
> public void setLastChangeDate(Date LastChangeDate) {
> this.LastChangeDate = LastChangeDate;
> }
>}
>
>
>
>------------------------------------------------------------------------
>
><?xml version="1.0" encoding="UTF-8"?>
><!DOCTYPE sqlMap PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN" "http://ibatis.apache.org/dtd/sql-map-2.dtd">
>
><sqlMap namespace="idTracksDevices_AppUser">
>
> <resultMap id="abatorgenerated_AppUserResult" class="com.indidge.common.model.idtracksdevices.AppUser">
> <!--
> WARNING - This element is automatically generated by Abator for iBATIS, do not modify.
> This element was generated on Thu Apr 06 19:22:19 GMT+05:30 2006.
> -->
> <result column="UserId" property="UserId" jdbcType="BIGINT" />
> <result column="FirstName" property="FirstName" jdbcType="VARCHAR" />
> <result column="MiddleInitial" property="MiddleInitial" jdbcType="CHAR" />
> <result column="LastName" property="LastName" jdbcType="VARCHAR" />
> <result column="EmailAddr" property="EmailAddr" jdbcType="VARCHAR" />
> <result column="Title" property="Title" jdbcType="VARCHAR" />
> <result column="Department" property="Department" jdbcType="VARCHAR" />
> <result column="Login" property="Login" jdbcType="VARCHAR" />
> <result column="Passwd" property="Passwd" jdbcType="VARCHAR" />
> <result column="Priv" property="Priv" jdbcType="INTEGER" />
> <result column="Active" property="Active" jdbcType="SMALLINT" />
> <result column="SystemAddUser" property="SystemAddUser" jdbcType="VARCHAR" />
> <result column="SystemAddDate" property="SystemAddDate" jdbcType="TIMESTAMP" />
> <result column="LastChangeUser" property="LastChangeUser" jdbcType="VARCHAR" />
> <result column="LastChangeDate" property="LastChangeDate" jdbcType="TIMESTAMP" />
> </resultMap>
> <sql id="abatorgenerated_Example_Where_Clause">
> <!--
> WARNING - This element is automatically generated by Abator for iBATIS, do not modify.
> This element was generated on Thu Apr 06 19:22:19 GMT+05:30 2006.
> -->
> <dynamic prepend="where">
> <isPropertyAvailable prepend="and" property="AND_UserId_NULL">
> UserId is null
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_UserId_NULL">
> UserId is null
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_UserId_NOT_NULL">
> UserId is not null
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_UserId_NOT_NULL">
> UserId is not null
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_UserId_EQUALS">
> UserId = #UserId#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_UserId_EQUALS">
> UserId = #UserId#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_UserId_NOT_EQUALS">
> UserId <![CDATA[ <> ]]> #UserId#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_UserId_NOT_EQUALS">
> UserId <![CDATA[ <> ]]> #UserId#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_UserId_GT">
> UserId <![CDATA[ > ]]> #UserId#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_UserId_GT">
> UserId <![CDATA[ > ]]> #UserId#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_UserId_GE">
> UserId <![CDATA[ >= ]]> #UserId#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_UserId_GE">
> UserId <![CDATA[ >= ]]> #UserId#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_UserId_LT">
> UserId <![CDATA[ < ]]> #UserId#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_UserId_LT">
> UserId <![CDATA[ < ]]> #UserId#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_UserId_LE">
> UserId <![CDATA[ <= ]]> #UserId#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_UserId_LE">
> UserId <![CDATA[ <= ]]> #UserId#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_FirstName_NULL">
> FirstName is null
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_FirstName_NULL">
> FirstName is null
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_FirstName_NOT_NULL">
> FirstName is not null
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_FirstName_NOT_NULL">
> FirstName is not null
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_FirstName_EQUALS">
> FirstName = #FirstName#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_FirstName_EQUALS">
> FirstName = #FirstName#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_FirstName_NOT_EQUALS">
> FirstName <![CDATA[ <> ]]> #FirstName#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_FirstName_NOT_EQUALS">
> FirstName <![CDATA[ <> ]]> #FirstName#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_FirstName_GT">
> FirstName <![CDATA[ > ]]> #FirstName#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_FirstName_GT">
> FirstName <![CDATA[ > ]]> #FirstName#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_FirstName_GE">
> FirstName <![CDATA[ >= ]]> #FirstName#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_FirstName_GE">
> FirstName <![CDATA[ >= ]]> #FirstName#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_FirstName_LT">
> FirstName <![CDATA[ < ]]> #FirstName#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_FirstName_LT">
> FirstName <![CDATA[ < ]]> #FirstName#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_FirstName_LE">
> FirstName <![CDATA[ <= ]]> #FirstName#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_FirstName_LE">
> FirstName <![CDATA[ <= ]]> #FirstName#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_FirstName_LIKE">
> FirstName like #FirstName#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_FirstName_LIKE">
> FirstName like #FirstName#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_MiddleInitial_NULL">
> MiddleInitial is null
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_MiddleInitial_NULL">
> MiddleInitial is null
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_MiddleInitial_NOT_NULL">
> MiddleInitial is not null
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_MiddleInitial_NOT_NULL">
> MiddleInitial is not null
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_MiddleInitial_EQUALS">
> MiddleInitial = #MiddleInitial#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_MiddleInitial_EQUALS">
> MiddleInitial = #MiddleInitial#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_MiddleInitial_NOT_EQUALS">
> MiddleInitial <![CDATA[ <> ]]> #MiddleInitial#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_MiddleInitial_NOT_EQUALS">
> MiddleInitial <![CDATA[ <> ]]> #MiddleInitial#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_MiddleInitial_GT">
> MiddleInitial <![CDATA[ > ]]> #MiddleInitial#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_MiddleInitial_GT">
> MiddleInitial <![CDATA[ > ]]> #MiddleInitial#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_MiddleInitial_GE">
> MiddleInitial <![CDATA[ >= ]]> #MiddleInitial#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_MiddleInitial_GE">
> MiddleInitial <![CDATA[ >= ]]> #MiddleInitial#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_MiddleInitial_LT">
> MiddleInitial <![CDATA[ < ]]> #MiddleInitial#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_MiddleInitial_LT">
> MiddleInitial <![CDATA[ < ]]> #MiddleInitial#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_MiddleInitial_LE">
> MiddleInitial <![CDATA[ <= ]]> #MiddleInitial#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_MiddleInitial_LE">
> MiddleInitial <![CDATA[ <= ]]> #MiddleInitial#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_MiddleInitial_LIKE">
> MiddleInitial like #MiddleInitial#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_MiddleInitial_LIKE">
> MiddleInitial like #MiddleInitial#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_LastName_NULL">
> LastName is null
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_LastName_NULL">
> LastName is null
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_LastName_NOT_NULL">
> LastName is not null
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_LastName_NOT_NULL">
> LastName is not null
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_LastName_EQUALS">
> LastName = #LastName#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_LastName_EQUALS">
> LastName = #LastName#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_LastName_NOT_EQUALS">
> LastName <![CDATA[ <> ]]> #LastName#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_LastName_NOT_EQUALS">
> LastName <![CDATA[ <> ]]> #LastName#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_LastName_GT">
> LastName <![CDATA[ > ]]> #LastName#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_LastName_GT">
> LastName <![CDATA[ > ]]> #LastName#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_LastName_GE">
> LastName <![CDATA[ >= ]]> #LastName#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_LastName_GE">
> LastName <![CDATA[ >= ]]> #LastName#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_LastName_LT">
> LastName <![CDATA[ < ]]> #LastName#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_LastName_LT">
> LastName <![CDATA[ < ]]> #LastName#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_LastName_LE">
> LastName <![CDATA[ <= ]]> #LastName#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_LastName_LE">
> LastName <![CDATA[ <= ]]> #LastName#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_LastName_LIKE">
> LastName like #LastName#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_LastName_LIKE">
> LastName like #LastName#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_EmailAddr_NULL">
> EmailAddr is null
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_EmailAddr_NULL">
> EmailAddr is null
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_EmailAddr_NOT_NULL">
> EmailAddr is not null
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_EmailAddr_NOT_NULL">
> EmailAddr is not null
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_EmailAddr_EQUALS">
> EmailAddr = #EmailAddr#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_EmailAddr_EQUALS">
> EmailAddr = #EmailAddr#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_EmailAddr_NOT_EQUALS">
> EmailAddr <![CDATA[ <> ]]> #EmailAddr#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_EmailAddr_NOT_EQUALS">
> EmailAddr <![CDATA[ <> ]]> #EmailAddr#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_EmailAddr_GT">
> EmailAddr <![CDATA[ > ]]> #EmailAddr#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_EmailAddr_GT">
> EmailAddr <![CDATA[ > ]]> #EmailAddr#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_EmailAddr_GE">
> EmailAddr <![CDATA[ >= ]]> #EmailAddr#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_EmailAddr_GE">
> EmailAddr <![CDATA[ >= ]]> #EmailAddr#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_EmailAddr_LT">
> EmailAddr <![CDATA[ < ]]> #EmailAddr#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_EmailAddr_LT">
> EmailAddr <![CDATA[ < ]]> #EmailAddr#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_EmailAddr_LE">
> EmailAddr <![CDATA[ <= ]]> #EmailAddr#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_EmailAddr_LE">
> EmailAddr <![CDATA[ <= ]]> #EmailAddr#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_EmailAddr_LIKE">
> EmailAddr like #EmailAddr#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_EmailAddr_LIKE">
> EmailAddr like #EmailAddr#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_Title_NULL">
> Title is null
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_Title_NULL">
> Title is null
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_Title_NOT_NULL">
> Title is not null
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_Title_NOT_NULL">
> Title is not null
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_Title_EQUALS">
> Title = #Title#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_Title_EQUALS">
> Title = #Title#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_Title_NOT_EQUALS">
> Title <![CDATA[ <> ]]> #Title#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_Title_NOT_EQUALS">
> Title <![CDATA[ <> ]]> #Title#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_Title_GT">
> Title <![CDATA[ > ]]> #Title#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_Title_GT">
> Title <![CDATA[ > ]]> #Title#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_Title_GE">
> Title <![CDATA[ >= ]]> #Title#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_Title_GE">
> Title <![CDATA[ >= ]]> #Title#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_Title_LT">
> Title <![CDATA[ < ]]> #Title#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_Title_LT">
> Title <![CDATA[ < ]]> #Title#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_Title_LE">
> Title <![CDATA[ <= ]]> #Title#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_Title_LE">
> Title <![CDATA[ <= ]]> #Title#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_Title_LIKE">
> Title like #Title#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_Title_LIKE">
> Title like #Title#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_Department_NULL">
> Department is null
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_Department_NULL">
> Department is null
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_Department_NOT_NULL">
> Department is not null
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_Department_NOT_NULL">
> Department is not null
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_Department_EQUALS">
> Department = #Department#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_Department_EQUALS">
> Department = #Department#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_Department_NOT_EQUALS">
> Department <![CDATA[ <> ]]> #Department#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_Department_NOT_EQUALS">
> Department <![CDATA[ <> ]]> #Department#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_Department_GT">
> Department <![CDATA[ > ]]> #Department#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_Department_GT">
> Department <![CDATA[ > ]]> #Department#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_Department_GE">
> Department <![CDATA[ >= ]]> #Department#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_Department_GE">
> Department <![CDATA[ >= ]]> #Department#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_Department_LT">
> Department <![CDATA[ < ]]> #Department#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_Department_LT">
> Department <![CDATA[ < ]]> #Department#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_Department_LE">
> Department <![CDATA[ <= ]]> #Department#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_Department_LE">
> Department <![CDATA[ <= ]]> #Department#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_Department_LIKE">
> Department like #Department#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_Department_LIKE">
> Department like #Department#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_Login_NULL">
> Login is null
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_Login_NULL">
> Login is null
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_Login_NOT_NULL">
> Login is not null
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_Login_NOT_NULL">
> Login is not null
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_Login_EQUALS">
> Login = #Login#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_Login_EQUALS">
> Login = #Login#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_Login_NOT_EQUALS">
> Login <![CDATA[ <> ]]> #Login#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_Login_NOT_EQUALS">
> Login <![CDATA[ <> ]]> #Login#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_Login_GT">
> Login <![CDATA[ > ]]> #Login#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_Login_GT">
> Login <![CDATA[ > ]]> #Login#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_Login_GE">
> Login <![CDATA[ >= ]]> #Login#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_Login_GE">
> Login <![CDATA[ >= ]]> #Login#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_Login_LT">
> Login <![CDATA[ < ]]> #Login#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_Login_LT">
> Login <![CDATA[ < ]]> #Login#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_Login_LE">
> Login <![CDATA[ <= ]]> #Login#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_Login_LE">
> Login <![CDATA[ <= ]]> #Login#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_Login_LIKE">
> Login like #Login#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_Login_LIKE">
> Login like #Login#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_Passwd_NULL">
> Passwd is null
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_Passwd_NULL">
> Passwd is null
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_Passwd_NOT_NULL">
> Passwd is not null
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_Passwd_NOT_NULL">
> Passwd is not null
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_Passwd_EQUALS">
> Passwd = #Passwd#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_Passwd_EQUALS">
> Passwd = #Passwd#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_Passwd_NOT_EQUALS">
> Passwd <![CDATA[ <> ]]> #Passwd#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_Passwd_NOT_EQUALS">
> Passwd <![CDATA[ <> ]]> #Passwd#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_Passwd_GT">
> Passwd <![CDATA[ > ]]> #Passwd#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_Passwd_GT">
> Passwd <![CDATA[ > ]]> #Passwd#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_Passwd_GE">
> Passwd <![CDATA[ >= ]]> #Passwd#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_Passwd_GE">
> Passwd <![CDATA[ >= ]]> #Passwd#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_Passwd_LT">
> Passwd <![CDATA[ < ]]> #Passwd#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_Passwd_LT">
> Passwd <![CDATA[ < ]]> #Passwd#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_Passwd_LE">
> Passwd <![CDATA[ <= ]]> #Passwd#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_Passwd_LE">
> Passwd <![CDATA[ <= ]]> #Passwd#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_Passwd_LIKE">
> Passwd like #Passwd#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_Passwd_LIKE">
> Passwd like #Passwd#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_Priv_NULL">
> Priv is null
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_Priv_NULL">
> Priv is null
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_Priv_NOT_NULL">
> Priv is not null
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_Priv_NOT_NULL">
> Priv is not null
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_Priv_EQUALS">
> Priv = #Priv#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_Priv_EQUALS">
> Priv = #Priv#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_Priv_NOT_EQUALS">
> Priv <![CDATA[ <> ]]> #Priv#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_Priv_NOT_EQUALS">
> Priv <![CDATA[ <> ]]> #Priv#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_Priv_GT">
> Priv <![CDATA[ > ]]> #Priv#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_Priv_GT">
> Priv <![CDATA[ > ]]> #Priv#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_Priv_GE">
> Priv <![CDATA[ >= ]]> #Priv#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_Priv_GE">
> Priv <![CDATA[ >= ]]> #Priv#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_Priv_LT">
> Priv <![CDATA[ < ]]> #Priv#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_Priv_LT">
> Priv <![CDATA[ < ]]> #Priv#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_Priv_LE">
> Priv <![CDATA[ <= ]]> #Priv#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_Priv_LE">
> Priv <![CDATA[ <= ]]> #Priv#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_Active_NULL">
> Active is null
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_Active_NULL">
> Active is null
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_Active_NOT_NULL">
> Active is not null
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_Active_NOT_NULL">
> Active is not null
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_Active_EQUALS">
> Active = #Active#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_Active_EQUALS">
> Active = #Active#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_Active_NOT_EQUALS">
> Active <![CDATA[ <> ]]> #Active#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_Active_NOT_EQUALS">
> Active <![CDATA[ <> ]]> #Active#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_Active_GT">
> Active <![CDATA[ > ]]> #Active#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_Active_GT">
> Active <![CDATA[ > ]]> #Active#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_Active_GE">
> Active <![CDATA[ >= ]]> #Active#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_Active_GE">
> Active <![CDATA[ >= ]]> #Active#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_Active_LT">
> Active <![CDATA[ < ]]> #Active#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_Active_LT">
> Active <![CDATA[ < ]]> #Active#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_Active_LE">
> Active <![CDATA[ <= ]]> #Active#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_Active_LE">
> Active <![CDATA[ <= ]]> #Active#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_SystemAddUser_NULL">
> SystemAddUser is null
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_SystemAddUser_NULL">
> SystemAddUser is null
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_SystemAddUser_NOT_NULL">
> SystemAddUser is not null
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_SystemAddUser_NOT_NULL">
> SystemAddUser is not null
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_SystemAddUser_EQUALS">
> SystemAddUser = #SystemAddUser#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_SystemAddUser_EQUALS">
> SystemAddUser = #SystemAddUser#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_SystemAddUser_NOT_EQUALS">
> SystemAddUser <![CDATA[ <> ]]> #SystemAddUser#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_SystemAddUser_NOT_EQUALS">
> SystemAddUser <![CDATA[ <> ]]> #SystemAddUser#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_SystemAddUser_GT">
> SystemAddUser <![CDATA[ > ]]> #SystemAddUser#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_SystemAddUser_GT">
> SystemAddUser <![CDATA[ > ]]> #SystemAddUser#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_SystemAddUser_GE">
> SystemAddUser <![CDATA[ >= ]]> #SystemAddUser#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_SystemAddUser_GE">
> SystemAddUser <![CDATA[ >= ]]> #SystemAddUser#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_SystemAddUser_LT">
> SystemAddUser <![CDATA[ < ]]> #SystemAddUser#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_SystemAddUser_LT">
> SystemAddUser <![CDATA[ < ]]> #SystemAddUser#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_SystemAddUser_LE">
> SystemAddUser <![CDATA[ <= ]]> #SystemAddUser#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_SystemAddUser_LE">
> SystemAddUser <![CDATA[ <= ]]> #SystemAddUser#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_SystemAddUser_LIKE">
> SystemAddUser like #SystemAddUser#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_SystemAddUser_LIKE">
> SystemAddUser like #SystemAddUser#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_SystemAddDate_NULL">
> SystemAddDate is null
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_SystemAddDate_NULL">
> SystemAddDate is null
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_SystemAddDate_NOT_NULL">
> SystemAddDate is not null
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_SystemAddDate_NOT_NULL">
> SystemAddDate is not null
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_SystemAddDate_EQUALS">
> SystemAddDate = #SystemAddDate#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_SystemAddDate_EQUALS">
> SystemAddDate = #SystemAddDate#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_SystemAddDate_NOT_EQUALS">
> SystemAddDate <![CDATA[ <> ]]> #SystemAddDate#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_SystemAddDate_NOT_EQUALS">
> SystemAddDate <![CDATA[ <> ]]> #SystemAddDate#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_SystemAddDate_GT">
> SystemAddDate <![CDATA[ > ]]> #SystemAddDate#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_SystemAddDate_GT">
> SystemAddDate <![CDATA[ > ]]> #SystemAddDate#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_SystemAddDate_GE">
> SystemAddDate <![CDATA[ >= ]]> #SystemAddDate#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_SystemAddDate_GE">
> SystemAddDate <![CDATA[ >= ]]> #SystemAddDate#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_SystemAddDate_LT">
> SystemAddDate <![CDATA[ < ]]> #SystemAddDate#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_SystemAddDate_LT">
> SystemAddDate <![CDATA[ < ]]> #SystemAddDate#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_SystemAddDate_LE">
> SystemAddDate <![CDATA[ <= ]]> #SystemAddDate#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_SystemAddDate_LE">
> SystemAddDate <![CDATA[ <= ]]> #SystemAddDate#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_LastChangeUser_NULL">
> LastChangeUser is null
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_LastChangeUser_NULL">
> LastChangeUser is null
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_LastChangeUser_NOT_NULL">
> LastChangeUser is not null
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_LastChangeUser_NOT_NULL">
> LastChangeUser is not null
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_LastChangeUser_EQUALS">
> LastChangeUser = #LastChangeUser#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_LastChangeUser_EQUALS">
> LastChangeUser = #LastChangeUser#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_LastChangeUser_NOT_EQUALS">
> LastChangeUser <![CDATA[ <> ]]> #LastChangeUser#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_LastChangeUser_NOT_EQUALS">
> LastChangeUser <![CDATA[ <> ]]> #LastChangeUser#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_LastChangeUser_GT">
> LastChangeUser <![CDATA[ > ]]> #LastChangeUser#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_LastChangeUser_GT">
> LastChangeUser <![CDATA[ > ]]> #LastChangeUser#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_LastChangeUser_GE">
> LastChangeUser <![CDATA[ >= ]]> #LastChangeUser#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_LastChangeUser_GE">
> LastChangeUser <![CDATA[ >= ]]> #LastChangeUser#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_LastChangeUser_LT">
> LastChangeUser <![CDATA[ < ]]> #LastChangeUser#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_LastChangeUser_LT">
> LastChangeUser <![CDATA[ < ]]> #LastChangeUser#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_LastChangeUser_LE">
> LastChangeUser <![CDATA[ <= ]]> #LastChangeUser#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_LastChangeUser_LE">
> LastChangeUser <![CDATA[ <= ]]> #LastChangeUser#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_LastChangeUser_LIKE">
> LastChangeUser like #LastChangeUser#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_LastChangeUser_LIKE">
> LastChangeUser like #LastChangeUser#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_LastChangeDate_NULL">
> LastChangeDate is null
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_LastChangeDate_NULL">
> LastChangeDate is null
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_LastChangeDate_NOT_NULL">
> LastChangeDate is not null
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_LastChangeDate_NOT_NULL">
> LastChangeDate is not null
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_LastChangeDate_EQUALS">
> LastChangeDate = #LastChangeDate#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_LastChangeDate_EQUALS">
> LastChangeDate = #LastChangeDate#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_LastChangeDate_NOT_EQUALS">
> LastChangeDate <![CDATA[ <> ]]> #LastChangeDate#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_LastChangeDate_NOT_EQUALS">
> LastChangeDate <![CDATA[ <> ]]> #LastChangeDate#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_LastChangeDate_GT">
> LastChangeDate <![CDATA[ > ]]> #LastChangeDate#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_LastChangeDate_GT">
> LastChangeDate <![CDATA[ > ]]> #LastChangeDate#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_LastChangeDate_GE">
> LastChangeDate <![CDATA[ >= ]]> #LastChangeDate#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_LastChangeDate_GE">
> LastChangeDate <![CDATA[ >= ]]> #LastChangeDate#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_LastChangeDate_LT">
> LastChangeDate <![CDATA[ < ]]> #LastChangeDate#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_LastChangeDate_LT">
> LastChangeDate <![CDATA[ < ]]> #LastChangeDate#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="and" property="AND_LastChangeDate_LE">
> LastChangeDate <![CDATA[ <= ]]> #LastChangeDate#
> </isPropertyAvailable>
> <isPropertyAvailable prepend="or" property="OR_LastChangeDate_LE">
> LastChangeDate <![CDATA[ <= ]]> #LastChangeDate#
> </isPropertyAvailable>
> </dynamic>
> </sql>
> <select id="abatorgenerated_selectByPrimaryKey" resultMap="abatorgenerated_AppUserResult" parameterClass="com.indidge.common.model.idtracksdevices.AppUserKey">
> <!--
> WARNING - This element is automatically generated by Abator for iBATIS, do not modify.
> This element was generated on Thu Apr 06 19:22:19 GMT+05:30 2006.
> -->
> select UserId,
> FirstName,
> MiddleInitial,
> LastName,
> EmailAddr,
> Title,
> Department,
> Login,
> Passwd,
> Priv,
> Active,
> SystemAddUser,
> SystemAddDate,
> LastChangeUser,
> LastChangeDate
> from idTracksDevices.AppUser
> where UserId = #UserId#
> </select>
> <select id="abatorgenerated_selectByExample" resultMap="abatorgenerated_AppUserResult" parameterClass="java.util.Map">
> <!--
> WARNING - This element is automatically generated by Abator for iBATIS, do not modify.
> This element was generated on Thu Apr 06 19:22:19 GMT+05:30 2006.
> -->
> select UserId,
> FirstName,
> MiddleInitial,
> LastName,
> EmailAddr,
> Title,
> Department,
> Login,
> Passwd,
> Priv,
> Active,
> SystemAddUser,
> SystemAddDate,
> LastChangeUser,
> LastChangeDate
> from idTracksDevices.AppUser
> <include refid="idTracksDevices_AppUser.abatorgenerated_Example_Where_Clause"/>
> <isPropertyAvailable property="ABATOR_ORDER_BY_CLAUSE">
> order by $ABATOR_ORDER_BY_CLAUSE$
> </isPropertyAvailable>
> </select>
> <delete id="abatorgenerated_deleteByPrimaryKey" parameterClass="com.indidge.common.model.idtracksdevices.AppUserKey">
> <!--
> WARNING - This element is automatically generated by Abator for iBATIS, do not modify.
> This element was generated on Thu Apr 06 19:22:19 GMT+05:30 2006.
> -->
> delete from idTracksDevices.AppUser
> where UserId = #UserId#
> </delete>
> <delete id="abatorgenerated_deleteByExample" parameterClass="java.util.Map">
> <!--
> WARNING - This element is automatically generated by Abator for iBATIS, do not modify.
> This element was generated on Thu Apr 06 19:22:19 GMT+05:30 2006.
> -->
> delete from idTracksDevices.AppUser
> <include refid="idTracksDevices_AppUser.abatorgenerated_Example_Where_Clause"/>
> </delete>
> <insert id="abatorgenerated_insert" parameterClass="com.indidge.common.model.idtracksdevices.AppUser">
> <!--
> WARNING - This element is automatically generated by Abator for iBATIS, do not modify.
> This element was generated on Thu Apr 06 19:22:19 GMT+05:30 2006.
> -->
> insert into idTracksDevices.AppUser (UserId, FirstName, MiddleInitial,
> LastName, EmailAddr, Title, Department, Login, Passwd, Priv, Active,
> SystemAddUser, SystemAddDate, LastChangeUser, LastChangeDate)
> values (#UserId:BIGINT#, #FirstName:VARCHAR#, #MiddleInitial:CHAR#,
> #LastName:VARCHAR#, #EmailAddr:VARCHAR#, #Title:VARCHAR#,
> #Department:VARCHAR#, #Login:VARCHAR#, #Passwd:VARCHAR#, #Priv:INTEGER#,
> #Active:SMALLINT#, #SystemAddUser:VARCHAR#, #SystemAddDate:TIMESTAMP#,
> #LastChangeUser:VARCHAR#, #LastChangeDate:TIMESTAMP#)
> </insert>
> <update id="abatorgenerated_updateByPrimaryKey" parameterClass="com.indidge.common.model.idtracksdevices.AppUser">
> <!--
> WARNING - This element is automatically generated by Abator for iBATIS, do not modify.
> This element was generated on Thu Apr 06 19:22:19 GMT+05:30 2006.
> -->
> update idTracksDevices.AppUser
> set FirstName = #FirstName:VARCHAR#,
> MiddleInitial = #MiddleInitial:CHAR#,
> LastName = #LastName:VARCHAR#,
> EmailAddr = #EmailAddr:VARCHAR#,
> Title = #Title:VARCHAR#,
> Department = #Department:VARCHAR#,
> Login = #Login:VARCHAR#,
> Passwd = #Passwd:VARCHAR#,
> Priv = #Priv:INTEGER#,
> Active = #Active:SMALLINT#,
> SystemAddUser = #SystemAddUser:VARCHAR#,
> SystemAddDate = #SystemAddDate:TIMESTAMP#,
> LastChangeUser = #LastChangeUser:VARCHAR#,
> LastChangeDate = #LastChangeDate:TIMESTAMP#
> where UserId = #UserId#
> </update>
></sqlMap>
>
>
>
>------------------------------------------------------------------------
>
>package com.indidge.common.model.idtracksdevices;
>
>
>public class AppUserKey {
>
> /**
> * This field was generated by Abator for iBATIS.
> * This field corresponds to the database column idTracksDevices.AppUser.UserId
> *
> * @abatorgenerated Thu Apr 06 19:22:19 GMT+05:30 2006
> */
> private Long UserId;
>
> /**
> * This method was generated by Abator for iBATIS.
> * This method returns the value of the database column idTracksDevices.AppUser.UserId
> *
> * @return the value of idTracksDevices.AppUser.UserId
> *
> * @abatorgenerated Thu Apr 06 19:22:19 GMT+05:30 2006
> */
> public Long getUserId() {
> return UserId;
> }
>
> /**
> * This method was generated by Abator for iBATIS.
> * This method sets the value of the database column idTracksDevices.AppUser.UserId
> *
> * @param UserId the value for idTracksDevices.AppUser.UserId
> *
> * @abatorgenerated Thu Apr 06 19:22:19 GMT+05:30 2006
> */
> public void setUserId(Long UserId) {
> this.UserId = UserId;
> }
>}
>
>
|