V_E4S_USERS

Overview

Package

Class

Tree

Deprecated

Index

Help

www.element4solution.com

PREV CLASS NEXT CLASS

FRAMES NO FRAMES

SUMMARY: NESTED | FIELD | CONSTR | METHOD

DETAIL: FIELD | CONSTR | METHOD

e4s.db.systabledef
Class V_E4S_USERS_Sel

java.lang.Object
  e4s.util.E4Object
      e4s.db.E4DBFilter
          e4s.db.E4DBFilterAnd
              e4s.db.E4DBSelect
                  e4s.db.E4DBSelectView
                      e4s.db.systabledef.V_E4S_USERS_Sel

All Implemented Interfaces:: E4DBFilter_Intf, E4DBFilterAnd_Intf, E4DBSelect_Intf

public class V_E4S_USERS_Sel
extends E4DBSelectView
implements E4DBSelect_Intf
extends E4DBSelectView
implements E4DBSelect_Intf

SQL select for V_E4S_USERS. created: 20070318 195626, modified: -

See Also:: T_E4S_COMPANY_Sel, T_E4S_COMPANY_USER_Sel

Field Summary
`static E4DBColumnInfo`	`CI_ADDRESS01`
`static E4DBColumnInfo`	`CI_ADDRESS02`
`static E4DBColumnInfo`	`CI_CITY`
`static E4DBColumnInfo`	`CI_COUNTRYCODE`
`static E4DBColumnInfo`	`CI_DATEFORMAT`
`static E4DBColumnInfo`	`CI_DATNEW`
`static E4DBColumnInfo`	`CI_DECIMALSIGN`
`static E4DBColumnInfo`	`CI_EMAIL`
`static E4DBColumnInfo`	`CI_FIRSTNAME`
`static E4DBColumnInfo`	`CI_GENDER`
`static E4DBColumnInfo`	`CI_GIS_LATITUDE`
`static E4DBColumnInfo`	`CI_GIS_LONGITUDE`
`static E4DBColumnInfo`	`CI_GROUP_ID`
`static E4DBColumnInfo`	`CI_LASTNAME`
`static E4DBColumnInfo`	`CI_LOGIN_NAME`
`static E4DBColumnInfo`	`CI_LOGIN_PASSWORD`
`static E4DBColumnInfo`	`CI_MIDDLENAME`
`static E4DBColumnInfo`	`CI_NAME`
`static E4DBColumnInfo`	`CI_PHONE01`
`static E4DBColumnInfo`	`CI_PHONE02`
`static E4DBColumnInfo`	`CI_REM`
`static E4DBColumnInfo`	`CI_SATURATION`
`static E4DBColumnInfo`	`CI_TIMEFORMAT`
`static E4DBColumnInfo`	`CI_TIMEZONE`
`static E4DBColumnInfo`	`CI_U`
`static E4DBColumnInfo`	`CI_UID`
`static E4DBColumnInfo`	`CI_VALID_UNTIL`
`static E4DBColumnInfo`	`CI_WWW`
`static E4DBColumnInfo`	`CI_ZIPCODE`
`static E4DBColumnName`	`COL_ADDRESS01` `T_E4S_COMPANY_Sel.COL_ADDRESS01` ADDRESS01.
`static E4DBColumnName`	`COL_ADDRESS02` `T_E4S_COMPANY_Sel.COL_ADDRESS02` ADDRESS02.
`static E4DBColumnName`	`COL_CITY` `T_E4S_COMPANY_Sel.COL_CITY` CITY.
`static E4DBColumnName`	`COL_COUNTRYCODE` `T_E4S_COMPANY_Sel.COL_COUNTRYCODE` COUNTRYCODE.
`static E4DBColumnName`	`COL_DATEFORMAT` `T_E4S_COMPANY_USER_Sel.COL_DATEFORMAT` DATEFORMAT.
`static E4DBColumnName`	`COL_DATNEW` `T_E4S_COMPANY_Sel.COL_DATNEW` DATNEW.
`static E4DBColumnName`	`COL_DECIMALSIGN` `T_E4S_COMPANY_USER_Sel.COL_DECIMALSIGN` DECIMALSIGN.
`static E4DBColumnName`	`COL_EMAIL` `T_E4S_COMPANY_USER_Sel.COL_EMAIL` EMAIL.
`static E4DBColumnName`	`COL_FIRSTNAME` `T_E4S_COMPANY_USER_Sel.COL_FIRSTNAME` FIRSTNAME.
`static E4DBColumnName`	`COL_GENDER` `T_E4S_COMPANY_USER_Sel.COL_GENDER` GENDER.
`static E4DBColumnName`	`COL_GIS_LATITUDE` `T_E4S_COMPANY_Sel.COL_GIS_LATITUDE` GIS_LATITUDE.
`static E4DBColumnName`	`COL_GIS_LONGITUDE` `T_E4S_COMPANY_Sel.COL_GIS_LONGITUDE` GIS_LONGITUDE.
`static E4DBColumnName`	`COL_GROUP_ID` `T_E4S_COMPANY_Sel.COL_GROUP_ID` GROUP_ID.
`static E4DBColumnName`	`COL_LASTNAME` `T_E4S_COMPANY_USER_Sel.COL_LASTNAME` LASTNAME.
`static E4DBColumnName`	`COL_LOGIN_NAME` `T_E4S_COMPANY_Sel.COL_LOGIN_NAME` LOGIN_NAME.
`static E4DBColumnName`	`COL_LOGIN_PASSWORD` `T_E4S_COMPANY_USER_Sel.COL_LOGIN_PASSWORD` LOGIN_PASSWORD.
`static E4DBColumnName`	`COL_MIDDLENAME` `T_E4S_COMPANY_USER_Sel.COL_MIDDLENAME` MIDDLENAME.
`static E4DBColumnName`	`COL_NAME` `T_E4S_COMPANY_Sel.COL_NAME` NAME.
`static E4DBColumnName`	`COL_PHONE01` `T_E4S_COMPANY_Sel.COL_PHONE01` PHONE01.
`static E4DBColumnName`	`COL_PHONE02` `T_E4S_COMPANY_Sel.COL_PHONE02` PHONE02.
`static E4DBColumnName`	`COL_REM` `T_E4S_COMPANY_Sel.COL_REM` REM.
`static E4DBColumnName`	`COL_SATURATION` `T_E4S_COMPANY_USER_Sel.COL_SATURATION` SATURATION.
`static E4DBColumnName`	`COL_TIMEFORMAT` `T_E4S_COMPANY_USER_Sel.COL_TIMEFORMAT` TIMEFORMAT.
`static E4DBColumnName`	`COL_TIMEZONE` `T_E4S_COMPANY_USER_Sel.COL_TIMEZONE` TIMEZONE.
`static E4DBColumnName`	`COL_U` `T_E4S_COMPANY_USER_Sel.COL_LOGIN_NAME` LOGIN_NAME.
`static E4DBColumnName`	`COL_UID` `T_E4S_COMPANY_Sel.COL_UID` UID.
`static E4DBColumnName`	`COL_VALID_UNTIL` `T_E4S_COMPANY_Sel.COL_VALID_UNTIL` VALID_UNTIL.
`static E4DBColumnName`	`COL_WWW` `T_E4S_COMPANY_Sel.COL_WWW` WWW.
`static E4DBColumnName`	`COL_ZIPCODE` `T_E4S_COMPANY_Sel.COL_ZIPCODE` ZIPCODE.
`static E4DBColumnInfo[]`	`COLUMNS` Definition of view selection columns as array.
`static boolean`	`IS_CLIENT_DISTINCTIVE` This view is client distinctive.
`static java.lang.String`	`SQL`
`static E4DBTableName`	`TABLE_A` Table involved T_E4S_COMPANY Hold Information about companies, users are related to companies..
`static E4DBTableName`	`TABLE_B` Table involved T_E4S_COMPANY_USER Users related to companies, here you will find login information of users and personal settings such as date formats..
`static E4DBTableName`	`VIEWNAME` Name of the view

Fields inherited from class e4s.db.E4DBSelect
`COLUMN_NAME_COUNT, COLUMN_NAME_SUM, DB_DATEFORMAT, DB_DATEPICTURE, ms_isunicode, NULL`

Fields inherited from class e4s.db.E4DBFilter
`COMP_EMPTY, COMP_EQUALS, COMP_GREATER, COMP_GREATER_EQUAL, COMP_IN, COMP_IS_NOT_NULL, COMP_IS_NULL, COMP_LESS, COMP_LESS_EQUAL, COMP_LIKE, COMP_NOT_EMPTY, COMP_NOT_EQUALS, COMP_NOT_IN, COMP_NOT_LIKE`

Fields inherited from class e4s.util.E4Object
`CRLF, E4S_CORE_SYSTEM_LANGUAGE, NBSP, NULLSTR, URL_ENCODING_CHARSET`

Constructor Summary
`V_E4S_USERS_Sel(E4ApplObj_Intf applobj)` Construct an object for selecting data from V_E4S_USERS using the default database connection, the table uses client distinction.
`V_E4S_USERS_Sel(E4DBConnection_Intf dbcon, E4ApplObj_Intf applobj)` Construct an object for selecting data from V_E4S_USERS using a database connection, the table uses client distinction.
`V_E4S_USERS_Sel(V_E4S_USERS_Sel V_E4S_USERS, boolean copy_where)`

Method Summary
`static java.lang.String`	`_getSVNVersionString()` Return the version info patched by CVS.
`boolean`	`canHaveFreeDefinedFields()` Check, if this table might have freedefined fields.
`E4ID`	`E4ID()`
`java.lang.String`	`get_ADDRESS01()` Get data for column ADDRESS01 ADDRESS01.
`java.lang.String`	`get_ADDRESS02()` Get data for column ADDRESS02 ADDRESS02.
`java.lang.String`	`get_CITY()` Get data for column CITY CITY.
`CountryCode`	`get_COUNTRYCODE()` Get data for column COUNTRYCODE COUNTRYCODE.
`java.lang.String`	`get_DATEFORMAT()` Get data for column DATEFORMAT DATEFORMAT.
`java.util.Date`	`get_DATNEW()` Get data for column DATNEW DATNEW.
`E4DecimalSign`	`get_DECIMALSIGN()` Get data for column DECIMALSIGN DECIMALSIGN.
`java.lang.String`	`get_EMAIL()` Get data for column EMAIL EMAIL.
`java.lang.String`	`get_FIRSTNAME()` Get data for column FIRSTNAME FIRSTNAME.
`E4Gender`	`get_GENDER()` Get data for column GENDER GENDER.
`float`	`get_GIS_LATITUDE()` Get data for column GIS_LATITUDE GIS_LATITUDE.
`float`	`get_GIS_LONGITUDE()` Get data for column GIS_LONGITUDE GIS_LONGITUDE.
`E4CompanyGroup`	`get_GROUP_ID()` Get data for column GROUP_ID GROUP_ID.
`java.lang.String`	`get_LASTNAME()` Get data for column LASTNAME LASTNAME.
`java.lang.String`	`get_LOGIN_NAME()` Get data for column LOGIN_NAME LOGIN_NAME.
`java.lang.String`	`get_LOGIN_PASSWORD()` Get data for column LOGIN_PASSWORD LOGIN_PASSWORD.
`java.lang.String`	`get_MIDDLENAME()` Get data for column MIDDLENAME MIDDLENAME.
`java.lang.String`	`get_NAME()` Get data for column NAME NAME.
`java.lang.String`	`get_PHONE01()` Get data for column PHONE01 PHONE01.
`java.lang.String`	`get_PHONE02()` Get data for column PHONE02 PHONE02.
`java.lang.String`	`get_REM()` Get data for column REM REM.
`java.lang.String`	`get_SATURATION()` Get data for column SATURATION SATURATION.
`java.lang.String`	`get_TIMEFORMAT()` Get data for column TIMEFORMAT TIMEFORMAT.
`TimeZone`	`get_TIMEZONE()` Get data for column TIMEZONE TIMEZONE.
`E4CompanyUserId`	`get_U()` Get data for column U U.
`java.lang.String`	`get_UID()` Get data for column UID UID.
`java.util.Date`	`get_VALID_UNTIL()` Get data for column VALID_UNTIL VALID_UNTIL.
`java.lang.String`	`get_WWW()` Get data for column WWW WWW.
`java.lang.String`	`get_ZIPCODE()` Get data for column ZIPCODE ZIPCODE.
`E4DBColumnInfo[]`	`getColInfo()` Get information about the columns defined for this database table.
`boolean`	`hasClientDistinctive()` Get the state if data of this table will be distincted by `E4Client`.
`E4DBSelect_Intf`	`makeInstance(boolean copy_where)` Create a new instance for V_E4S_USERS_Sel
`void`	`sort_ADDRESS01_descending()` Sort ascending by column ADDRESS01 ADDRESS01.
`void`	`sort_ADDRESS01()` Sort ascending by column ADDRESS01 ADDRESS01.
`void`	`sort_ADDRESS02_descending()` Sort ascending by column ADDRESS02 ADDRESS02.
`void`	`sort_ADDRESS02()` Sort ascending by column ADDRESS02 ADDRESS02.
`void`	`sort_CITY_descending()` Sort ascending by column CITY CITY.
`void`	`sort_CITY()` Sort ascending by column CITY CITY.
`void`	`sort_COUNTRYCODE_descending()` Sort ascending by column COUNTRYCODE COUNTRYCODE.
`void`	`sort_COUNTRYCODE()` Sort ascending by column COUNTRYCODE COUNTRYCODE.
`void`	`sort_DATEFORMAT_descending()` Sort ascending by column DATEFORMAT DATEFORMAT.
`void`	`sort_DATEFORMAT()` Sort ascending by column DATEFORMAT DATEFORMAT.
`void`	`sort_DATNEW_descending()` Sort ascending by column DATNEW DATNEW.
`void`	`sort_DATNEW()` Sort ascending by column DATNEW DATNEW.
`void`	`sort_DECIMALSIGN_descending()` Sort ascending by column DECIMALSIGN DECIMALSIGN.
`void`	`sort_DECIMALSIGN()` Sort ascending by column DECIMALSIGN DECIMALSIGN.
`void`	`sort_EMAIL_descending()` Sort ascending by column EMAIL EMAIL.
`void`	`sort_EMAIL()` Sort ascending by column EMAIL EMAIL.
`void`	`sort_FIRSTNAME_descending()` Sort ascending by column FIRSTNAME FIRSTNAME.
`void`	`sort_FIRSTNAME()` Sort ascending by column FIRSTNAME FIRSTNAME.
`void`	`sort_GENDER_descending()` Sort ascending by column GENDER GENDER.
`void`	`sort_GENDER()` Sort ascending by column GENDER GENDER.
`void`	`sort_GIS_LATITUDE_descending()` Sort ascending by column GIS_LATITUDE GIS_LATITUDE.
`void`	`sort_GIS_LATITUDE()` Sort ascending by column GIS_LATITUDE GIS_LATITUDE.
`void`	`sort_GIS_LONGITUDE_descending()` Sort ascending by column GIS_LONGITUDE GIS_LONGITUDE.
`void`	`sort_GIS_LONGITUDE()` Sort ascending by column GIS_LONGITUDE GIS_LONGITUDE.
`void`	`sort_GROUP_ID_descending()` Sort ascending by column GROUP_ID GROUP_ID.
`void`	`sort_GROUP_ID()` Sort ascending by column GROUP_ID GROUP_ID.
`void`	`sort_LASTNAME_descending()` Sort ascending by column LASTNAME LASTNAME.
`void`	`sort_LASTNAME()` Sort ascending by column LASTNAME LASTNAME.
`void`	`sort_LOGIN_NAME_descending()` Sort ascending by column LOGIN_NAME LOGIN_NAME.
`void`	`sort_LOGIN_NAME()` Sort ascending by column LOGIN_NAME LOGIN_NAME.
`void`	`sort_LOGIN_PASSWORD_descending()` Sort ascending by column LOGIN_PASSWORD LOGIN_PASSWORD.
`void`	`sort_LOGIN_PASSWORD()` Sort ascending by column LOGIN_PASSWORD LOGIN_PASSWORD.
`void`	`sort_MIDDLENAME_descending()` Sort ascending by column MIDDLENAME MIDDLENAME.
`void`	`sort_MIDDLENAME()` Sort ascending by column MIDDLENAME MIDDLENAME.
`void`	`sort_NAME_descending()` Sort ascending by column NAME NAME.
`void`	`sort_NAME()` Sort ascending by column NAME NAME.
`void`	`sort_PHONE01_descending()` Sort ascending by column PHONE01 PHONE01.
`void`	`sort_PHONE01()` Sort ascending by column PHONE01 PHONE01.
`void`	`sort_PHONE02_descending()` Sort ascending by column PHONE02 PHONE02.
`void`	`sort_PHONE02()` Sort ascending by column PHONE02 PHONE02.
`void`	`sort_REM_descending()` Sort ascending by column REM REM.
`void`	`sort_REM()` Sort ascending by column REM REM.
`void`	`sort_SATURATION_descending()` Sort ascending by column SATURATION SATURATION.
`void`	`sort_SATURATION()` Sort ascending by column SATURATION SATURATION.
`void`	`sort_TIMEFORMAT_descending()` Sort ascending by column TIMEFORMAT TIMEFORMAT.
`void`	`sort_TIMEFORMAT()` Sort ascending by column TIMEFORMAT TIMEFORMAT.
`void`	`sort_TIMEZONE_descending()` Sort ascending by column TIMEZONE TIMEZONE.
`void`	`sort_TIMEZONE()` Sort ascending by column TIMEZONE TIMEZONE.
`void`	`sort_U_descending()` Sort ascending by column U U.
`void`	`sort_U()` Sort ascending by column U U.
`void`	`sort_UID_descending()` Sort ascending by column UID UID.
`void`	`sort_UID()` Sort ascending by column UID UID.
`void`	`sort_VALID_UNTIL_descending()` Sort ascending by column VALID_UNTIL VALID_UNTIL.
`void`	`sort_VALID_UNTIL()` Sort ascending by column VALID_UNTIL VALID_UNTIL.
`void`	`sort_WWW_descending()` Sort ascending by column WWW WWW.
`void`	`sort_WWW()` Sort ascending by column WWW WWW.
`void`	`sort_ZIPCODE_descending()` Sort ascending by column ZIPCODE ZIPCODE.
`void`	`sort_ZIPCODE()` Sort ascending by column ZIPCODE ZIPCODE.
`void`	`where_ADDRESS01_in(E4DBSelectDistinct filter)` Define a ..WHERE/AND ADDRESS01 IN (SELECT DISTINCT column FROM table WHERE condition).
`void`	`where_ADDRESS01_isEmpty()` Define a ..WHERE/AND (ADDRESS01 IS NULL OR ADDRESS01 == '').
`void`	`where_ADDRESS01_isNotEmpty()` Define a ..WHERE/AND (ADDRESS01 IS NOT NULL AND ADDRESS01 !
`void`	`where_ADDRESS01_isNotNull()` Define a ..WHERE/AND ADDRESS01 IS NOT NULL.
`void`	`where_ADDRESS01_isNull()` Define a ..WHERE/AND (ADDRESS01 IS NULL).
`void`	`where_ADDRESS01(int operator, java.lang.String filter)` Define a filter (AND-ed WHERE) for column ADDRESS01 ADDRESS01.
`void`	`where_ADDRESS01(java.lang.String filter)` Define a filter (AND-ed WHERE) for column ADDRESS01 ADDRESS01.
`void`	`where_ADDRESS02_in(E4DBSelectDistinct filter)` Define a ..WHERE/AND ADDRESS02 IN (SELECT DISTINCT column FROM table WHERE condition).
`void`	`where_ADDRESS02_isEmpty()` Define a ..WHERE/AND (ADDRESS02 IS NULL OR ADDRESS02 == '').
`void`	`where_ADDRESS02_isNotEmpty()` Define a ..WHERE/AND (ADDRESS02 IS NOT NULL AND ADDRESS02 !
`void`	`where_ADDRESS02_isNotNull()` Define a ..WHERE/AND ADDRESS02 IS NOT NULL.
`void`	`where_ADDRESS02_isNull()` Define a ..WHERE/AND (ADDRESS02 IS NULL).
`void`	`where_ADDRESS02(int operator, java.lang.String filter)` Define a filter (AND-ed WHERE) for column ADDRESS02 ADDRESS02.
`void`	`where_ADDRESS02(java.lang.String filter)` Define a filter (AND-ed WHERE) for column ADDRESS02 ADDRESS02.
`void`	`where_CITY_in(E4DBSelectDistinct filter)` Define a ..WHERE/AND CITY IN (SELECT DISTINCT column FROM table WHERE condition).
`void`	`where_CITY_isEmpty()` Define a ..WHERE/AND (CITY IS NULL OR CITY == '').
`void`	`where_CITY_isNotEmpty()` Define a ..WHERE/AND (CITY IS NOT NULL AND CITY !
`void`	`where_CITY_isNotNull()` Define a ..WHERE/AND CITY IS NOT NULL.
`void`	`where_CITY_isNull()` Define a ..WHERE/AND (CITY IS NULL).
`void`	`where_CITY(int operator, java.lang.String filter)` Define a filter (AND-ed WHERE) for column CITY CITY.
`void`	`where_CITY(java.lang.String filter)` Define a filter (AND-ed WHERE) for column CITY CITY.
`void`	`where_COUNTRYCODE_like(java.lang.String filter)` Define a filter (AND-ed WHERE) for column COUNTRYCODE COUNTRYCODE.
`void`	`where_COUNTRYCODE(CountryCode filter)` Define a filter (AND-ed WHERE) for column COUNTRYCODE COUNTRYCODE.
`void`	`where_COUNTRYCODE(int operator, CountryCode filter)` Define a filter (AND-ed WHERE) for column COUNTRYCODE COUNTRYCODE.
`void`	`where_DATEFORMAT_in(E4DBSelectDistinct filter)` Define a ..WHERE/AND DATEFORMAT IN (SELECT DISTINCT column FROM table WHERE condition).
`void`	`where_DATEFORMAT_isEmpty()` Define a ..WHERE/AND (DATEFORMAT IS NULL OR DATEFORMAT == '').
`void`	`where_DATEFORMAT_isNotEmpty()` Define a ..WHERE/AND (DATEFORMAT IS NOT NULL AND DATEFORMAT !
`void`	`where_DATEFORMAT_isNotNull()` Define a ..WHERE/AND DATEFORMAT IS NOT NULL.
`void`	`where_DATEFORMAT_isNull()` Define a ..WHERE/AND (DATEFORMAT IS NULL).
`void`	`where_DATEFORMAT(int operator, java.lang.String filter)` Define a filter (AND-ed WHERE) for column DATEFORMAT DATEFORMAT.
`void`	`where_DATEFORMAT(java.lang.String filter)` Define a filter (AND-ed WHERE) for column DATEFORMAT DATEFORMAT.
`void`	`where_DATNEW_in(E4DBSelectDistinct filter)` Define a ..WHERE/AND DATNEW IN (SELECT DISTINCT column FROM table WHERE condition).
`void`	`where_DATNEW_isEmpty()` Define a ..WHERE/AND (DATNEW IS NULL OR DATNEW == '').
`void`	`where_DATNEW_isNotEmpty()` Define a ..WHERE/AND (DATNEW IS NOT NULL AND DATNEW !
`void`	`where_DATNEW_isNotNull()` Define a ..WHERE/AND DATNEW IS NOT NULL.
`void`	`where_DATNEW_isNull()` Define a ..WHERE/AND (DATNEW IS NULL).
`void`	`where_DATNEW(java.util.Date filter)` Define a filter (AND-ed WHERE) for column DATNEW DATNEW.
`void`	`where_DATNEW(int operator, java.util.Date filter)` Define a filter (AND-ed WHERE) for column DATNEW DATNEW.
`void`	`where_DECIMALSIGN_in(E4DBSelectDistinct filter)` Define a ..WHERE/AND DECIMALSIGN IN (SELECT DISTINCT column FROM table WHERE condition).
`void`	`where_DECIMALSIGN_isEmpty()` Define a ..WHERE/AND (DECIMALSIGN IS NULL OR DECIMALSIGN == '').
`void`	`where_DECIMALSIGN_isNotEmpty()` Define a ..WHERE/AND (DECIMALSIGN IS NOT NULL AND DECIMALSIGN !
`void`	`where_DECIMALSIGN_isNotNull()` Define a ..WHERE/AND DECIMALSIGN IS NOT NULL.
`void`	`where_DECIMALSIGN_isNull()` Define a ..WHERE/AND (DECIMALSIGN IS NULL).
`void`	`where_DECIMALSIGN_like(java.lang.String filter)` Define a filter (AND-ed WHERE) for column DECIMALSIGN DECIMALSIGN.
`void`	`where_DECIMALSIGN(E4DecimalSign filter)` Define a filter (AND-ed WHERE) for column DECIMALSIGN DECIMALSIGN.
`void`	`where_DECIMALSIGN(int operator, E4DecimalSign filter)` Define a filter (AND-ed WHERE) for column DECIMALSIGN DECIMALSIGN.
`void`	`where_EMAIL_in(E4DBSelectDistinct filter)` Define a ..WHERE/AND EMAIL IN (SELECT DISTINCT column FROM table WHERE condition).
`void`	`where_EMAIL_isEmpty()` Define a ..WHERE/AND (EMAIL IS NULL OR EMAIL == '').
`void`	`where_EMAIL_isNotEmpty()` Define a ..WHERE/AND (EMAIL IS NOT NULL AND EMAIL !
`void`	`where_EMAIL_isNotNull()` Define a ..WHERE/AND EMAIL IS NOT NULL.
`void`	`where_EMAIL_isNull()` Define a ..WHERE/AND (EMAIL IS NULL).
`void`	`where_EMAIL(int operator, java.lang.String filter)` Define a filter (AND-ed WHERE) for column EMAIL EMAIL.
`void`	`where_EMAIL(java.lang.String filter)` Define a filter (AND-ed WHERE) for column EMAIL EMAIL.
`void`	`where_FIRSTNAME_in(E4DBSelectDistinct filter)` Define a ..WHERE/AND FIRSTNAME IN (SELECT DISTINCT column FROM table WHERE condition).
`void`	`where_FIRSTNAME_isEmpty()` Define a ..WHERE/AND (FIRSTNAME IS NULL OR FIRSTNAME == '').
`void`	`where_FIRSTNAME_isNotEmpty()` Define a ..WHERE/AND (FIRSTNAME IS NOT NULL AND FIRSTNAME !
`void`	`where_FIRSTNAME_isNotNull()` Define a ..WHERE/AND FIRSTNAME IS NOT NULL.
`void`	`where_FIRSTNAME_isNull()` Define a ..WHERE/AND (FIRSTNAME IS NULL).
`void`	`where_FIRSTNAME(int operator, java.lang.String filter)` Define a filter (AND-ed WHERE) for column FIRSTNAME FIRSTNAME.
`void`	`where_FIRSTNAME(java.lang.String filter)` Define a filter (AND-ed WHERE) for column FIRSTNAME FIRSTNAME.
`void`	`where_GENDER_in(E4DBSelectDistinct filter)` Define a ..WHERE/AND GENDER IN (SELECT DISTINCT column FROM table WHERE condition).
`void`	`where_GENDER(E4Gender filter)` Define a filter (AND-ed WHERE) for column GENDER GENDER.
`void`	`where_GENDER(int operator, E4Gender filter)` Define a filter (AND-ed WHERE) for column GENDER GENDER.
`void`	`where_GIS_LATITUDE(float filter)` Define a filter (AND-ed WHERE) for column GIS_LATITUDE GIS_LATITUDE.
`void`	`where_GIS_LATITUDE(int operator, float filter)` Define a filter (AND-ed WHERE) for column GIS_LATITUDE GIS_LATITUDE.
`void`	`where_GIS_LONGITUDE(float filter)` Define a filter (AND-ed WHERE) for column GIS_LONGITUDE GIS_LONGITUDE.
`void`	`where_GIS_LONGITUDE(int operator, float filter)` Define a filter (AND-ed WHERE) for column GIS_LONGITUDE GIS_LONGITUDE.
`void`	`where_GROUP_ID_in(E4DBSelectDistinct filter)` Define a ..WHERE/AND GROUP_ID IN (SELECT DISTINCT column FROM table WHERE condition).
`void`	`where_GROUP_ID_isEmpty()` Define a ..WHERE/AND (GROUP_ID IS NULL OR GROUP_ID == '').
`void`	`where_GROUP_ID_isNotEmpty()` Define a ..WHERE/AND (GROUP_ID IS NOT NULL AND GROUP_ID !
`void`	`where_GROUP_ID_isNotNull()` Define a ..WHERE/AND GROUP_ID IS NOT NULL.
`void`	`where_GROUP_ID_isNull()` Define a ..WHERE/AND (GROUP_ID IS NULL).
`void`	`where_GROUP_ID_like(java.lang.String filter)` Define a filter (AND-ed WHERE) for column GROUP_ID GROUP_ID.
`void`	`where_GROUP_ID(E4CompanyGroup filter)` Define a filter (AND-ed WHERE) for column GROUP_ID GROUP_ID.
`void`	`where_GROUP_ID(int operator, E4CompanyGroup filter)` Define a filter (AND-ed WHERE) for column GROUP_ID GROUP_ID.
`void`	`where_LASTNAME_in(E4DBSelectDistinct filter)` Define a ..WHERE/AND LASTNAME IN (SELECT DISTINCT column FROM table WHERE condition).
`void`	`where_LASTNAME_isEmpty()` Define a ..WHERE/AND (LASTNAME IS NULL OR LASTNAME == '').
`void`	`where_LASTNAME_isNotEmpty()` Define a ..WHERE/AND (LASTNAME IS NOT NULL AND LASTNAME !
`void`	`where_LASTNAME_isNotNull()` Define a ..WHERE/AND LASTNAME IS NOT NULL.
`void`	`where_LASTNAME_isNull()` Define a ..WHERE/AND (LASTNAME IS NULL).
`void`	`where_LASTNAME(int operator, java.lang.String filter)` Define a filter (AND-ed WHERE) for column LASTNAME LASTNAME.
`void`	`where_LASTNAME(java.lang.String filter)` Define a filter (AND-ed WHERE) for column LASTNAME LASTNAME.
`void`	`where_LOGIN_NAME_in(E4DBSelectDistinct filter)` Define a ..WHERE/AND LOGIN_NAME IN (SELECT DISTINCT column FROM table WHERE condition).
`void`	`where_LOGIN_NAME_isEmpty()` Define a ..WHERE/AND (LOGIN_NAME IS NULL OR LOGIN_NAME == '').
`void`	`where_LOGIN_NAME_isNotEmpty()` Define a ..WHERE/AND (LOGIN_NAME IS NOT NULL AND LOGIN_NAME !
`void`	`where_LOGIN_NAME_isNotNull()` Define a ..WHERE/AND LOGIN_NAME IS NOT NULL.
`void`	`where_LOGIN_NAME_isNull()` Define a ..WHERE/AND (LOGIN_NAME IS NULL).
`void`	`where_LOGIN_NAME(int operator, java.lang.String filter)` Define a filter (AND-ed WHERE) for column LOGIN_NAME LOGIN_NAME.
`void`	`where_LOGIN_NAME(java.lang.String filter)` Define a filter (AND-ed WHERE) for column LOGIN_NAME LOGIN_NAME.
`void`	`where_LOGIN_PASSWORD_in(E4DBSelectDistinct filter)` Define a ..WHERE/AND LOGIN_PASSWORD IN (SELECT DISTINCT column FROM table WHERE condition).
`void`	`where_LOGIN_PASSWORD_isEmpty()` Define a ..WHERE/AND (LOGIN_PASSWORD IS NULL OR LOGIN_PASSWORD == '').
`void`	`where_LOGIN_PASSWORD_isNotEmpty()` Define a ..WHERE/AND (LOGIN_PASSWORD IS NOT NULL AND LOGIN_PASSWORD !
`void`	`where_LOGIN_PASSWORD_isNotNull()` Define a ..WHERE/AND LOGIN_PASSWORD IS NOT NULL.
`void`	`where_LOGIN_PASSWORD_isNull()` Define a ..WHERE/AND (LOGIN_PASSWORD IS NULL).
`void`	`where_LOGIN_PASSWORD(int operator, java.lang.String filter)` Define a filter (AND-ed WHERE) for column LOGIN_PASSWORD LOGIN_PASSWORD.
`void`	`where_LOGIN_PASSWORD(java.lang.String filter)` Define a filter (AND-ed WHERE) for column LOGIN_PASSWORD LOGIN_PASSWORD.
`void`	`where_MIDDLENAME_in(E4DBSelectDistinct filter)` Define a ..WHERE/AND MIDDLENAME IN (SELECT DISTINCT column FROM table WHERE condition).
`void`	`where_MIDDLENAME_isEmpty()` Define a ..WHERE/AND (MIDDLENAME IS NULL OR MIDDLENAME == '').
`void`	`where_MIDDLENAME_isNotEmpty()` Define a ..WHERE/AND (MIDDLENAME IS NOT NULL AND MIDDLENAME !
`void`	`where_MIDDLENAME_isNotNull()` Define a ..WHERE/AND MIDDLENAME IS NOT NULL.
`void`	`where_MIDDLENAME_isNull()` Define a ..WHERE/AND (MIDDLENAME IS NULL).
`void`	`where_MIDDLENAME(int operator, java.lang.String filter)` Define a filter (AND-ed WHERE) for column MIDDLENAME MIDDLENAME.
`void`	`where_MIDDLENAME(java.lang.String filter)` Define a filter (AND-ed WHERE) for column MIDDLENAME MIDDLENAME.
`void`	`where_NAME_in(E4DBSelectDistinct filter)` Define a ..WHERE/AND NAME IN (SELECT DISTINCT column FROM table WHERE condition).
`void`	`where_NAME_isEmpty()` Define a ..WHERE/AND (NAME IS NULL OR NAME == '').
`void`	`where_NAME_isNotEmpty()` Define a ..WHERE/AND (NAME IS NOT NULL AND NAME !
`void`	`where_NAME_isNotNull()` Define a ..WHERE/AND NAME IS NOT NULL.
`void`	`where_NAME_isNull()` Define a ..WHERE/AND (NAME IS NULL).
`void`	`where_NAME(int operator, java.lang.String filter)` Define a filter (AND-ed WHERE) for column NAME NAME.
`void`	`where_NAME(java.lang.String filter)` Define a filter (AND-ed WHERE) for column NAME NAME.
`void`	`where_PHONE01_in(E4DBSelectDistinct filter)` Define a ..WHERE/AND PHONE01 IN (SELECT DISTINCT column FROM table WHERE condition).
`void`	`where_PHONE01_isEmpty()` Define a ..WHERE/AND (PHONE01 IS NULL OR PHONE01 == '').
`void`	`where_PHONE01_isNotEmpty()` Define a ..WHERE/AND (PHONE01 IS NOT NULL AND PHONE01 !
`void`	`where_PHONE01_isNotNull()` Define a ..WHERE/AND PHONE01 IS NOT NULL.
`void`	`where_PHONE01_isNull()` Define a ..WHERE/AND (PHONE01 IS NULL).
`void`	`where_PHONE01(int operator, java.lang.String filter)` Define a filter (AND-ed WHERE) for column PHONE01 PHONE01.
`void`	`where_PHONE01(java.lang.String filter)` Define a filter (AND-ed WHERE) for column PHONE01 PHONE01.
`void`	`where_PHONE02_in(E4DBSelectDistinct filter)` Define a ..WHERE/AND PHONE02 IN (SELECT DISTINCT column FROM table WHERE condition).
`void`	`where_PHONE02_isEmpty()` Define a ..WHERE/AND (PHONE02 IS NULL OR PHONE02 == '').
`void`	`where_PHONE02_isNotEmpty()` Define a ..WHERE/AND (PHONE02 IS NOT NULL AND PHONE02 !
`void`	`where_PHONE02_isNotNull()` Define a ..WHERE/AND PHONE02 IS NOT NULL.
`void`	`where_PHONE02_isNull()` Define a ..WHERE/AND (PHONE02 IS NULL).
`void`	`where_PHONE02(int operator, java.lang.String filter)` Define a filter (AND-ed WHERE) for column PHONE02 PHONE02.
`void`	`where_PHONE02(java.lang.String filter)` Define a filter (AND-ed WHERE) for column PHONE02 PHONE02.
`void`	`where_REM_in(E4DBSelectDistinct filter)` Define a ..WHERE/AND REM IN (SELECT DISTINCT column FROM table WHERE condition).
`void`	`where_REM_isEmpty()` Define a ..WHERE/AND (REM IS NULL OR REM == '').
`void`	`where_REM_isNotEmpty()` Define a ..WHERE/AND (REM IS NOT NULL AND REM !
`void`	`where_REM_isNotNull()` Define a ..WHERE/AND REM IS NOT NULL.
`void`	`where_REM_isNull()` Define a ..WHERE/AND (REM IS NULL).
`void`	`where_REM(int operator, java.lang.String filter)` Define a filter (AND-ed WHERE) for column REM REM.
`void`	`where_REM(java.lang.String filter)` Define a filter (AND-ed WHERE) for column REM REM.
`void`	`where_SATURATION_in(E4DBSelectDistinct filter)` Define a ..WHERE/AND SATURATION IN (SELECT DISTINCT column FROM table WHERE condition).
`void`	`where_SATURATION_isEmpty()` Define a ..WHERE/AND (SATURATION IS NULL OR SATURATION == '').
`void`	`where_SATURATION_isNotEmpty()` Define a ..WHERE/AND (SATURATION IS NOT NULL AND SATURATION !
`void`	`where_SATURATION_isNotNull()` Define a ..WHERE/AND SATURATION IS NOT NULL.
`void`	`where_SATURATION_isNull()` Define a ..WHERE/AND (SATURATION IS NULL).
`void`	`where_SATURATION(int operator, java.lang.String filter)` Define a filter (AND-ed WHERE) for column SATURATION SATURATION.
`void`	`where_SATURATION(java.lang.String filter)` Define a filter (AND-ed WHERE) for column SATURATION SATURATION.
`void`	`where_TIMEFORMAT_in(E4DBSelectDistinct filter)` Define a ..WHERE/AND TIMEFORMAT IN (SELECT DISTINCT column FROM table WHERE condition).
`void`	`where_TIMEFORMAT_isEmpty()` Define a ..WHERE/AND (TIMEFORMAT IS NULL OR TIMEFORMAT == '').
`void`	`where_TIMEFORMAT_isNotEmpty()` Define a ..WHERE/AND (TIMEFORMAT IS NOT NULL AND TIMEFORMAT !
`void`	`where_TIMEFORMAT_isNotNull()` Define a ..WHERE/AND TIMEFORMAT IS NOT NULL.
`void`	`where_TIMEFORMAT_isNull()` Define a ..WHERE/AND (TIMEFORMAT IS NULL).
`void`	`where_TIMEFORMAT(int operator, java.lang.String filter)` Define a filter (AND-ed WHERE) for column TIMEFORMAT TIMEFORMAT.
`void`	`where_TIMEFORMAT(java.lang.String filter)` Define a filter (AND-ed WHERE) for column TIMEFORMAT TIMEFORMAT.
`void`	`where_TIMEZONE(int operator, TimeZone filter)` Define a filter (AND-ed WHERE) for column TIMEZONE TIMEZONE.
`void`	`where_TIMEZONE(TimeZone filter)` Define a filter (AND-ed WHERE) for column TIMEZONE TIMEZONE.
`void`	`where_U_in(E4DBSelectDistinct filter)` Define a ..WHERE/AND U IN (SELECT DISTINCT column FROM table WHERE condition).
`void`	`where_U_isEmpty()` Define a ..WHERE/AND (U IS NULL OR U == '').
`void`	`where_U_isNotEmpty()` Define a ..WHERE/AND (U IS NOT NULL AND U !
`void`	`where_U_isNotNull()` Define a ..WHERE/AND U IS NOT NULL.
`void`	`where_U_isNull()` Define a ..WHERE/AND (U IS NULL).
`void`	`where_U_like(java.lang.String filter)` Define a filter (AND-ed WHERE) for column U U.
`void`	`where_U(E4CompanyUserId filter)` Define a filter (AND-ed WHERE) for column U U.
`void`	`where_U(int operator, E4CompanyUserId filter)` Define a filter (AND-ed WHERE) for column U U.
`void`	`where_UID_in(E4DBSelectDistinct filter)` Define a ..WHERE/AND UID IN (SELECT DISTINCT column FROM table WHERE condition).
`void`	`where_UID_isEmpty()` Define a ..WHERE/AND (UID IS NULL OR UID == '').
`void`	`where_UID_isNotEmpty()` Define a ..WHERE/AND (UID IS NOT NULL AND UID !
`void`	`where_UID_isNotNull()` Define a ..WHERE/AND UID IS NOT NULL.
`void`	`where_UID_isNull()` Define a ..WHERE/AND (UID IS NULL).
`void`	`where_UID(int operator, java.lang.String filter)` Define a filter (AND-ed WHERE) for column UID UID.
`void`	`where_UID(java.lang.String filter)` Define a filter (AND-ed WHERE) for column UID UID.
`void`	`where_VALID_UNTIL_in(E4DBSelectDistinct filter)` Define a ..WHERE/AND VALID_UNTIL IN (SELECT DISTINCT column FROM table WHERE condition).
`void`	`where_VALID_UNTIL_isEmpty()` Define a ..WHERE/AND (VALID_UNTIL IS NULL OR VALID_UNTIL == '').
`void`	`where_VALID_UNTIL_isNotEmpty()` Define a ..WHERE/AND (VALID_UNTIL IS NOT NULL AND VALID_UNTIL !
`void`	`where_VALID_UNTIL_isNotNull()` Define a ..WHERE/AND VALID_UNTIL IS NOT NULL.
`void`	`where_VALID_UNTIL_isNull()` Define a ..WHERE/AND (VALID_UNTIL IS NULL).
`void`	`where_VALID_UNTIL(java.util.Date filter)` Define a filter (AND-ed WHERE) for column VALID_UNTIL VALID_UNTIL.
`void`	`where_VALID_UNTIL(int operator, java.util.Date filter)` Define a filter (AND-ed WHERE) for column VALID_UNTIL VALID_UNTIL.
`void`	`where_WWW_in(E4DBSelectDistinct filter)` Define a ..WHERE/AND WWW IN (SELECT DISTINCT column FROM table WHERE condition).
`void`	`where_WWW_isEmpty()` Define a ..WHERE/AND (WWW IS NULL OR WWW == '').
`void`	`where_WWW_isNotEmpty()` Define a ..WHERE/AND (WWW IS NOT NULL AND WWW !
`void`	`where_WWW_isNotNull()` Define a ..WHERE/AND WWW IS NOT NULL.
`void`	`where_WWW_isNull()` Define a ..WHERE/AND (WWW IS NULL).
`void`	`where_WWW(int operator, java.lang.String filter)` Define a filter (AND-ed WHERE) for column WWW WWW.
`void`	`where_WWW(java.lang.String filter)` Define a filter (AND-ed WHERE) for column WWW WWW.
`void`	`where_ZIPCODE_in(E4DBSelectDistinct filter)` Define a ..WHERE/AND ZIPCODE IN (SELECT DISTINCT column FROM table WHERE condition).
`void`	`where_ZIPCODE_isEmpty()` Define a ..WHERE/AND (ZIPCODE IS NULL OR ZIPCODE == '').
`void`	`where_ZIPCODE_isNotEmpty()` Define a ..WHERE/AND (ZIPCODE IS NOT NULL AND ZIPCODE !
`void`	`where_ZIPCODE_isNotNull()` Define a ..WHERE/AND ZIPCODE IS NOT NULL.
`void`	`where_ZIPCODE_isNull()` Define a ..WHERE/AND (ZIPCODE IS NULL).
`void`	`where_ZIPCODE(int operator, java.lang.String filter)` Define a filter (AND-ed WHERE) for column ZIPCODE ZIPCODE.
`void`	`where_ZIPCODE(java.lang.String filter)` Define a filter (AND-ed WHERE) for column ZIPCODE ZIPCODE.
`void`	`whereQuery_ADDRESS01(java.lang.String queryexpression)` Define a query based filter (AND-ed WHERE) for column ADDRESS01, the data might contain wildcard characters or a , seperated list ADDRESS01.
`void`	`whereQuery_ADDRESS02(java.lang.String queryexpression)` Define a query based filter (AND-ed WHERE) for column ADDRESS02, the data might contain wildcard characters or a , seperated list ADDRESS02.
`void`	`whereQuery_CITY(java.lang.String queryexpression)` Define a query based filter (AND-ed WHERE) for column CITY, the data might contain wildcard characters or a , seperated list CITY.
`void`	`whereQuery_DATEFORMAT(java.lang.String queryexpression)` Define a query based filter (AND-ed WHERE) for column DATEFORMAT, the data might contain wildcard characters or a , seperated list DATEFORMAT.
`void`	`whereQuery_DECIMALSIGN(java.lang.String queryexpression)` Define a query based filter (AND-ed WHERE) for column DECIMALSIGN, the data might contain wildcard characters or a , seperated list DECIMALSIGN.
`void`	`whereQuery_EMAIL(java.lang.String queryexpression)` Define a query based filter (AND-ed WHERE) for column EMAIL, the data might contain wildcard characters or a , seperated list EMAIL.
`void`	`whereQuery_FIRSTNAME(java.lang.String queryexpression)` Define a query based filter (AND-ed WHERE) for column FIRSTNAME, the data might contain wildcard characters or a , seperated list FIRSTNAME.
`void`	`whereQuery_GROUP_ID(java.lang.String queryexpression)` Define a query based filter (AND-ed WHERE) for column GROUP_ID, the data might contain wildcard characters or a , seperated list GROUP_ID.
`void`	`whereQuery_LASTNAME(java.lang.String queryexpression)` Define a query based filter (AND-ed WHERE) for column LASTNAME, the data might contain wildcard characters or a , seperated list LASTNAME.
`void`	`whereQuery_LOGIN_NAME(java.lang.String queryexpression)` Define a query based filter (AND-ed WHERE) for column LOGIN_NAME, the data might contain wildcard characters or a , seperated list LOGIN_NAME.
`void`	`whereQuery_LOGIN_PASSWORD(java.lang.String queryexpression)` Define a query based filter (AND-ed WHERE) for column LOGIN_PASSWORD, the data might contain wildcard characters or a , seperated list LOGIN_PASSWORD.
`void`	`whereQuery_MIDDLENAME(java.lang.String queryexpression)` Define a query based filter (AND-ed WHERE) for column MIDDLENAME, the data might contain wildcard characters or a , seperated list MIDDLENAME.
`void`	`whereQuery_NAME(java.lang.String queryexpression)` Define a query based filter (AND-ed WHERE) for column NAME, the data might contain wildcard characters or a , seperated list NAME.
`void`	`whereQuery_PHONE01(java.lang.String queryexpression)` Define a query based filter (AND-ed WHERE) for column PHONE01, the data might contain wildcard characters or a , seperated list PHONE01.
`void`	`whereQuery_PHONE02(java.lang.String queryexpression)` Define a query based filter (AND-ed WHERE) for column PHONE02, the data might contain wildcard characters or a , seperated list PHONE02.
`void`	`whereQuery_REM(java.lang.String queryexpression)` Define a query based filter (AND-ed WHERE) for column REM, the data might contain wildcard characters or a , seperated list REM.
`void`	`whereQuery_SATURATION(java.lang.String queryexpression)` Define a query based filter (AND-ed WHERE) for column SATURATION, the data might contain wildcard characters or a , seperated list SATURATION.
`void`	`whereQuery_TIMEFORMAT(java.lang.String queryexpression)` Define a query based filter (AND-ed WHERE) for column TIMEFORMAT, the data might contain wildcard characters or a , seperated list TIMEFORMAT.
`void`	`whereQuery_U(java.lang.String queryexpression)` Define a query based filter (AND-ed WHERE) for column U, the data might contain wildcard characters or a , seperated list U.
`void`	`whereQuery_UID(java.lang.String queryexpression)` Define a query based filter (AND-ed WHERE) for column UID, the data might contain wildcard characters or a , seperated list UID.
`void`	`whereQuery_WWW(java.lang.String queryexpression)` Define a query based filter (AND-ed WHERE) for column WWW, the data might contain wildcard characters or a , seperated list WWW.
`void`	`whereQuery_ZIPCODE(java.lang.String queryexpression)` Define a query based filter (AND-ed WHERE) for column ZIPCODE, the data might contain wildcard characters or a , seperated list ZIPCODE.

Methods inherited from class e4s.db.E4DBSelectView
`createFIELDSET, get_FIELDSET, get, getModifyClass, getObjectClass, getUsage, isTable, isView, makeInstance_Modify`

Methods inherited from class e4s.db.E4DBSelect
checkConsistencyIndex, checkConsistencyIndex, checkConsistencyTable, checkConsistencyTable, checkConsistencyTable, close, data2csv, data2csv, data2csv, data2csv, data2csv, data2csv, data2csv, data2csvHeader, data2csvHeader, disableLogging, enableLogging, enableUnicode, executeCount, executeCountQuery, executeCountQuery, executeCountQuery, executeDistinctQuery, executeDistinctQuery, executeMax, executeMaxDate, executeMaxString, executeMin, executeMinDate, executeMinString, executeQuery, executeQuery, executeQuery, executeSQL, executeSQL, executeSQL, executeSumQuery, executeSumQuery, executeSumQuery, finalize, getBoolean, getConnection, getDate, getDistinctData, getDouble, getE4Long, getE4String, getFirstPrimaryIndex, getFloat, getInt, getLong, getMetaData, getReferenceDelete, getReferenceLookup, getResultSet, getStatement, getString, getTableName, isLogging, isUnicodeEnabled, next, removeOwnTableColumn, reset, resetOrderBy, setConnection, setFilterQuery, setFilterQuery, setOrderBy, setOrderBy, setOrderExtended, supportsSorting, toDate, toString, toString

Methods inherited from class e4s.db.E4DBSelect

checkConsistencyIndex, checkConsistencyIndex, checkConsistencyTable, checkConsistencyTable, checkConsistencyTable, close, data2csv, data2csv, data2csv, data2csv, data2csv, data2csv, data2csv, data2csvHeader, data2csvHeader, disableLogging, enableLogging, enableUnicode, executeCount, executeCountQuery, executeCountQuery, executeCountQuery, executeDistinctQuery, executeDistinctQuery, executeMax, executeMaxDate, executeMaxString, executeMin, executeMinDate, executeMinString, executeQuery, executeQuery, executeQuery, executeSQL, executeSQL, executeSQL, executeSumQuery, executeSumQuery, executeSumQuery, finalize, getBoolean, getConnection, getDate, getDistinctData, getDouble, getE4Long, getE4String, getFirstPrimaryIndex, getFloat, getInt, getLong, getMetaData, getReferenceDelete, getReferenceLookup, getResultSet, getStatement, getString, getTableName, isLogging, isUnicodeEnabled, next, removeOwnTableColumn, reset, resetOrderBy, setConnection, setFilterQuery, setFilterQuery, setOrderBy, setOrderBy, setOrderExtended, supportsSorting, toDate, toString, toString

Methods inherited from class e4s.db.E4DBFilterAnd
`getWhere, isEmpty, isNotEmpty, isNotNull, isNull, OR, setFilter_NOT, setFilter_NOT, setFilter_NOT, setFilter_NOT, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter`

Methods inherited from class e4s.db.E4DBFilterAnd

getWhere, isEmpty, isNotEmpty, isNotNull, isNull, OR, setFilter_NOT, setFilter_NOT, setFilter_NOT, setFilter_NOT, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter

Methods inherited from class e4s.db.E4DBFilter
`Escape, Escape, getApplObj, getClient, getSession, getWhere, isWhereDefined, OP, resetWhere, setFilter_IN, setFilter_IN, setFilter_IN, setFilter_IN, setFilter_IN, setFilter_NOT_IN, setFilter_NOT_IN, setFilter_NOT_IN, setFilter_NOT_IN, setFilter_NOT_IN, setFilter, setFilter, setWhere, toString`

Methods inherited from class e4s.util.E4Object
Calendar, CName, CName, E4LabelApp, E4LabelApp, E4LabelApp, E4LabelApp, E4LabelApp, E4LabelApp, E4LabelNone, E4LabelNone, E4LabelNone, E4LabelNone, E4LabelSys, E4LabelSys, e4sCopyright, e4sVersion, encode, encode, encode, encodeHtml, encodeHtml, encodeHtml, encodeURL, encodeURL, encodeURL, getLINE, getTRACE, getTRACE, getTRACE, getTRACE, getTRACE, getTRACE, getTraceMemory, HtmlEncode, HtmlEncode, HtmlEncode, isdecimal, isdigit, isnotok, isnotok, isnumeric, isok, isok, isok, isok, lastCallingFunction, lastCallingFunction, lastCallingFunction, lastCallingFunction, lastCallingStack, mkdirs, null2nbsp, null2nbsp, null2nbsp, ok, ok, ok, ok, outPrintln, setLogFile4Trace, setTraceMemory, STACKTRACE, toDebug, toDouble, toFloat, toFloat, TRACE_CALLS, TRACE, TRACE, TRACE, TRACE, TRACE, TRACE, TRACE, TRACE, TRACE, TRACE, TRACE, TRACE, wait

Methods inherited from class e4s.util.E4Object

Calendar, CName, CName, E4LabelApp, E4LabelApp, E4LabelApp, E4LabelApp, E4LabelApp, E4LabelApp, E4LabelNone, E4LabelNone, E4LabelNone, E4LabelNone, E4LabelSys, E4LabelSys, e4sCopyright, e4sVersion, encode, encode, encode, encodeHtml, encodeHtml, encodeHtml, encodeURL, encodeURL, encodeURL, getLINE, getTRACE, getTRACE, getTRACE, getTRACE, getTRACE, getTRACE, getTraceMemory, HtmlEncode, HtmlEncode, HtmlEncode, isdecimal, isdigit, isnotok, isnotok, isnumeric, isok, isok, isok, isok, lastCallingFunction, lastCallingFunction, lastCallingFunction, lastCallingFunction, lastCallingStack, mkdirs, null2nbsp, null2nbsp, null2nbsp, ok, ok, ok, ok, outPrintln, setLogFile4Trace, setTraceMemory, STACKTRACE, toDebug, toDouble, toFloat, toFloat, TRACE_CALLS, TRACE, TRACE, TRACE, TRACE, TRACE, TRACE, TRACE, TRACE, TRACE, TRACE, TRACE, TRACE, wait

Methods inherited from class java.lang.Object
`clone, equals, getClass, hashCode, notify, notifyAll, wait, wait, wait`

Methods inherited from interface e4s.db.E4DBSelect_Intf
`close, createFIELDSET, executeQuery, get_FIELDSET, get, getApplObj, getBoolean, getConnection, getDate, getFirstPrimaryIndex, getFloat, getLong, getMetaData, getModifyClass, getObjectClass, getReferenceDelete, getReferenceLookup, getString, getTableName, getUsage, getWhere, isTable, isView, isWhereDefined, makeInstance_Modify, next, reset, resetOrderBy, resetWhere, setConnection, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setOrderBy, setWhere, supportsSorting, toString`

Methods inherited from interface e4s.db.E4DBSelect_Intf

close, createFIELDSET, executeQuery, get_FIELDSET, get, getApplObj, getBoolean, getConnection, getDate, getFirstPrimaryIndex, getFloat, getLong, getMetaData, getModifyClass, getObjectClass, getReferenceDelete, getReferenceLookup, getString, getTableName, getUsage, getWhere, isTable, isView, isWhereDefined, makeInstance_Modify, next, reset, resetOrderBy, resetWhere, setConnection, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setOrderBy, setWhere, supportsSorting, toString

Methods inherited from interface e4s.db.E4DBFilter_Intf
`isWhereDefined, resetWhere`

Field Detail

VIEWNAME

public static final E4DBTableName VIEWNAME

Name of the view

IS_CLIENT_DISTINCTIVE

public static final boolean IS_CLIENT_DISTINCTIVE

This view is client distinctive.

See Also:: hasClientDistinctive(), Constant Field Values

TABLE_A

public static final E4DBTableName TABLE_A

Table involved T_E4S_COMPANY Hold Information about companies, users are related to companies..

See Also:: T_E4S_COMPANY_Sel

TABLE_B

public static final E4DBTableName TABLE_B

Table involved T_E4S_COMPANY_USER Users related to companies, here you will find login information of users and personal settings such as date formats..

See Also:: T_E4S_COMPANY_USER_Sel

COL_ADDRESS01

public static final E4DBColumnName COL_ADDRESS01

T_E4S_COMPANY_Sel.COL_ADDRESS01 ADDRESS01. STRING(60) Address Line #1

CI_ADDRESS01

public static final E4DBColumnInfo CI_ADDRESS01

COL_ADDRESS02

public static final E4DBColumnName COL_ADDRESS02

T_E4S_COMPANY_Sel.COL_ADDRESS02 ADDRESS02. STRING(60) Address Line #2

CI_ADDRESS02

public static final E4DBColumnInfo CI_ADDRESS02

COL_CITY

public static final E4DBColumnName COL_CITY

T_E4S_COMPANY_Sel.COL_CITY CITY. STRING(60) City

CI_CITY

public static final E4DBColumnInfo CI_CITY

COL_COUNTRYCODE

public static final E4DBColumnName COL_COUNTRYCODE

T_E4S_COMPANY_Sel.COL_COUNTRYCODE COUNTRYCODE. CountryCode Countrycode

CI_COUNTRYCODE

public static final E4DBColumnInfo CI_COUNTRYCODE

COL_DATNEW

public static final E4DBColumnName COL_DATNEW

T_E4S_COMPANY_Sel.COL_DATNEW DATNEW. DATE Date created

CI_DATNEW

public static final E4DBColumnInfo CI_DATNEW

COL_GIS_LATITUDE

public static final E4DBColumnName COL_GIS_LATITUDE

T_E4S_COMPANY_Sel.COL_GIS_LATITUDE GIS_LATITUDE. FLOAT GIS Latitude

CI_GIS_LATITUDE

public static final E4DBColumnInfo CI_GIS_LATITUDE

COL_GIS_LONGITUDE

public static final E4DBColumnName COL_GIS_LONGITUDE

T_E4S_COMPANY_Sel.COL_GIS_LONGITUDE GIS_LONGITUDE. FLOAT GIS Longitude

CI_GIS_LONGITUDE

public static final E4DBColumnInfo CI_GIS_LONGITUDE

COL_GROUP_ID

public static final E4DBColumnName COL_GROUP_ID

T_E4S_COMPANY_Sel.COL_GROUP_ID GROUP_ID. E4CompanyGroup defined as e4s.util.E4String(16) Company Group Belongs to Group

See Also:: E4CompanyGroup

CI_GROUP_ID

public static final E4DBColumnInfo CI_GROUP_ID

COL_LOGIN_NAME

public static final E4DBColumnName COL_LOGIN_NAME

T_E4S_COMPANY_Sel.COL_LOGIN_NAME LOGIN_NAME. STRING(16) Name for login

CI_LOGIN_NAME

public static final E4DBColumnInfo CI_LOGIN_NAME

COL_NAME

public static final E4DBColumnName COL_NAME

T_E4S_COMPANY_Sel.COL_NAME NAME. STRING(60) Company Name

CI_NAME

public static final E4DBColumnInfo CI_NAME

COL_PHONE01

public static final E4DBColumnName COL_PHONE01

T_E4S_COMPANY_Sel.COL_PHONE01 PHONE01. STRING(60) Phone #1

CI_PHONE01

public static final E4DBColumnInfo CI_PHONE01

COL_PHONE02

public static final E4DBColumnName COL_PHONE02

T_E4S_COMPANY_Sel.COL_PHONE02 PHONE02. STRING(60) Phone #2

CI_PHONE02

public static final E4DBColumnInfo CI_PHONE02

COL_REM

public static final E4DBColumnName COL_REM

T_E4S_COMPANY_Sel.COL_REM REM. STRING(255) Remark

CI_REM

public static final E4DBColumnInfo CI_REM

COL_UID

public static final E4DBColumnName COL_UID

T_E4S_COMPANY_Sel.COL_UID UID. STRING(14) VAT Number

CI_UID

public static final E4DBColumnInfo CI_UID

COL_VALID_UNTIL

public static final E4DBColumnName COL_VALID_UNTIL

T_E4S_COMPANY_Sel.COL_VALID_UNTIL VALID_UNTIL. DATE Valid until

CI_VALID_UNTIL

public static final E4DBColumnInfo CI_VALID_UNTIL

COL_WWW

public static final E4DBColumnName COL_WWW

T_E4S_COMPANY_Sel.COL_WWW WWW. STRING(60) WWW Address

CI_WWW

public static final E4DBColumnInfo CI_WWW

COL_ZIPCODE

public static final E4DBColumnName COL_ZIPCODE

T_E4S_COMPANY_Sel.COL_ZIPCODE ZIPCODE. STRING(10) ZIP Code

CI_ZIPCODE

public static final E4DBColumnInfo CI_ZIPCODE

COL_DATEFORMAT

public static final E4DBColumnName COL_DATEFORMAT

T_E4S_COMPANY_USER_Sel.COL_DATEFORMAT DATEFORMAT. STRING(10) Date-Format, e,g, dd.MM.yyyy

CI_DATEFORMAT

public static final E4DBColumnInfo CI_DATEFORMAT

COL_DECIMALSIGN

public static final E4DBColumnName COL_DECIMALSIGN

T_E4S_COMPANY_USER_Sel.COL_DECIMALSIGN DECIMALSIGN. E4DecimalSign defined as e4s.util.E4String(1) Definition for Decimal Sign, related to Client/User Decimal Sign

See Also:: E4DecimalSign

CI_DECIMALSIGN

public static final E4DBColumnInfo CI_DECIMALSIGN

COL_EMAIL

public static final E4DBColumnName COL_EMAIL

T_E4S_COMPANY_USER_Sel.COL_EMAIL EMAIL. STRING(80) User�s E-Mail address

CI_EMAIL

public static final E4DBColumnInfo CI_EMAIL

COL_FIRSTNAME

public static final E4DBColumnName COL_FIRSTNAME

T_E4S_COMPANY_USER_Sel.COL_FIRSTNAME FIRSTNAME. STRING(60) Firstname

CI_FIRSTNAME

public static final E4DBColumnInfo CI_FIRSTNAME

COL_GENDER

public static final E4DBColumnName COL_GENDER

T_E4S_COMPANY_USER_Sel.COL_GENDER GENDER. E4Gender defined as e4s.util.E4Long male, female

See Also:: E4Gender

CI_GENDER

public static final E4DBColumnInfo CI_GENDER

COL_LASTNAME

public static final E4DBColumnName COL_LASTNAME

T_E4S_COMPANY_USER_Sel.COL_LASTNAME LASTNAME. STRING(60) Lastname

CI_LASTNAME

public static final E4DBColumnInfo CI_LASTNAME

COL_U

public static final E4DBColumnName COL_U

T_E4S_COMPANY_USER_Sel.COL_LOGIN_NAME LOGIN_NAME. E4CompanyUserId defined as e4s.util.E4String(16) User login name, unique identification for the user in the login process. UserId for login, unique identification

See Also:: E4CompanyUserId

CI_U

public static final E4DBColumnInfo CI_U

COL_LOGIN_PASSWORD

public static final E4DBColumnName COL_LOGIN_PASSWORD

T_E4S_COMPANY_USER_Sel.COL_LOGIN_PASSWORD LOGIN_PASSWORD. STRING(32) Password

CI_LOGIN_PASSWORD

public static final E4DBColumnInfo CI_LOGIN_PASSWORD

COL_MIDDLENAME

public static final E4DBColumnName COL_MIDDLENAME

T_E4S_COMPANY_USER_Sel.COL_MIDDLENAME MIDDLENAME. STRING(1) Middlename

CI_MIDDLENAME

public static final E4DBColumnInfo CI_MIDDLENAME

COL_SATURATION

public static final E4DBColumnName COL_SATURATION

T_E4S_COMPANY_USER_Sel.COL_SATURATION SATURATION. STRING(12) Saturation (e.g. Dr.)

CI_SATURATION

public static final E4DBColumnInfo CI_SATURATION

COL_TIMEFORMAT

public static final E4DBColumnName COL_TIMEFORMAT

T_E4S_COMPANY_USER_Sel.COL_TIMEFORMAT TIMEFORMAT. STRING(10) Time-Format, e.g. HH:mm:ss

CI_TIMEFORMAT

public static final E4DBColumnInfo CI_TIMEFORMAT

COL_TIMEZONE

public static final E4DBColumnName COL_TIMEZONE

T_E4S_COMPANY_USER_Sel.COL_TIMEZONE TIMEZONE. TimeZone Relative Timezone to GMT

CI_TIMEZONE

public static final E4DBColumnInfo CI_TIMEZONE

COLUMNS

public static final E4DBColumnInfo[] COLUMNS

Definition of view selection columns as array.

See Also:: getColInfo()

SQL

public static final java.lang.String SQL

See Also:: Constant Field Values

Constructor Detail

V_E4S_USERS_Sel

public V_E4S_USERS_Sel(E4DBConnection_Intf dbcon,
                       E4ApplObj_Intf applobj)

Construct an object for selecting data from V_E4S_USERS using a database connection, the table uses client distinction.

Parameters:: dbcon - a database connection; applobj - an application object, containing client and other information
See Also:: E4ModuleImplementation.getApplObj(), E4ServletImplementation_Intf.getApplObj()

V_E4S_USERS_Sel

public V_E4S_USERS_Sel(E4ApplObj_Intf applobj)
                throws E4DBException

Construct an object for selecting data from V_E4S_USERS using the default database connection, the table uses client distinction.

Parameters:: applobj - an application object, containing client and other information
Throws:: E4DBException
See Also:: E4ModuleImplementation.getApplObj(), E4ServletImplementation_Intf.getApplObj()

V_E4S_USERS_Sel

public V_E4S_USERS_Sel(V_E4S_USERS_Sel V_E4S_USERS,
                       boolean copy_where)
                throws E4DBException

Throws:: E4DBException

Method Detail

E4ID

public E4ID E4ID()

hasClientDistinctive

public boolean hasClientDistinctive()

Get the state if data of this table will be distincted by E4Client. This is the case, if the E4ApplObj_Intf object was involved during construction of the object.

Specified by:: hasClientDistinctive in interface E4DBSelect_Intf

Returns:: true
See Also:: E4Client, IS_CLIENT_DISTINCTIVE

canHaveFreeDefinedFields

public boolean canHaveFreeDefinedFields()

Check, if this table might have freedefined fields. This function is for compatibility reasons only.

Specified by:: canHaveFreeDefinedFields in interface E4DBSelect_Intf

Returns:: false

getColInfo

public E4DBColumnInfo[] getColInfo()

Get information about the columns defined for this database table.

Specified by:: getColInfo in interface E4DBSelect_Intf

Returns:: null if no columns are defined, an array of E4DBColumnType objects

makeInstance

public E4DBSelect_Intf makeInstance(boolean copy_where)
                             throws E4DBException

Create a new instance for V_E4S_USERS_Sel

Specified by:: makeInstance in interface E4DBSelect_Intf

Parameters:: copy_where - if true, the WHERE statement from the table is also copied to the new created table.
Throws:: E4DBException

get_ADDRESS01

public java.lang.String get_ADDRESS01()
                               throws E4DBException

Get data for column ADDRESS01 ADDRESS01. STRING(60) Address Line #1

Throws:: E4DBException

get_ADDRESS02

public java.lang.String get_ADDRESS02()
                               throws E4DBException

Get data for column ADDRESS02 ADDRESS02. STRING(60) Address Line #2

Throws:: E4DBException

get_CITY

public java.lang.String get_CITY()
                          throws E4DBException

Get data for column CITY CITY. STRING(60) City

Throws:: E4DBException

get_COUNTRYCODE

public CountryCode get_COUNTRYCODE()
                            throws E4DBException

Get data for column COUNTRYCODE COUNTRYCODE. CountryCode Countrycode

Throws:: E4DBException

get_DATNEW

public java.util.Date get_DATNEW()
                          throws E4DBException

Get data for column DATNEW DATNEW. DATE Date created

Throws:: E4DBException

get_GIS_LATITUDE

public float get_GIS_LATITUDE()
                       throws E4DBException

Get data for column GIS_LATITUDE GIS_LATITUDE. FLOAT GIS Latitude

Throws:: E4DBException

get_GIS_LONGITUDE

public float get_GIS_LONGITUDE()
                        throws E4DBException

Get data for column GIS_LONGITUDE GIS_LONGITUDE. FLOAT GIS Longitude

Throws:: E4DBException

get_GROUP_ID

public E4CompanyGroup get_GROUP_ID()
                            throws E4DBException

Get data for column GROUP_ID GROUP_ID. E4CompanyGroup defined as e4s.util.E4String(16) Company Group Belongs to Group

Throws:: E4DBException
See Also:: E4CompanyGroup

get_LOGIN_NAME

public java.lang.String get_LOGIN_NAME()
                                throws E4DBException

Get data for column LOGIN_NAME LOGIN_NAME. STRING(16) Name for login

Throws:: E4DBException

get_NAME

public java.lang.String get_NAME()
                          throws E4DBException

Get data for column NAME NAME. STRING(60) Company Name

Throws:: E4DBException

get_PHONE01

public java.lang.String get_PHONE01()
                             throws E4DBException

Get data for column PHONE01 PHONE01. STRING(60) Phone #1

Throws:: E4DBException

get_PHONE02

public java.lang.String get_PHONE02()
                             throws E4DBException

Get data for column PHONE02 PHONE02. STRING(60) Phone #2

Throws:: E4DBException

get_REM

public java.lang.String get_REM()
                         throws E4DBException

Get data for column REM REM. STRING(255) Remark

Throws:: E4DBException

get_UID

public java.lang.String get_UID()
                         throws E4DBException

Get data for column UID UID. STRING(14) VAT Number

Throws:: E4DBException

get_VALID_UNTIL

public java.util.Date get_VALID_UNTIL()
                               throws E4DBException

Get data for column VALID_UNTIL VALID_UNTIL. DATE Valid until

Throws:: E4DBException

get_WWW

public java.lang.String get_WWW()
                         throws E4DBException

Get data for column WWW WWW. STRING(60) WWW Address

Throws:: E4DBException

get_ZIPCODE

public java.lang.String get_ZIPCODE()
                             throws E4DBException

Get data for column ZIPCODE ZIPCODE. STRING(10) ZIP Code

Throws:: E4DBException

get_DATEFORMAT

public java.lang.String get_DATEFORMAT()
                                throws E4DBException

Get data for column DATEFORMAT DATEFORMAT. STRING(10) Date-Format, e,g, dd.MM.yyyy

Throws:: E4DBException

get_DECIMALSIGN

public E4DecimalSign get_DECIMALSIGN()
                              throws E4DBException

Get data for column DECIMALSIGN DECIMALSIGN. E4DecimalSign defined as e4s.util.E4String(1) Definition for Decimal Sign, related to Client/User Decimal Sign

Throws:: E4DBException
See Also:: E4DecimalSign

get_EMAIL

public java.lang.String get_EMAIL()
                           throws E4DBException

Get data for column EMAIL EMAIL. STRING(80) User�s E-Mail address

Throws:: E4DBException

get_FIRSTNAME

public java.lang.String get_FIRSTNAME()
                               throws E4DBException

Get data for column FIRSTNAME FIRSTNAME. STRING(60) Firstname

Throws:: E4DBException

get_GENDER

public E4Gender get_GENDER()
                    throws E4DBException

Get data for column GENDER GENDER. E4Gender defined as e4s.util.E4Long male, female

Throws:: E4DBException
See Also:: E4Gender

get_LASTNAME

public java.lang.String get_LASTNAME()
                              throws E4DBException

Get data for column LASTNAME LASTNAME. STRING(60) Lastname

Throws:: E4DBException

get_U

public E4CompanyUserId get_U()
                      throws E4DBException

Get data for column U U. E4CompanyUserId defined as e4s.util.E4String(16) User login name, unique identification for the user in the login process. UserId for login, unique identification

Throws:: E4DBException
See Also:: E4CompanyUserId

get_LOGIN_PASSWORD

public java.lang.String get_LOGIN_PASSWORD()
                                    throws E4DBException

Get data for column LOGIN_PASSWORD LOGIN_PASSWORD. STRING(32) Password

Throws:: E4DBException

get_MIDDLENAME

public java.lang.String get_MIDDLENAME()
                                throws E4DBException

Get data for column MIDDLENAME MIDDLENAME. STRING(1) Middlename

Throws:: E4DBException

get_SATURATION

public java.lang.String get_SATURATION()
                                throws E4DBException

Get data for column SATURATION SATURATION. STRING(12) Saturation (e.g. Dr.)

Throws:: E4DBException

get_TIMEFORMAT

public java.lang.String get_TIMEFORMAT()
                                throws E4DBException

Get data for column TIMEFORMAT TIMEFORMAT. STRING(10) Time-Format, e.g. HH:mm:ss

Throws:: E4DBException

get_TIMEZONE

public TimeZone get_TIMEZONE()
                      throws E4DBException

Get data for column TIMEZONE TIMEZONE. TimeZone Relative Timezone to GMT

Throws:: E4DBException

where_ADDRESS01

public void where_ADDRESS01(java.lang.String filter)
                     throws E4DBException

Define a filter (AND-ed WHERE) for column ADDRESS01 ADDRESS01. STRING(60) Address Line #1

Throws:: E4DBException

where_ADDRESS01

public void where_ADDRESS01(int operator,
                            java.lang.String filter)
                     throws E4DBException

Define a filter (AND-ed WHERE) for column ADDRESS01 ADDRESS01. STRING(60) Address Line #1

Throws:: E4DBException

where_ADDRESS01_in

public void where_ADDRESS01_in(E4DBSelectDistinct filter)
                        throws E4DBException

Define a ..WHERE/AND ADDRESS01 IN (SELECT DISTINCT column FROM table WHERE condition). ADDRESS01. STRING(60) Address Line #1

Throws:: E4DBException

where_ADDRESS01_isNotEmpty

public void where_ADDRESS01_isNotEmpty()
                                throws E4DBException

Define a ..WHERE/AND (ADDRESS01 IS NOT NULL AND ADDRESS01 != ''). ADDRESS01. STRING(60) Address Line #1

Throws:: E4DBException

where_ADDRESS01_isEmpty

public void where_ADDRESS01_isEmpty()
                             throws E4DBException

Define a ..WHERE/AND (ADDRESS01 IS NULL OR ADDRESS01 == ''). ADDRESS01. STRING(60) Address Line #1

Throws:: E4DBException

where_ADDRESS01_isNull

public void where_ADDRESS01_isNull()
                            throws E4DBException

Define a ..WHERE/AND (ADDRESS01 IS NULL). ADDRESS01. STRING(60) Address Line #1

Throws:: E4DBException

where_ADDRESS01_isNotNull

public void where_ADDRESS01_isNotNull()
                               throws E4DBException

Define a ..WHERE/AND ADDRESS01 IS NOT NULL. ADDRESS01. STRING(60) Address Line #1

Throws:: E4DBException

whereQuery_ADDRESS01

public void whereQuery_ADDRESS01(java.lang.String queryexpression)
                          throws E4DBException

Define a query based filter (AND-ed WHERE) for column ADDRESS01, the data might contain wildcard characters or a , seperated list ADDRESS01. STRING(60) Address Line #1

Throws:: E4DBException

where_ADDRESS02

public void where_ADDRESS02(java.lang.String filter)
                     throws E4DBException

Define a filter (AND-ed WHERE) for column ADDRESS02 ADDRESS02. STRING(60) Address Line #2

Throws:: E4DBException

where_ADDRESS02

public void where_ADDRESS02(int operator,
                            java.lang.String filter)
                     throws E4DBException

Define a filter (AND-ed WHERE) for column ADDRESS02 ADDRESS02. STRING(60) Address Line #2

Throws:: E4DBException

where_ADDRESS02_in

public void where_ADDRESS02_in(E4DBSelectDistinct filter)
                        throws E4DBException

Define a ..WHERE/AND ADDRESS02 IN (SELECT DISTINCT column FROM table WHERE condition). ADDRESS02. STRING(60) Address Line #2

Throws:: E4DBException

where_ADDRESS02_isNotEmpty

public void where_ADDRESS02_isNotEmpty()
                                throws E4DBException

Define a ..WHERE/AND (ADDRESS02 IS NOT NULL AND ADDRESS02 != ''). ADDRESS02. STRING(60) Address Line #2

Throws:: E4DBException

where_ADDRESS02_isEmpty

public void where_ADDRESS02_isEmpty()
                             throws E4DBException

Define a ..WHERE/AND (ADDRESS02 IS NULL OR ADDRESS02 == ''). ADDRESS02. STRING(60) Address Line #2

Throws:: E4DBException

where_ADDRESS02_isNull

public void where_ADDRESS02_isNull()
                            throws E4DBException

Define a ..WHERE/AND (ADDRESS02 IS NULL). ADDRESS02. STRING(60) Address Line #2

Throws:: E4DBException

where_ADDRESS02_isNotNull

public void where_ADDRESS02_isNotNull()
                               throws E4DBException

Define a ..WHERE/AND ADDRESS02 IS NOT NULL. ADDRESS02. STRING(60) Address Line #2

Throws:: E4DBException

whereQuery_ADDRESS02

public void whereQuery_ADDRESS02(java.lang.String queryexpression)
                          throws E4DBException

Define a query based filter (AND-ed WHERE) for column ADDRESS02, the data might contain wildcard characters or a , seperated list ADDRESS02. STRING(60) Address Line #2

Throws:: E4DBException

where_CITY

public void where_CITY(java.lang.String filter)
                throws E4DBException

Define a filter (AND-ed WHERE) for column CITY CITY. STRING(60) City

Throws:: E4DBException

where_CITY

public void where_CITY(int operator,
                       java.lang.String filter)
                throws E4DBException

Define a filter (AND-ed WHERE) for column CITY CITY. STRING(60) City

Throws:: E4DBException

where_CITY_in

public void where_CITY_in(E4DBSelectDistinct filter)
                   throws E4DBException

Define a ..WHERE/AND CITY IN (SELECT DISTINCT column FROM table WHERE condition). CITY. STRING(60) City

Throws:: E4DBException

where_CITY_isNotEmpty

public void where_CITY_isNotEmpty()
                           throws E4DBException

Define a ..WHERE/AND (CITY IS NOT NULL AND CITY != ''). CITY. STRING(60) City

Throws:: E4DBException

where_CITY_isEmpty

public void where_CITY_isEmpty()
                        throws E4DBException

Define a ..WHERE/AND (CITY IS NULL OR CITY == ''). CITY. STRING(60) City

Throws:: E4DBException

where_CITY_isNull

public void where_CITY_isNull()
                       throws E4DBException

Define a ..WHERE/AND (CITY IS NULL). CITY. STRING(60) City

Throws:: E4DBException

where_CITY_isNotNull

public void where_CITY_isNotNull()
                          throws E4DBException

Define a ..WHERE/AND CITY IS NOT NULL. CITY. STRING(60) City

Throws:: E4DBException

whereQuery_CITY

public void whereQuery_CITY(java.lang.String queryexpression)
                     throws E4DBException

Define a query based filter (AND-ed WHERE) for column CITY, the data might contain wildcard characters or a , seperated list CITY. STRING(60) City

Throws:: E4DBException

where_COUNTRYCODE

public void where_COUNTRYCODE(CountryCode filter)
                       throws E4DBException

Define a filter (AND-ed WHERE) for column COUNTRYCODE COUNTRYCODE. CountryCode Countrycode

Throws:: E4DBException

where_COUNTRYCODE

public void where_COUNTRYCODE(int operator,
                              CountryCode filter)
                       throws E4DBException

Define a filter (AND-ed WHERE) for column COUNTRYCODE COUNTRYCODE. CountryCode Countrycode

Throws:: E4DBException

where_COUNTRYCODE_like

public void where_COUNTRYCODE_like(java.lang.String filter)
                            throws E4DBException

Define a filter (AND-ed WHERE) for column COUNTRYCODE COUNTRYCODE. CountryCode Countrycode

Throws:: E4DBException

where_DATNEW

public void where_DATNEW(java.util.Date filter)
                  throws E4DBException

Define a filter (AND-ed WHERE) for column DATNEW DATNEW. DATE Date created

Throws:: E4DBException

where_DATNEW

public void where_DATNEW(int operator,
                         java.util.Date filter)
                  throws E4DBException

Define a filter (AND-ed WHERE) for column DATNEW DATNEW. DATE Date created

Throws:: E4DBException

where_DATNEW_in

public void where_DATNEW_in(E4DBSelectDistinct filter)
                     throws E4DBException

Define a ..WHERE/AND DATNEW IN (SELECT DISTINCT column FROM table WHERE condition). DATNEW. DATE Date created

Throws:: E4DBException

where_DATNEW_isNotEmpty

public void where_DATNEW_isNotEmpty()
                             throws E4DBException

Define a ..WHERE/AND (DATNEW IS NOT NULL AND DATNEW != ''). DATNEW. DATE Date created

Throws:: E4DBException

where_DATNEW_isEmpty

public void where_DATNEW_isEmpty()
                          throws E4DBException

Define a ..WHERE/AND (DATNEW IS NULL OR DATNEW == ''). DATNEW. DATE Date created

Throws:: E4DBException

where_DATNEW_isNull

public void where_DATNEW_isNull()
                         throws E4DBException

Define a ..WHERE/AND (DATNEW IS NULL). DATNEW. DATE Date created

Throws:: E4DBException

where_DATNEW_isNotNull

public void where_DATNEW_isNotNull()
                            throws E4DBException

Define a ..WHERE/AND DATNEW IS NOT NULL. DATNEW. DATE Date created

Throws:: E4DBException

where_GIS_LATITUDE

public void where_GIS_LATITUDE(float filter)
                        throws E4DBException

Define a filter (AND-ed WHERE) for column GIS_LATITUDE GIS_LATITUDE. FLOAT GIS Latitude

Throws:: E4DBException

where_GIS_LATITUDE

public void where_GIS_LATITUDE(int operator,
                               float filter)
                        throws E4DBException

Define a filter (AND-ed WHERE) for column GIS_LATITUDE GIS_LATITUDE. FLOAT GIS Latitude

Throws:: E4DBException

where_GIS_LONGITUDE

public void where_GIS_LONGITUDE(float filter)
                         throws E4DBException

Define a filter (AND-ed WHERE) for column GIS_LONGITUDE GIS_LONGITUDE. FLOAT GIS Longitude

Throws:: E4DBException

where_GIS_LONGITUDE

public void where_GIS_LONGITUDE(int operator,
                                float filter)
                         throws E4DBException

Define a filter (AND-ed WHERE) for column GIS_LONGITUDE GIS_LONGITUDE. FLOAT GIS Longitude

Throws:: E4DBException

where_GROUP_ID

public void where_GROUP_ID(E4CompanyGroup filter)
                    throws E4DBException

Define a filter (AND-ed WHERE) for column GROUP_ID GROUP_ID. E4CompanyGroup defined as e4s.util.E4String(16) Company Group Belongs to Group

Throws:: E4DBException
See Also:: E4CompanyGroup

where_GROUP_ID

public void where_GROUP_ID(int operator,
                           E4CompanyGroup filter)
                    throws E4DBException

Define a filter (AND-ed WHERE) for column GROUP_ID GROUP_ID. E4CompanyGroup defined as e4s.util.E4String(16) Company Group Belongs to Group

Throws:: E4DBException
See Also:: E4CompanyGroup

where_GROUP_ID_like

public void where_GROUP_ID_like(java.lang.String filter)
                         throws E4DBException

Define a filter (AND-ed WHERE) for column GROUP_ID GROUP_ID. E4CompanyGroup defined as e4s.util.E4String(16) Company Group Belongs to Group

Throws:: E4DBException
See Also:: E4CompanyGroup

where_GROUP_ID_in

public void where_GROUP_ID_in(E4DBSelectDistinct filter)
                       throws E4DBException

Define a ..WHERE/AND GROUP_ID IN (SELECT DISTINCT column FROM table WHERE condition). GROUP_ID. E4CompanyGroup defined as e4s.util.E4String(16) Company Group Belongs to Group

Throws:: E4DBException
See Also:: E4CompanyGroup

where_GROUP_ID_isNotEmpty

public void where_GROUP_ID_isNotEmpty()
                               throws E4DBException

Define a ..WHERE/AND (GROUP_ID IS NOT NULL AND GROUP_ID != ''). GROUP_ID. E4CompanyGroup defined as e4s.util.E4String(16) Company Group Belongs to Group

Throws:: E4DBException
See Also:: E4CompanyGroup

where_GROUP_ID_isEmpty

public void where_GROUP_ID_isEmpty()
                            throws E4DBException

Define a ..WHERE/AND (GROUP_ID IS NULL OR GROUP_ID == ''). GROUP_ID. E4CompanyGroup defined as e4s.util.E4String(16) Company Group Belongs to Group

Throws:: E4DBException
See Also:: E4CompanyGroup

where_GROUP_ID_isNull

public void where_GROUP_ID_isNull()
                           throws E4DBException

Define a ..WHERE/AND (GROUP_ID IS NULL). GROUP_ID. E4CompanyGroup defined as e4s.util.E4String(16) Company Group Belongs to Group

Throws:: E4DBException
See Also:: E4CompanyGroup

where_GROUP_ID_isNotNull

public void where_GROUP_ID_isNotNull()
                              throws E4DBException

Define a ..WHERE/AND GROUP_ID IS NOT NULL. GROUP_ID. E4CompanyGroup defined as e4s.util.E4String(16) Company Group Belongs to Group

Throws:: E4DBException
See Also:: E4CompanyGroup

whereQuery_GROUP_ID

public void whereQuery_GROUP_ID(java.lang.String queryexpression)
                         throws E4DBException

Define a query based filter (AND-ed WHERE) for column GROUP_ID, the data might contain wildcard characters or a , seperated list GROUP_ID. E4CompanyGroup defined as e4s.util.E4String(16) Company Group Belongs to Group

Throws:: E4DBException
See Also:: E4CompanyGroup

where_LOGIN_NAME

public void where_LOGIN_NAME(java.lang.String filter)
                      throws E4DBException

Define a filter (AND-ed WHERE) for column LOGIN_NAME LOGIN_NAME. STRING(16) Name for login

Throws:: E4DBException

where_LOGIN_NAME

public void where_LOGIN_NAME(int operator,
                             java.lang.String filter)
                      throws E4DBException

Define a filter (AND-ed WHERE) for column LOGIN_NAME LOGIN_NAME. STRING(16) Name for login

Throws:: E4DBException

where_LOGIN_NAME_in

public void where_LOGIN_NAME_in(E4DBSelectDistinct filter)
                         throws E4DBException

Define a ..WHERE/AND LOGIN_NAME IN (SELECT DISTINCT column FROM table WHERE condition). LOGIN_NAME. STRING(16) Name for login

Throws:: E4DBException

where_LOGIN_NAME_isNotEmpty

public void where_LOGIN_NAME_isNotEmpty()
                                 throws E4DBException

Define a ..WHERE/AND (LOGIN_NAME IS NOT NULL AND LOGIN_NAME != ''). LOGIN_NAME. STRING(16) Name for login

Throws:: E4DBException

where_LOGIN_NAME_isEmpty

public void where_LOGIN_NAME_isEmpty()
                              throws E4DBException

Define a ..WHERE/AND (LOGIN_NAME IS NULL OR LOGIN_NAME == ''). LOGIN_NAME. STRING(16) Name for login

Throws:: E4DBException

where_LOGIN_NAME_isNull

public void where_LOGIN_NAME_isNull()
                             throws E4DBException

Define a ..WHERE/AND (LOGIN_NAME IS NULL). LOGIN_NAME. STRING(16) Name for login

Throws:: E4DBException

where_LOGIN_NAME_isNotNull

public void where_LOGIN_NAME_isNotNull()
                                throws E4DBException

Define a ..WHERE/AND LOGIN_NAME IS NOT NULL. LOGIN_NAME. STRING(16) Name for login

Throws:: E4DBException

whereQuery_LOGIN_NAME

public void whereQuery_LOGIN_NAME(java.lang.String queryexpression)
                           throws E4DBException

Define a query based filter (AND-ed WHERE) for column LOGIN_NAME, the data might contain wildcard characters or a , seperated list LOGIN_NAME. STRING(16) Name for login

Throws:: E4DBException

where_NAME

public void where_NAME(java.lang.String filter)
                throws E4DBException

Define a filter (AND-ed WHERE) for column NAME NAME. STRING(60) Company Name

Throws:: E4DBException

where_NAME

public void where_NAME(int operator,
                       java.lang.String filter)
                throws E4DBException

Define a filter (AND-ed WHERE) for column NAME NAME. STRING(60) Company Name

Throws:: E4DBException

where_NAME_in

public void where_NAME_in(E4DBSelectDistinct filter)
                   throws E4DBException

Define a ..WHERE/AND NAME IN (SELECT DISTINCT column FROM table WHERE condition). NAME. STRING(60) Company Name

Throws:: E4DBException

where_NAME_isNotEmpty

public void where_NAME_isNotEmpty()
                           throws E4DBException

Define a ..WHERE/AND (NAME IS NOT NULL AND NAME != ''). NAME. STRING(60) Company Name

Throws:: E4DBException

where_NAME_isEmpty

public void where_NAME_isEmpty()
                        throws E4DBException

Define a ..WHERE/AND (NAME IS NULL OR NAME == ''). NAME. STRING(60) Company Name

Throws:: E4DBException

where_NAME_isNull

public void where_NAME_isNull()
                       throws E4DBException

Define a ..WHERE/AND (NAME IS NULL). NAME. STRING(60) Company Name

Throws:: E4DBException

where_NAME_isNotNull

public void where_NAME_isNotNull()
                          throws E4DBException

Define a ..WHERE/AND NAME IS NOT NULL. NAME. STRING(60) Company Name

Throws:: E4DBException

whereQuery_NAME

public void whereQuery_NAME(java.lang.String queryexpression)
                     throws E4DBException

Define a query based filter (AND-ed WHERE) for column NAME, the data might contain wildcard characters or a , seperated list NAME. STRING(60) Company Name

Throws:: E4DBException

where_PHONE01

public void where_PHONE01(java.lang.String filter)
                   throws E4DBException

Define a filter (AND-ed WHERE) for column PHONE01 PHONE01. STRING(60) Phone #1

Throws:: E4DBException

where_PHONE01

public void where_PHONE01(int operator,
                          java.lang.String filter)
                   throws E4DBException

Define a filter (AND-ed WHERE) for column PHONE01 PHONE01. STRING(60) Phone #1

Throws:: E4DBException

where_PHONE01_in

public void where_PHONE01_in(E4DBSelectDistinct filter)
                      throws E4DBException

Define a ..WHERE/AND PHONE01 IN (SELECT DISTINCT column FROM table WHERE condition). PHONE01. STRING(60) Phone #1

Throws:: E4DBException

where_PHONE01_isNotEmpty

public void where_PHONE01_isNotEmpty()
                              throws E4DBException

Define a ..WHERE/AND (PHONE01 IS NOT NULL AND PHONE01 != ''). PHONE01. STRING(60) Phone #1

Throws:: E4DBException

where_PHONE01_isEmpty

public void where_PHONE01_isEmpty()
                           throws E4DBException

Define a ..WHERE/AND (PHONE01 IS NULL OR PHONE01 == ''). PHONE01. STRING(60) Phone #1

Throws:: E4DBException

where_PHONE01_isNull

public void where_PHONE01_isNull()
                          throws E4DBException

Define a ..WHERE/AND (PHONE01 IS NULL). PHONE01. STRING(60) Phone #1

Throws:: E4DBException

where_PHONE01_isNotNull

public void where_PHONE01_isNotNull()
                             throws E4DBException

Define a ..WHERE/AND PHONE01 IS NOT NULL. PHONE01. STRING(60) Phone #1

Throws:: E4DBException

whereQuery_PHONE01

public void whereQuery_PHONE01(java.lang.String queryexpression)
                        throws E4DBException

Define a query based filter (AND-ed WHERE) for column PHONE01, the data might contain wildcard characters or a , seperated list PHONE01. STRING(60) Phone #1

Throws:: E4DBException

where_PHONE02

public void where_PHONE02(java.lang.String filter)
                   throws E4DBException

Define a filter (AND-ed WHERE) for column PHONE02 PHONE02. STRING(60) Phone #2

Throws:: E4DBException

where_PHONE02

public void where_PHONE02(int operator,
                          java.lang.String filter)
                   throws E4DBException

Define a filter (AND-ed WHERE) for column PHONE02 PHONE02. STRING(60) Phone #2

Throws:: E4DBException

where_PHONE02_in

public void where_PHONE02_in(E4DBSelectDistinct filter)
                      throws E4DBException

Define a ..WHERE/AND PHONE02 IN (SELECT DISTINCT column FROM table WHERE condition). PHONE02. STRING(60) Phone #2

Throws:: E4DBException

where_PHONE02_isNotEmpty

public void where_PHONE02_isNotEmpty()
                              throws E4DBException

Define a ..WHERE/AND (PHONE02 IS NOT NULL AND PHONE02 != ''). PHONE02. STRING(60) Phone #2

Throws:: E4DBException

where_PHONE02_isEmpty

public void where_PHONE02_isEmpty()
                           throws E4DBException

Define a ..WHERE/AND (PHONE02 IS NULL OR PHONE02 == ''). PHONE02. STRING(60) Phone #2

Throws:: E4DBException

where_PHONE02_isNull

public void where_PHONE02_isNull()
                          throws E4DBException

Define a ..WHERE/AND (PHONE02 IS NULL). PHONE02. STRING(60) Phone #2

Throws:: E4DBException

where_PHONE02_isNotNull

public void where_PHONE02_isNotNull()
                             throws E4DBException

Define a ..WHERE/AND PHONE02 IS NOT NULL. PHONE02. STRING(60) Phone #2

Throws:: E4DBException

whereQuery_PHONE02

public void whereQuery_PHONE02(java.lang.String queryexpression)
                        throws E4DBException

Define a query based filter (AND-ed WHERE) for column PHONE02, the data might contain wildcard characters or a , seperated list PHONE02. STRING(60) Phone #2

Throws:: E4DBException

where_REM

public void where_REM(java.lang.String filter)
               throws E4DBException

Define a filter (AND-ed WHERE) for column REM REM. STRING(255) Remark

Throws:: E4DBException

where_REM

public void where_REM(int operator,
                      java.lang.String filter)
               throws E4DBException

Define a filter (AND-ed WHERE) for column REM REM. STRING(255) Remark

Throws:: E4DBException

where_REM_in

public void where_REM_in(E4DBSelectDistinct filter)
                  throws E4DBException

Define a ..WHERE/AND REM IN (SELECT DISTINCT column FROM table WHERE condition). REM. STRING(255) Remark

Throws:: E4DBException

where_REM_isNotEmpty

public void where_REM_isNotEmpty()
                          throws E4DBException

Define a ..WHERE/AND (REM IS NOT NULL AND REM != ''). REM. STRING(255) Remark

Throws:: E4DBException

where_REM_isEmpty

public void where_REM_isEmpty()
                       throws E4DBException

Define a ..WHERE/AND (REM IS NULL OR REM == ''). REM. STRING(255) Remark

Throws:: E4DBException

where_REM_isNull

public void where_REM_isNull()
                      throws E4DBException

Define a ..WHERE/AND (REM IS NULL). REM. STRING(255) Remark

Throws:: E4DBException

where_REM_isNotNull

public void where_REM_isNotNull()
                         throws E4DBException

Define a ..WHERE/AND REM IS NOT NULL. REM. STRING(255) Remark

Throws:: E4DBException

whereQuery_REM

public void whereQuery_REM(java.lang.String queryexpression)
                    throws E4DBException

Define a query based filter (AND-ed WHERE) for column REM, the data might contain wildcard characters or a , seperated list REM. STRING(255) Remark

Throws:: E4DBException

where_UID

public void where_UID(java.lang.String filter)
               throws E4DBException

Define a filter (AND-ed WHERE) for column UID UID. STRING(14) VAT Number

Throws:: E4DBException

where_UID

public void where_UID(int operator,
                      java.lang.String filter)
               throws E4DBException

Define a filter (AND-ed WHERE) for column UID UID. STRING(14) VAT Number

Throws:: E4DBException

where_UID_in

public void where_UID_in(E4DBSelectDistinct filter)
                  throws E4DBException

Define a ..WHERE/AND UID IN (SELECT DISTINCT column FROM table WHERE condition). UID. STRING(14) VAT Number

Throws:: E4DBException

where_UID_isNotEmpty

public void where_UID_isNotEmpty()
                          throws E4DBException

Define a ..WHERE/AND (UID IS NOT NULL AND UID != ''). UID. STRING(14) VAT Number

Throws:: E4DBException

where_UID_isEmpty

public void where_UID_isEmpty()
                       throws E4DBException

Define a ..WHERE/AND (UID IS NULL OR UID == ''). UID. STRING(14) VAT Number

Throws:: E4DBException

where_UID_isNull

public void where_UID_isNull()
                      throws E4DBException

Define a ..WHERE/AND (UID IS NULL). UID. STRING(14) VAT Number

Throws:: E4DBException

where_UID_isNotNull

public void where_UID_isNotNull()
                         throws E4DBException

Define a ..WHERE/AND UID IS NOT NULL. UID. STRING(14) VAT Number

Throws:: E4DBException

whereQuery_UID

public void whereQuery_UID(java.lang.String queryexpression)
                    throws E4DBException

Define a query based filter (AND-ed WHERE) for column UID, the data might contain wildcard characters or a , seperated list UID. STRING(14) VAT Number

Throws:: E4DBException

where_VALID_UNTIL

public void where_VALID_UNTIL(java.util.Date filter)
                       throws E4DBException

Define a filter (AND-ed WHERE) for column VALID_UNTIL VALID_UNTIL. DATE Valid until

Throws:: E4DBException

where_VALID_UNTIL

public void where_VALID_UNTIL(int operator,
                              java.util.Date filter)
                       throws E4DBException

Define a filter (AND-ed WHERE) for column VALID_UNTIL VALID_UNTIL. DATE Valid until

Throws:: E4DBException

where_VALID_UNTIL_in

public void where_VALID_UNTIL_in(E4DBSelectDistinct filter)
                          throws E4DBException

Define a ..WHERE/AND VALID_UNTIL IN (SELECT DISTINCT column FROM table WHERE condition). VALID_UNTIL. DATE Valid until

Throws:: E4DBException

where_VALID_UNTIL_isNotEmpty

public void where_VALID_UNTIL_isNotEmpty()
                                  throws E4DBException

Define a ..WHERE/AND (VALID_UNTIL IS NOT NULL AND VALID_UNTIL != ''). VALID_UNTIL. DATE Valid until

Throws:: E4DBException

where_VALID_UNTIL_isEmpty

public void where_VALID_UNTIL_isEmpty()
                               throws E4DBException

Define a ..WHERE/AND (VALID_UNTIL IS NULL OR VALID_UNTIL == ''). VALID_UNTIL. DATE Valid until

Throws:: E4DBException

where_VALID_UNTIL_isNull

public void where_VALID_UNTIL_isNull()
                              throws E4DBException

Define a ..WHERE/AND (VALID_UNTIL IS NULL). VALID_UNTIL. DATE Valid until

Throws:: E4DBException

where_VALID_UNTIL_isNotNull

public void where_VALID_UNTIL_isNotNull()
                                 throws E4DBException

Define a ..WHERE/AND VALID_UNTIL IS NOT NULL. VALID_UNTIL. DATE Valid until

Throws:: E4DBException

where_WWW

public void where_WWW(java.lang.String filter)
               throws E4DBException

Define a filter (AND-ed WHERE) for column WWW WWW. STRING(60) WWW Address

Throws:: E4DBException

where_WWW

public void where_WWW(int operator,
                      java.lang.String filter)
               throws E4DBException

Define a filter (AND-ed WHERE) for column WWW WWW. STRING(60) WWW Address

Throws:: E4DBException

where_WWW_in

public void where_WWW_in(E4DBSelectDistinct filter)
                  throws E4DBException

Define a ..WHERE/AND WWW IN (SELECT DISTINCT column FROM table WHERE condition). WWW. STRING(60) WWW Address

Throws:: E4DBException

where_WWW_isNotEmpty

public void where_WWW_isNotEmpty()
                          throws E4DBException

Define a ..WHERE/AND (WWW IS NOT NULL AND WWW != ''). WWW. STRING(60) WWW Address

Throws:: E4DBException

where_WWW_isEmpty

public void where_WWW_isEmpty()
                       throws E4DBException

Define a ..WHERE/AND (WWW IS NULL OR WWW == ''). WWW. STRING(60) WWW Address

Throws:: E4DBException

where_WWW_isNull

public void where_WWW_isNull()
                      throws E4DBException

Define a ..WHERE/AND (WWW IS NULL). WWW. STRING(60) WWW Address

Throws:: E4DBException

where_WWW_isNotNull

public void where_WWW_isNotNull()
                         throws E4DBException

Define a ..WHERE/AND WWW IS NOT NULL. WWW. STRING(60) WWW Address

Throws:: E4DBException

whereQuery_WWW

public void whereQuery_WWW(java.lang.String queryexpression)
                    throws E4DBException

Define a query based filter (AND-ed WHERE) for column WWW, the data might contain wildcard characters or a , seperated list WWW. STRING(60) WWW Address

Throws:: E4DBException

where_ZIPCODE

public void where_ZIPCODE(java.lang.String filter)
                   throws E4DBException

Define a filter (AND-ed WHERE) for column ZIPCODE ZIPCODE. STRING(10) ZIP Code

Throws:: E4DBException

where_ZIPCODE

public void where_ZIPCODE(int operator,
                          java.lang.String filter)
                   throws E4DBException

Define a filter (AND-ed WHERE) for column ZIPCODE ZIPCODE. STRING(10) ZIP Code

Throws:: E4DBException

where_ZIPCODE_in

public void where_ZIPCODE_in(E4DBSelectDistinct filter)
                      throws E4DBException

Define a ..WHERE/AND ZIPCODE IN (SELECT DISTINCT column FROM table WHERE condition). ZIPCODE. STRING(10) ZIP Code

Throws:: E4DBException

where_ZIPCODE_isNotEmpty

public void where_ZIPCODE_isNotEmpty()
                              throws E4DBException

Define a ..WHERE/AND (ZIPCODE IS NOT NULL AND ZIPCODE != ''). ZIPCODE. STRING(10) ZIP Code

Throws:: E4DBException

where_ZIPCODE_isEmpty

public void where_ZIPCODE_isEmpty()
                           throws E4DBException

Define a ..WHERE/AND (ZIPCODE IS NULL OR ZIPCODE == ''). ZIPCODE. STRING(10) ZIP Code

Throws:: E4DBException

where_ZIPCODE_isNull

public void where_ZIPCODE_isNull()
                          throws E4DBException

Define a ..WHERE/AND (ZIPCODE IS NULL). ZIPCODE. STRING(10) ZIP Code

Throws:: E4DBException

where_ZIPCODE_isNotNull

public void where_ZIPCODE_isNotNull()
                             throws E4DBException

Define a ..WHERE/AND ZIPCODE IS NOT NULL. ZIPCODE. STRING(10) ZIP Code

Throws:: E4DBException

whereQuery_ZIPCODE

public void whereQuery_ZIPCODE(java.lang.String queryexpression)
                        throws E4DBException

Define a query based filter (AND-ed WHERE) for column ZIPCODE, the data might contain wildcard characters or a , seperated list ZIPCODE. STRING(10) ZIP Code

Throws:: E4DBException

where_DATEFORMAT

public void where_DATEFORMAT(java.lang.String filter)
                      throws E4DBException

Define a filter (AND-ed WHERE) for column DATEFORMAT DATEFORMAT. STRING(10) Date-Format, e,g, dd.MM.yyyy

Throws:: E4DBException

where_DATEFORMAT

public void where_DATEFORMAT(int operator,
                             java.lang.String filter)
                      throws E4DBException

Define a filter (AND-ed WHERE) for column DATEFORMAT DATEFORMAT. STRING(10) Date-Format, e,g, dd.MM.yyyy

Throws:: E4DBException

where_DATEFORMAT_in

public void where_DATEFORMAT_in(E4DBSelectDistinct filter)
                         throws E4DBException

Define a ..WHERE/AND DATEFORMAT IN (SELECT DISTINCT column FROM table WHERE condition). DATEFORMAT. STRING(10) Date-Format, e,g, dd.MM.yyyy

Throws:: E4DBException

where_DATEFORMAT_isNotEmpty

public void where_DATEFORMAT_isNotEmpty()
                                 throws E4DBException

Define a ..WHERE/AND (DATEFORMAT IS NOT NULL AND DATEFORMAT != ''). DATEFORMAT. STRING(10) Date-Format, e,g, dd.MM.yyyy

Throws:: E4DBException

where_DATEFORMAT_isEmpty

public void where_DATEFORMAT_isEmpty()
                              throws E4DBException

Define a ..WHERE/AND (DATEFORMAT IS NULL OR DATEFORMAT == ''). DATEFORMAT. STRING(10) Date-Format, e,g, dd.MM.yyyy

Throws:: E4DBException

where_DATEFORMAT_isNull

public void where_DATEFORMAT_isNull()
                             throws E4DBException

Define a ..WHERE/AND (DATEFORMAT IS NULL). DATEFORMAT. STRING(10) Date-Format, e,g, dd.MM.yyyy

Throws:: E4DBException

where_DATEFORMAT_isNotNull

public void where_DATEFORMAT_isNotNull()
                                throws E4DBException

Define a ..WHERE/AND DATEFORMAT IS NOT NULL. DATEFORMAT. STRING(10) Date-Format, e,g, dd.MM.yyyy

Throws:: E4DBException

whereQuery_DATEFORMAT

public void whereQuery_DATEFORMAT(java.lang.String queryexpression)
                           throws E4DBException

Define a query based filter (AND-ed WHERE) for column DATEFORMAT, the data might contain wildcard characters or a , seperated list DATEFORMAT. STRING(10) Date-Format, e,g, dd.MM.yyyy

Throws:: E4DBException

where_DECIMALSIGN

public void where_DECIMALSIGN(E4DecimalSign filter)
                       throws E4DBException

Define a filter (AND-ed WHERE) for column DECIMALSIGN DECIMALSIGN. E4DecimalSign defined as e4s.util.E4String(1) Definition for Decimal Sign, related to Client/User Decimal Sign

Throws:: E4DBException
See Also:: E4DecimalSign

where_DECIMALSIGN

public void where_DECIMALSIGN(int operator,
                              E4DecimalSign filter)
                       throws E4DBException

Define a filter (AND-ed WHERE) for column DECIMALSIGN DECIMALSIGN. E4DecimalSign defined as e4s.util.E4String(1) Definition for Decimal Sign, related to Client/User Decimal Sign

Throws:: E4DBException
See Also:: E4DecimalSign

where_DECIMALSIGN_like

public void where_DECIMALSIGN_like(java.lang.String filter)
                            throws E4DBException

Define a filter (AND-ed WHERE) for column DECIMALSIGN DECIMALSIGN. E4DecimalSign defined as e4s.util.E4String(1) Definition for Decimal Sign, related to Client/User Decimal Sign

Throws:: E4DBException
See Also:: E4DecimalSign

where_DECIMALSIGN_in

public void where_DECIMALSIGN_in(E4DBSelectDistinct filter)
                          throws E4DBException

Define a ..WHERE/AND DECIMALSIGN IN (SELECT DISTINCT column FROM table WHERE condition). DECIMALSIGN. E4DecimalSign defined as e4s.util.E4String(1) Definition for Decimal Sign, related to Client/User Decimal Sign

Throws:: E4DBException
See Also:: E4DecimalSign

where_DECIMALSIGN_isNotEmpty

public void where_DECIMALSIGN_isNotEmpty()
                                  throws E4DBException

Define a ..WHERE/AND (DECIMALSIGN IS NOT NULL AND DECIMALSIGN != ''). DECIMALSIGN. E4DecimalSign defined as e4s.util.E4String(1) Definition for Decimal Sign, related to Client/User Decimal Sign

Throws:: E4DBException
See Also:: E4DecimalSign

where_DECIMALSIGN_isEmpty

public void where_DECIMALSIGN_isEmpty()
                               throws E4DBException

Define a ..WHERE/AND (DECIMALSIGN IS NULL OR DECIMALSIGN == ''). DECIMALSIGN. E4DecimalSign defined as e4s.util.E4String(1) Definition for Decimal Sign, related to Client/User Decimal Sign

Throws:: E4DBException
See Also:: E4DecimalSign

where_DECIMALSIGN_isNull

public void where_DECIMALSIGN_isNull()
                              throws E4DBException

Define a ..WHERE/AND (DECIMALSIGN IS NULL). DECIMALSIGN. E4DecimalSign defined as e4s.util.E4String(1) Definition for Decimal Sign, related to Client/User Decimal Sign

Throws:: E4DBException
See Also:: E4DecimalSign

where_DECIMALSIGN_isNotNull

public void where_DECIMALSIGN_isNotNull()
                                 throws E4DBException

Define a ..WHERE/AND DECIMALSIGN IS NOT NULL. DECIMALSIGN. E4DecimalSign defined as e4s.util.E4String(1) Definition for Decimal Sign, related to Client/User Decimal Sign

Throws:: E4DBException
See Also:: E4DecimalSign

whereQuery_DECIMALSIGN

public void whereQuery_DECIMALSIGN(java.lang.String queryexpression)
                            throws E4DBException

Define a query based filter (AND-ed WHERE) for column DECIMALSIGN, the data might contain wildcard characters or a , seperated list DECIMALSIGN. E4DecimalSign defined as e4s.util.E4String(1) Definition for Decimal Sign, related to Client/User Decimal Sign

Throws:: E4DBException
See Also:: E4DecimalSign

where_EMAIL

public void where_EMAIL(java.lang.String filter)
                 throws E4DBException

Define a filter (AND-ed WHERE) for column EMAIL EMAIL. STRING(80) User�s E-Mail address

Throws:: E4DBException

where_EMAIL

public void where_EMAIL(int operator,
                        java.lang.String filter)
                 throws E4DBException

Define a filter (AND-ed WHERE) for column EMAIL EMAIL. STRING(80) User�s E-Mail address

Throws:: E4DBException

where_EMAIL_in

public void where_EMAIL_in(E4DBSelectDistinct filter)
                    throws E4DBException

Define a ..WHERE/AND EMAIL IN (SELECT DISTINCT column FROM table WHERE condition). EMAIL. STRING(80) User�s E-Mail address

Throws:: E4DBException

where_EMAIL_isNotEmpty

public void where_EMAIL_isNotEmpty()
                            throws E4DBException

Define a ..WHERE/AND (EMAIL IS NOT NULL AND EMAIL != ''). EMAIL. STRING(80) User�s E-Mail address

Throws:: E4DBException

where_EMAIL_isEmpty

public void where_EMAIL_isEmpty()
                         throws E4DBException

Define a ..WHERE/AND (EMAIL IS NULL OR EMAIL == ''). EMAIL. STRING(80) User�s E-Mail address

Throws:: E4DBException

where_EMAIL_isNull

public void where_EMAIL_isNull()
                        throws E4DBException

Define a ..WHERE/AND (EMAIL IS NULL). EMAIL. STRING(80) User�s E-Mail address

Throws:: E4DBException

where_EMAIL_isNotNull

public void where_EMAIL_isNotNull()
                           throws E4DBException

Define a ..WHERE/AND EMAIL IS NOT NULL. EMAIL. STRING(80) User�s E-Mail address

Throws:: E4DBException

whereQuery_EMAIL

public void whereQuery_EMAIL(java.lang.String queryexpression)
                      throws E4DBException

Define a query based filter (AND-ed WHERE) for column EMAIL, the data might contain wildcard characters or a , seperated list EMAIL. STRING(80) User�s E-Mail address

Throws:: E4DBException

where_FIRSTNAME

public void where_FIRSTNAME(java.lang.String filter)
                     throws E4DBException

Define a filter (AND-ed WHERE) for column FIRSTNAME FIRSTNAME. STRING(60) Firstname

Throws:: E4DBException

where_FIRSTNAME

public void where_FIRSTNAME(int operator,
                            java.lang.String filter)
                     throws E4DBException

Define a filter (AND-ed WHERE) for column FIRSTNAME FIRSTNAME. STRING(60) Firstname

Throws:: E4DBException

where_FIRSTNAME_in

public void where_FIRSTNAME_in(E4DBSelectDistinct filter)
                        throws E4DBException

Define a ..WHERE/AND FIRSTNAME IN (SELECT DISTINCT column FROM table WHERE condition). FIRSTNAME. STRING(60) Firstname

Throws:: E4DBException

where_FIRSTNAME_isNotEmpty

public void where_FIRSTNAME_isNotEmpty()
                                throws E4DBException

Define a ..WHERE/AND (FIRSTNAME IS NOT NULL AND FIRSTNAME != ''). FIRSTNAME. STRING(60) Firstname

Throws:: E4DBException

where_FIRSTNAME_isEmpty

public void where_FIRSTNAME_isEmpty()
                             throws E4DBException

Define a ..WHERE/AND (FIRSTNAME IS NULL OR FIRSTNAME == ''). FIRSTNAME. STRING(60) Firstname

Throws:: E4DBException

where_FIRSTNAME_isNull

public void where_FIRSTNAME_isNull()
                            throws E4DBException

Define a ..WHERE/AND (FIRSTNAME IS NULL). FIRSTNAME. STRING(60) Firstname

Throws:: E4DBException

where_FIRSTNAME_isNotNull

public void where_FIRSTNAME_isNotNull()
                               throws E4DBException

Define a ..WHERE/AND FIRSTNAME IS NOT NULL. FIRSTNAME. STRING(60) Firstname

Throws:: E4DBException

whereQuery_FIRSTNAME

public void whereQuery_FIRSTNAME(java.lang.String queryexpression)
                          throws E4DBException

Define a query based filter (AND-ed WHERE) for column FIRSTNAME, the data might contain wildcard characters or a , seperated list FIRSTNAME. STRING(60) Firstname

Throws:: E4DBException

where_GENDER

public void where_GENDER(E4Gender filter)
                  throws E4DBException

Define a filter (AND-ed WHERE) for column GENDER GENDER. E4Gender defined as e4s.util.E4Long male, female

Throws:: E4DBException
See Also:: E4Gender

where_GENDER

public void where_GENDER(int operator,
                         E4Gender filter)
                  throws E4DBException

Define a filter (AND-ed WHERE) for column GENDER GENDER. E4Gender defined as e4s.util.E4Long male, female

Throws:: E4DBException
See Also:: E4Gender

where_GENDER_in

public void where_GENDER_in(E4DBSelectDistinct filter)
                     throws E4DBException

Define a ..WHERE/AND GENDER IN (SELECT DISTINCT column FROM table WHERE condition). GENDER. E4Gender defined as e4s.util.E4Long male, female

Throws:: E4DBException
See Also:: E4Gender

where_LASTNAME

public void where_LASTNAME(java.lang.String filter)
                    throws E4DBException

Define a filter (AND-ed WHERE) for column LASTNAME LASTNAME. STRING(60) Lastname

Throws:: E4DBException

where_LASTNAME

public void where_LASTNAME(int operator,
                           java.lang.String filter)
                    throws E4DBException

Define a filter (AND-ed WHERE) for column LASTNAME LASTNAME. STRING(60) Lastname

Throws:: E4DBException

where_LASTNAME_in

public void where_LASTNAME_in(E4DBSelectDistinct filter)
                       throws E4DBException

Define a ..WHERE/AND LASTNAME IN (SELECT DISTINCT column FROM table WHERE condition). LASTNAME. STRING(60) Lastname

Throws:: E4DBException

where_LASTNAME_isNotEmpty

public void where_LASTNAME_isNotEmpty()
                               throws E4DBException

Define a ..WHERE/AND (LASTNAME IS NOT NULL AND LASTNAME != ''). LASTNAME. STRING(60) Lastname

Throws:: E4DBException

where_LASTNAME_isEmpty

public void where_LASTNAME_isEmpty()
                            throws E4DBException

Define a ..WHERE/AND (LASTNAME IS NULL OR LASTNAME == ''). LASTNAME. STRING(60) Lastname

Throws:: E4DBException

where_LASTNAME_isNull

public void where_LASTNAME_isNull()
                           throws E4DBException

Define a ..WHERE/AND (LASTNAME IS NULL). LASTNAME. STRING(60) Lastname

Throws:: E4DBException

where_LASTNAME_isNotNull

public void where_LASTNAME_isNotNull()
                              throws E4DBException

Define a ..WHERE/AND LASTNAME IS NOT NULL. LASTNAME. STRING(60) Lastname

Throws:: E4DBException

whereQuery_LASTNAME

public void whereQuery_LASTNAME(java.lang.String queryexpression)
                         throws E4DBException

Define a query based filter (AND-ed WHERE) for column LASTNAME, the data might contain wildcard characters or a , seperated list LASTNAME. STRING(60) Lastname

Throws:: E4DBException

where_U

public void where_U(E4CompanyUserId filter)
             throws E4DBException

Define a filter (AND-ed WHERE) for column U U. E4CompanyUserId defined as e4s.util.E4String(16) User login name, unique identification for the user in the login process. UserId for login, unique identification

Throws:: E4DBException
See Also:: E4CompanyUserId

where_U

public void where_U(int operator,
                    E4CompanyUserId filter)
             throws E4DBException

Throws:: E4DBException
See Also:: E4CompanyUserId

where_U_like

public void where_U_like(java.lang.String filter)
                  throws E4DBException

Throws:: E4DBException
See Also:: E4CompanyUserId

where_U_in

public void where_U_in(E4DBSelectDistinct filter)
                throws E4DBException

Define a ..WHERE/AND U IN (SELECT DISTINCT column FROM table WHERE condition). U. E4CompanyUserId defined as e4s.util.E4String(16) User login name, unique identification for the user in the login process. UserId for login, unique identification

Throws:: E4DBException
See Also:: E4CompanyUserId

where_U_isNotEmpty

public void where_U_isNotEmpty()
                        throws E4DBException

Define a ..WHERE/AND (U IS NOT NULL AND U != ''). U. E4CompanyUserId defined as e4s.util.E4String(16) User login name, unique identification for the user in the login process. UserId for login, unique identification

Throws:: E4DBException
See Also:: E4CompanyUserId

where_U_isEmpty

public void where_U_isEmpty()
                     throws E4DBException

Define a ..WHERE/AND (U IS NULL OR U == ''). U. E4CompanyUserId defined as e4s.util.E4String(16) User login name, unique identification for the user in the login process. UserId for login, unique identification

Throws:: E4DBException
See Also:: E4CompanyUserId

where_U_isNull

public void where_U_isNull()
                    throws E4DBException

Define a ..WHERE/AND (U IS NULL). U. E4CompanyUserId defined as e4s.util.E4String(16) User login name, unique identification for the user in the login process. UserId for login, unique identification

Throws:: E4DBException
See Also:: E4CompanyUserId

where_U_isNotNull

public void where_U_isNotNull()
                       throws E4DBException

Define a ..WHERE/AND U IS NOT NULL. U. E4CompanyUserId defined as e4s.util.E4String(16) User login name, unique identification for the user in the login process. UserId for login, unique identification

Throws:: E4DBException
See Also:: E4CompanyUserId

whereQuery_U

public void whereQuery_U(java.lang.String queryexpression)
                  throws E4DBException

Define a query based filter (AND-ed WHERE) for column U, the data might contain wildcard characters or a , seperated list U. E4CompanyUserId defined as e4s.util.E4String(16) User login name, unique identification for the user in the login process. UserId for login, unique identification

Throws:: E4DBException
See Also:: E4CompanyUserId

where_LOGIN_PASSWORD

public void where_LOGIN_PASSWORD(java.lang.String filter)
                          throws E4DBException

Define a filter (AND-ed WHERE) for column LOGIN_PASSWORD LOGIN_PASSWORD. STRING(32) Password

Throws:: E4DBException

where_LOGIN_PASSWORD

public void where_LOGIN_PASSWORD(int operator,
                                 java.lang.String filter)
                          throws E4DBException

Define a filter (AND-ed WHERE) for column LOGIN_PASSWORD LOGIN_PASSWORD. STRING(32) Password

Throws:: E4DBException

where_LOGIN_PASSWORD_in

public void where_LOGIN_PASSWORD_in(E4DBSelectDistinct filter)
                             throws E4DBException

Define a ..WHERE/AND LOGIN_PASSWORD IN (SELECT DISTINCT column FROM table WHERE condition). LOGIN_PASSWORD. STRING(32) Password

Throws:: E4DBException

where_LOGIN_PASSWORD_isNotEmpty

public void where_LOGIN_PASSWORD_isNotEmpty()
                                     throws E4DBException

Define a ..WHERE/AND (LOGIN_PASSWORD IS NOT NULL AND LOGIN_PASSWORD != ''). LOGIN_PASSWORD. STRING(32) Password

Throws:: E4DBException

where_LOGIN_PASSWORD_isEmpty

public void where_LOGIN_PASSWORD_isEmpty()
                                  throws E4DBException

Define a ..WHERE/AND (LOGIN_PASSWORD IS NULL OR LOGIN_PASSWORD == ''). LOGIN_PASSWORD. STRING(32) Password

Throws:: E4DBException

where_LOGIN_PASSWORD_isNull

public void where_LOGIN_PASSWORD_isNull()
                                 throws E4DBException

Define a ..WHERE/AND (LOGIN_PASSWORD IS NULL). LOGIN_PASSWORD. STRING(32) Password

Throws:: E4DBException

where_LOGIN_PASSWORD_isNotNull

public void where_LOGIN_PASSWORD_isNotNull()
                                    throws E4DBException

Define a ..WHERE/AND LOGIN_PASSWORD IS NOT NULL. LOGIN_PASSWORD. STRING(32) Password

Throws:: E4DBException

whereQuery_LOGIN_PASSWORD

public void whereQuery_LOGIN_PASSWORD(java.lang.String queryexpression)
                               throws E4DBException

Define a query based filter (AND-ed WHERE) for column LOGIN_PASSWORD, the data might contain wildcard characters or a , seperated list LOGIN_PASSWORD. STRING(32) Password

Throws:: E4DBException

where_MIDDLENAME

public void where_MIDDLENAME(java.lang.String filter)
                      throws E4DBException

Define a filter (AND-ed WHERE) for column MIDDLENAME MIDDLENAME. STRING(1) Middlename

Throws:: E4DBException

where_MIDDLENAME

public void where_MIDDLENAME(int operator,
                             java.lang.String filter)
                      throws E4DBException

Define a filter (AND-ed WHERE) for column MIDDLENAME MIDDLENAME. STRING(1) Middlename

Throws:: E4DBException

where_MIDDLENAME_in

public void where_MIDDLENAME_in(E4DBSelectDistinct filter)
                         throws E4DBException

Define a ..WHERE/AND MIDDLENAME IN (SELECT DISTINCT column FROM table WHERE condition). MIDDLENAME. STRING(1) Middlename

Throws:: E4DBException

where_MIDDLENAME_isNotEmpty

public void where_MIDDLENAME_isNotEmpty()
                                 throws E4DBException

Define a ..WHERE/AND (MIDDLENAME IS NOT NULL AND MIDDLENAME != ''). MIDDLENAME. STRING(1) Middlename

Throws:: E4DBException

where_MIDDLENAME_isEmpty

public void where_MIDDLENAME_isEmpty()
                              throws E4DBException

Define a ..WHERE/AND (MIDDLENAME IS NULL OR MIDDLENAME == ''). MIDDLENAME. STRING(1) Middlename

Throws:: E4DBException

where_MIDDLENAME_isNull

public void where_MIDDLENAME_isNull()
                             throws E4DBException

Define a ..WHERE/AND (MIDDLENAME IS NULL). MIDDLENAME. STRING(1) Middlename

Throws:: E4DBException

where_MIDDLENAME_isNotNull

public void where_MIDDLENAME_isNotNull()
                                throws E4DBException

Define a ..WHERE/AND MIDDLENAME IS NOT NULL. MIDDLENAME. STRING(1) Middlename

Throws:: E4DBException

whereQuery_MIDDLENAME

public void whereQuery_MIDDLENAME(java.lang.String queryexpression)
                           throws E4DBException

Define a query based filter (AND-ed WHERE) for column MIDDLENAME, the data might contain wildcard characters or a , seperated list MIDDLENAME. STRING(1) Middlename

Throws:: E4DBException

where_SATURATION

public void where_SATURATION(java.lang.String filter)
                      throws E4DBException

Define a filter (AND-ed WHERE) for column SATURATION SATURATION. STRING(12) Saturation (e.g. Dr.)

Throws:: E4DBException

where_SATURATION

public void where_SATURATION(int operator,
                             java.lang.String filter)
                      throws E4DBException

Define a filter (AND-ed WHERE) for column SATURATION SATURATION. STRING(12) Saturation (e.g. Dr.)

Throws:: E4DBException

where_SATURATION_in

public void where_SATURATION_in(E4DBSelectDistinct filter)
                         throws E4DBException

Define a ..WHERE/AND SATURATION IN (SELECT DISTINCT column FROM table WHERE condition). SATURATION. STRING(12) Saturation (e.g. Dr.)

Throws:: E4DBException

where_SATURATION_isNotEmpty

public void where_SATURATION_isNotEmpty()
                                 throws E4DBException

Define a ..WHERE/AND (SATURATION IS NOT NULL AND SATURATION != ''). SATURATION. STRING(12) Saturation (e.g. Dr.)

Throws:: E4DBException

where_SATURATION_isEmpty

public void where_SATURATION_isEmpty()
                              throws E4DBException

Define a ..WHERE/AND (SATURATION IS NULL OR SATURATION == ''). SATURATION. STRING(12) Saturation (e.g. Dr.)

Throws:: E4DBException

where_SATURATION_isNull

public void where_SATURATION_isNull()
                             throws E4DBException

Define a ..WHERE/AND (SATURATION IS NULL). SATURATION. STRING(12) Saturation (e.g. Dr.)

Throws:: E4DBException

where_SATURATION_isNotNull

public void where_SATURATION_isNotNull()
                                throws E4DBException

Define a ..WHERE/AND SATURATION IS NOT NULL. SATURATION. STRING(12) Saturation (e.g. Dr.)

Throws:: E4DBException

whereQuery_SATURATION

public void whereQuery_SATURATION(java.lang.String queryexpression)
                           throws E4DBException

Define a query based filter (AND-ed WHERE) for column SATURATION, the data might contain wildcard characters or a , seperated list SATURATION. STRING(12) Saturation (e.g. Dr.)

Throws:: E4DBException

where_TIMEFORMAT

public void where_TIMEFORMAT(java.lang.String filter)
                      throws E4DBException

Define a filter (AND-ed WHERE) for column TIMEFORMAT TIMEFORMAT. STRING(10) Time-Format, e.g. HH:mm:ss

Throws:: E4DBException

where_TIMEFORMAT

public void where_TIMEFORMAT(int operator,
                             java.lang.String filter)
                      throws E4DBException

Define a filter (AND-ed WHERE) for column TIMEFORMAT TIMEFORMAT. STRING(10) Time-Format, e.g. HH:mm:ss

Throws:: E4DBException

where_TIMEFORMAT_in

public void where_TIMEFORMAT_in(E4DBSelectDistinct filter)
                         throws E4DBException

Define a ..WHERE/AND TIMEFORMAT IN (SELECT DISTINCT column FROM table WHERE condition). TIMEFORMAT. STRING(10) Time-Format, e.g. HH:mm:ss

Throws:: E4DBException

where_TIMEFORMAT_isNotEmpty

public void where_TIMEFORMAT_isNotEmpty()
                                 throws E4DBException

Define a ..WHERE/AND (TIMEFORMAT IS NOT NULL AND TIMEFORMAT != ''). TIMEFORMAT. STRING(10) Time-Format, e.g. HH:mm:ss

Throws:: E4DBException

where_TIMEFORMAT_isEmpty

public void where_TIMEFORMAT_isEmpty()
                              throws E4DBException

Define a ..WHERE/AND (TIMEFORMAT IS NULL OR TIMEFORMAT == ''). TIMEFORMAT. STRING(10) Time-Format, e.g. HH:mm:ss

Throws:: E4DBException

where_TIMEFORMAT_isNull

public void where_TIMEFORMAT_isNull()
                             throws E4DBException

Define a ..WHERE/AND (TIMEFORMAT IS NULL). TIMEFORMAT. STRING(10) Time-Format, e.g. HH:mm:ss

Throws:: E4DBException

where_TIMEFORMAT_isNotNull

public void where_TIMEFORMAT_isNotNull()
                                throws E4DBException

Define a ..WHERE/AND TIMEFORMAT IS NOT NULL. TIMEFORMAT. STRING(10) Time-Format, e.g. HH:mm:ss

Throws:: E4DBException

whereQuery_TIMEFORMAT

public void whereQuery_TIMEFORMAT(java.lang.String queryexpression)
                           throws E4DBException

Define a query based filter (AND-ed WHERE) for column TIMEFORMAT, the data might contain wildcard characters or a , seperated list TIMEFORMAT. STRING(10) Time-Format, e.g. HH:mm:ss

Throws:: E4DBException

where_TIMEZONE

public void where_TIMEZONE(TimeZone filter)
                    throws E4DBException

Define a filter (AND-ed WHERE) for column TIMEZONE TIMEZONE. TimeZone Relative Timezone to GMT

Throws:: E4DBException

where_TIMEZONE

public void where_TIMEZONE(int operator,
                           TimeZone filter)
                    throws E4DBException

Define a filter (AND-ed WHERE) for column TIMEZONE TIMEZONE. TimeZone Relative Timezone to GMT

Throws:: E4DBException

sort_ADDRESS01

public void sort_ADDRESS01()

Sort ascending by column ADDRESS01 ADDRESS01. STRING(60) Address Line #1

sort_ADDRESS01_descending

public void sort_ADDRESS01_descending()

Sort ascending by column ADDRESS01 ADDRESS01. STRING(60) Address Line #1

sort_ADDRESS02

public void sort_ADDRESS02()

Sort ascending by column ADDRESS02 ADDRESS02. STRING(60) Address Line #2

sort_ADDRESS02_descending

public void sort_ADDRESS02_descending()

Sort ascending by column ADDRESS02 ADDRESS02. STRING(60) Address Line #2

sort_CITY

public void sort_CITY()

Sort ascending by column CITY CITY. STRING(60) City

sort_CITY_descending

public void sort_CITY_descending()

Sort ascending by column CITY CITY. STRING(60) City

sort_COUNTRYCODE

public void sort_COUNTRYCODE()

Sort ascending by column COUNTRYCODE COUNTRYCODE. CountryCode Countrycode

sort_COUNTRYCODE_descending

public void sort_COUNTRYCODE_descending()

Sort ascending by column COUNTRYCODE COUNTRYCODE. CountryCode Countrycode

sort_DATNEW

public void sort_DATNEW()

Sort ascending by column DATNEW DATNEW. DATE Date created

sort_DATNEW_descending

public void sort_DATNEW_descending()

Sort ascending by column DATNEW DATNEW. DATE Date created

sort_GIS_LATITUDE

public void sort_GIS_LATITUDE()

Sort ascending by column GIS_LATITUDE GIS_LATITUDE. FLOAT GIS Latitude

sort_GIS_LATITUDE_descending

public void sort_GIS_LATITUDE_descending()

Sort ascending by column GIS_LATITUDE GIS_LATITUDE. FLOAT GIS Latitude

sort_GIS_LONGITUDE

public void sort_GIS_LONGITUDE()

Sort ascending by column GIS_LONGITUDE GIS_LONGITUDE. FLOAT GIS Longitude

sort_GIS_LONGITUDE_descending

public void sort_GIS_LONGITUDE_descending()

Sort ascending by column GIS_LONGITUDE GIS_LONGITUDE. FLOAT GIS Longitude

sort_GROUP_ID

public void sort_GROUP_ID()

Sort ascending by column GROUP_ID GROUP_ID. E4CompanyGroup defined as e4s.util.E4String(16) Company Group Belongs to Group

See Also:: E4CompanyGroup

sort_GROUP_ID_descending

public void sort_GROUP_ID_descending()

Sort ascending by column GROUP_ID GROUP_ID. E4CompanyGroup defined as e4s.util.E4String(16) Company Group Belongs to Group

See Also:: E4CompanyGroup

sort_LOGIN_NAME

public void sort_LOGIN_NAME()

Sort ascending by column LOGIN_NAME LOGIN_NAME. STRING(16) Name for login

sort_LOGIN_NAME_descending

public void sort_LOGIN_NAME_descending()

Sort ascending by column LOGIN_NAME LOGIN_NAME. STRING(16) Name for login

sort_NAME

public void sort_NAME()

Sort ascending by column NAME NAME. STRING(60) Company Name

sort_NAME_descending

public void sort_NAME_descending()

Sort ascending by column NAME NAME. STRING(60) Company Name

sort_PHONE01

public void sort_PHONE01()

Sort ascending by column PHONE01 PHONE01. STRING(60) Phone #1

sort_PHONE01_descending

public void sort_PHONE01_descending()

Sort ascending by column PHONE01 PHONE01. STRING(60) Phone #1

sort_PHONE02

public void sort_PHONE02()

Sort ascending by column PHONE02 PHONE02. STRING(60) Phone #2

sort_PHONE02_descending

public void sort_PHONE02_descending()

Sort ascending by column PHONE02 PHONE02. STRING(60) Phone #2

sort_REM

public void sort_REM()

Sort ascending by column REM REM. STRING(255) Remark

sort_REM_descending

public void sort_REM_descending()

Sort ascending by column REM REM. STRING(255) Remark

sort_UID

public void sort_UID()

Sort ascending by column UID UID. STRING(14) VAT Number

sort_UID_descending

public void sort_UID_descending()

Sort ascending by column UID UID. STRING(14) VAT Number

sort_VALID_UNTIL

public void sort_VALID_UNTIL()

Sort ascending by column VALID_UNTIL VALID_UNTIL. DATE Valid until

sort_VALID_UNTIL_descending

public void sort_VALID_UNTIL_descending()

Sort ascending by column VALID_UNTIL VALID_UNTIL. DATE Valid until

sort_WWW

public void sort_WWW()

Sort ascending by column WWW WWW. STRING(60) WWW Address

sort_WWW_descending

public void sort_WWW_descending()

Sort ascending by column WWW WWW. STRING(60) WWW Address

sort_ZIPCODE

public void sort_ZIPCODE()

Sort ascending by column ZIPCODE ZIPCODE. STRING(10) ZIP Code

sort_ZIPCODE_descending

public void sort_ZIPCODE_descending()

Sort ascending by column ZIPCODE ZIPCODE. STRING(10) ZIP Code

sort_DATEFORMAT

public void sort_DATEFORMAT()

Sort ascending by column DATEFORMAT DATEFORMAT. STRING(10) Date-Format, e,g, dd.MM.yyyy

sort_DATEFORMAT_descending

public void sort_DATEFORMAT_descending()

Sort ascending by column DATEFORMAT DATEFORMAT. STRING(10) Date-Format, e,g, dd.MM.yyyy

sort_DECIMALSIGN

public void sort_DECIMALSIGN()

Sort ascending by column DECIMALSIGN DECIMALSIGN. E4DecimalSign defined as e4s.util.E4String(1) Definition for Decimal Sign, related to Client/User Decimal Sign

See Also:: E4DecimalSign

sort_DECIMALSIGN_descending

public void sort_DECIMALSIGN_descending()

Sort ascending by column DECIMALSIGN DECIMALSIGN. E4DecimalSign defined as e4s.util.E4String(1) Definition for Decimal Sign, related to Client/User Decimal Sign

See Also:: E4DecimalSign

sort_EMAIL

public void sort_EMAIL()

Sort ascending by column EMAIL EMAIL. STRING(80) User�s E-Mail address

sort_EMAIL_descending

public void sort_EMAIL_descending()

Sort ascending by column EMAIL EMAIL. STRING(80) User�s E-Mail address

sort_FIRSTNAME

public void sort_FIRSTNAME()

Sort ascending by column FIRSTNAME FIRSTNAME. STRING(60) Firstname

sort_FIRSTNAME_descending

public void sort_FIRSTNAME_descending()

Sort ascending by column FIRSTNAME FIRSTNAME. STRING(60) Firstname

sort_GENDER

public void sort_GENDER()

Sort ascending by column GENDER GENDER. E4Gender defined as e4s.util.E4Long male, female

See Also:: E4Gender

sort_GENDER_descending

public void sort_GENDER_descending()

Sort ascending by column GENDER GENDER. E4Gender defined as e4s.util.E4Long male, female

See Also:: E4Gender

sort_LASTNAME

public void sort_LASTNAME()

Sort ascending by column LASTNAME LASTNAME. STRING(60) Lastname

sort_LASTNAME_descending

public void sort_LASTNAME_descending()

Sort ascending by column LASTNAME LASTNAME. STRING(60) Lastname

sort_U

public void sort_U()

Sort ascending by column U U. E4CompanyUserId defined as e4s.util.E4String(16) User login name, unique identification for the user in the login process. UserId for login, unique identification

See Also:: E4CompanyUserId

sort_U_descending

public void sort_U_descending()

Sort ascending by column U U. E4CompanyUserId defined as e4s.util.E4String(16) User login name, unique identification for the user in the login process. UserId for login, unique identification

See Also:: E4CompanyUserId

sort_LOGIN_PASSWORD

public void sort_LOGIN_PASSWORD()

Sort ascending by column LOGIN_PASSWORD LOGIN_PASSWORD. STRING(32) Password

sort_LOGIN_PASSWORD_descending

public void sort_LOGIN_PASSWORD_descending()

Sort ascending by column LOGIN_PASSWORD LOGIN_PASSWORD. STRING(32) Password

sort_MIDDLENAME

public void sort_MIDDLENAME()

Sort ascending by column MIDDLENAME MIDDLENAME. STRING(1) Middlename

sort_MIDDLENAME_descending

public void sort_MIDDLENAME_descending()

Sort ascending by column MIDDLENAME MIDDLENAME. STRING(1) Middlename

sort_SATURATION

public void sort_SATURATION()

Sort ascending by column SATURATION SATURATION. STRING(12) Saturation (e.g. Dr.)

sort_SATURATION_descending

public void sort_SATURATION_descending()

Sort ascending by column SATURATION SATURATION. STRING(12) Saturation (e.g. Dr.)

sort_TIMEFORMAT

public void sort_TIMEFORMAT()

Sort ascending by column TIMEFORMAT TIMEFORMAT. STRING(10) Time-Format, e.g. HH:mm:ss

sort_TIMEFORMAT_descending

public void sort_TIMEFORMAT_descending()

Sort ascending by column TIMEFORMAT TIMEFORMAT. STRING(10) Time-Format, e.g. HH:mm:ss

sort_TIMEZONE

public void sort_TIMEZONE()

Sort ascending by column TIMEZONE TIMEZONE. TimeZone Relative Timezone to GMT

sort_TIMEZONE_descending

public void sort_TIMEZONE_descending()

Sort ascending by column TIMEZONE TIMEZONE. TimeZone Relative Timezone to GMT

_getSVNVersionString

public static java.lang.String _getSVNVersionString()

Return the version info patched by CVS.

Overview

Package

Class

Tree

Deprecated

Index

Help

www.element4solution.com

PREV CLASS NEXT CLASS

FRAMES NO FRAMES

SUMMARY: NESTED | FIELD | CONSTR | METHOD

DETAIL: FIELD | CONSTR | METHOD

e4s.db.systabledef Class V_E4S_USERS_Sel

VIEWNAME

IS_CLIENT_DISTINCTIVE

TABLE_A

TABLE_B

COL_ADDRESS01

CI_ADDRESS01

COL_ADDRESS02

CI_ADDRESS02

COL_CITY

CI_CITY

COL_COUNTRYCODE

CI_COUNTRYCODE

COL_DATNEW

CI_DATNEW

COL_GIS_LATITUDE

CI_GIS_LATITUDE

COL_GIS_LONGITUDE

CI_GIS_LONGITUDE

COL_GROUP_ID

CI_GROUP_ID

COL_LOGIN_NAME

CI_LOGIN_NAME

COL_NAME

CI_NAME

COL_PHONE01

CI_PHONE01

COL_PHONE02

CI_PHONE02

COL_REM

CI_REM

COL_UID

CI_UID

COL_VALID_UNTIL

CI_VALID_UNTIL

COL_WWW

CI_WWW

COL_ZIPCODE

CI_ZIPCODE

COL_DATEFORMAT

CI_DATEFORMAT

COL_DECIMALSIGN

CI_DECIMALSIGN

COL_EMAIL

CI_EMAIL

COL_FIRSTNAME

CI_FIRSTNAME

COL_GENDER

CI_GENDER

COL_LASTNAME

CI_LASTNAME

COL_U

CI_U

COL_LOGIN_PASSWORD

CI_LOGIN_PASSWORD

COL_MIDDLENAME

CI_MIDDLENAME

COL_SATURATION

CI_SATURATION

COL_TIMEFORMAT

CI_TIMEFORMAT

COL_TIMEZONE

CI_TIMEZONE

COLUMNS

SQL

V_E4S_USERS_Sel

V_E4S_USERS_Sel

V_E4S_USERS_Sel

E4ID

hasClientDistinctive

canHaveFreeDefinedFields

getColInfo

makeInstance

get_ADDRESS01

get_ADDRESS02

get_CITY

get_COUNTRYCODE

get_DATNEW

get_GIS_LATITUDE

get_GIS_LONGITUDE

e4s.db.systabledef
Class V_E4S_USERS_Sel