e4s.db.systabledef
Class T_E4S_COMPANY_USER_Sel.T_E4S_COMPANY_USER_Or

java.lang.Object
  e4s.util.E4Object
      e4s.db.E4DBFilter
          e4s.db.E4DBFilterOr
              e4s.db.systabledef.T_E4S_COMPANY_USER_Sel.T_E4S_COMPANY_USER_Or

All Implemented Interfaces:

E4DBFilter_Intf, E4DBFilterOr_Intf

Enclosing class:

T_E4S_COMPANY_USER_Sel

public static class T_E4S_COMPANY_USER_Sel.T_E4S_COMPANY_USER_Or
extends E4DBFilterOr
implements E4DBFilter_Intf

Filter to be used as OR condition.

Field Summary

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

T_E4S_COMPANY_USER_Sel.T_E4S_COMPANY_USER_Or()

Method Summary

T_E4S_COMPANY_USER_Sel.T_E4S_COMPANY_USER_And	and()
void	where_COMPANY_ID_in(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_COMPANY_ID_notin(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_COMPANY_ID(E4CompanyId filter) Define a filter (AND-ed WHERE) for column COMPANY_ID.
void	where_COMPANY_ID(int operator, E4CompanyId filter) Define a filter (AND-ed WHERE with operator) for column COMPANY_ID.
void	where_DATEFORMAT_in(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_DATEFORMAT_isEmpty() Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column DATEFORMAT.
void	where_DATEFORMAT_isNotEmpty() Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column DATEFORMAT.
void	where_DATEFORMAT_isNotNull() Define a is-NOT-null filter (AND-ed WHERE) for column DATEFORMAT.
void	where_DATEFORMAT_isNull() Define a is-null filter (AND-ed WHERE) for column DATEFORMAT.
void	where_DATEFORMAT_notin(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_DATEFORMAT(int operator, java.lang.String filter) Define a filter (AND-ed WHERE with operator) for column DATEFORMAT.
void	where_DATEFORMAT(java.lang.String filter) Define a filter (AND-ed WHERE) for column DATEFORMAT.
void	where_DATMOD_in(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_DATMOD_isEmpty() Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column DATMOD.
void	where_DATMOD_isNotEmpty() Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column DATMOD.
void	where_DATMOD_isNotNull() Define a is-NOT-null filter (AND-ed WHERE) for column DATMOD.
void	where_DATMOD_isNull() Define a is-null filter (AND-ed WHERE) for column DATMOD.
void	where_DATMOD_notin(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_DATMOD(java.util.Date filter) Define a filter (AND-ed WHERE) for column DATMOD.
void	where_DATMOD(int operator, java.util.Date filter) Define a filter (AND-ed WHERE with operator) for column DATMOD.
void	where_DATNEW_in(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_DATNEW_isEmpty() Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column DATNEW.
void	where_DATNEW_isNotEmpty() Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column DATNEW.
void	where_DATNEW_isNotNull() Define a is-NOT-null filter (AND-ed WHERE) for column DATNEW.
void	where_DATNEW_isNull() Define a is-null filter (AND-ed WHERE) for column DATNEW.
void	where_DATNEW_notin(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_DATNEW(java.util.Date filter) Define a filter (AND-ed WHERE) for column DATNEW.
void	where_DATNEW(int operator, java.util.Date filter) Define a filter (AND-ed WHERE with operator) for column DATNEW.
void	where_DECIMALSIGN_in(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_DECIMALSIGN_isEmpty() Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column DECIMALSIGN.
void	where_DECIMALSIGN_isNotEmpty() Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column DECIMALSIGN.
void	where_DECIMALSIGN_isNotNull() Define a is-NOT-null filter (AND-ed WHERE) for column DECIMALSIGN.
void	where_DECIMALSIGN_isNull() Define a is-null filter (AND-ed WHERE) for column DECIMALSIGN.
void	where_DECIMALSIGN_like(java.lang.String filter) Define a filter (AND-ed WHERE) for column DECIMALSIGN.
void	where_DECIMALSIGN_notin(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_DECIMALSIGN(E4DecimalSign filter) Define a filter (AND-ed WHERE) for column DECIMALSIGN.
void	where_DECIMALSIGN(int operator, E4DecimalSign filter) Define a filter (AND-ed WHERE with operator) for column DECIMALSIGN.
void	where_EMAIL_in(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_EMAIL_isEmpty() Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column EMAIL.
void	where_EMAIL_isNotEmpty() Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column EMAIL.
void	where_EMAIL_isNotNull() Define a is-NOT-null filter (AND-ed WHERE) for column EMAIL.
void	where_EMAIL_isNull() Define a is-null filter (AND-ed WHERE) for column EMAIL.
void	where_EMAIL_notin(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_EMAIL(int operator, java.lang.String filter) Define a filter (AND-ed WHERE with operator) for column EMAIL.
void	where_EMAIL(java.lang.String filter) Define a filter (AND-ed WHERE) for column EMAIL.
void	where_FIRSTNAME_in(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_FIRSTNAME_isEmpty() Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column FIRSTNAME.
void	where_FIRSTNAME_isNotEmpty() Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column FIRSTNAME.
void	where_FIRSTNAME_isNotNull() Define a is-NOT-null filter (AND-ed WHERE) for column FIRSTNAME.
void	where_FIRSTNAME_isNull() Define a is-null filter (AND-ed WHERE) for column FIRSTNAME.
void	where_FIRSTNAME_notin(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_FIRSTNAME(int operator, java.lang.String filter) Define a filter (AND-ed WHERE with operator) for column FIRSTNAME.
void	where_FIRSTNAME(java.lang.String filter) Define a filter (AND-ed WHERE) for column FIRSTNAME.
void	where_GENDER_in(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_GENDER_notin(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_GENDER(E4Gender filter) Define a filter (AND-ed WHERE) for column GENDER.
void	where_GENDER(int operator, E4Gender filter) Define a filter (AND-ed WHERE with operator) for column GENDER.
void	where_LASTNAME_in(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_LASTNAME_isEmpty() Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column LASTNAME.
void	where_LASTNAME_isNotEmpty() Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column LASTNAME.
void	where_LASTNAME_isNotNull() Define a is-NOT-null filter (AND-ed WHERE) for column LASTNAME.
void	where_LASTNAME_isNull() Define a is-null filter (AND-ed WHERE) for column LASTNAME.
void	where_LASTNAME_notin(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_LASTNAME(int operator, java.lang.String filter) Define a filter (AND-ed WHERE with operator) for column LASTNAME.
void	where_LASTNAME(java.lang.String filter) Define a filter (AND-ed WHERE) for column LASTNAME.
void	where_LOGIN_NAME_in(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_LOGIN_NAME_isEmpty() Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column LOGIN_NAME.
void	where_LOGIN_NAME_isNotEmpty() Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column LOGIN_NAME.
void	where_LOGIN_NAME_isNotNull() Define a is-NOT-null filter (AND-ed WHERE) for column LOGIN_NAME.
void	where_LOGIN_NAME_isNull() Define a is-null filter (AND-ed WHERE) for column LOGIN_NAME.
void	where_LOGIN_NAME_like(java.lang.String filter) Define a filter (AND-ed WHERE) for column LOGIN_NAME.
void	where_LOGIN_NAME_notin(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_LOGIN_NAME(E4CompanyUserId filter) Define a filter (AND-ed WHERE) for column LOGIN_NAME.
void	where_LOGIN_NAME(int operator, E4CompanyUserId filter) Define a filter (AND-ed WHERE with operator) for column LOGIN_NAME.
void	where_LOGIN_PASSWORD_in(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_LOGIN_PASSWORD_isEmpty() Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column LOGIN_PASSWORD.
void	where_LOGIN_PASSWORD_isNotEmpty() Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column LOGIN_PASSWORD.
void	where_LOGIN_PASSWORD_isNotNull() Define a is-NOT-null filter (AND-ed WHERE) for column LOGIN_PASSWORD.
void	where_LOGIN_PASSWORD_isNull() Define a is-null filter (AND-ed WHERE) for column LOGIN_PASSWORD.
void	where_LOGIN_PASSWORD_notin(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_LOGIN_PASSWORD(int operator, java.lang.String filter) Define a filter (AND-ed WHERE with operator) for column LOGIN_PASSWORD.
void	where_LOGIN_PASSWORD(java.lang.String filter) Define a filter (AND-ed WHERE) for column LOGIN_PASSWORD.
void	where_MIDDLENAME_in(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_MIDDLENAME_isEmpty() Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column MIDDLENAME.
void	where_MIDDLENAME_isNotEmpty() Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column MIDDLENAME.
void	where_MIDDLENAME_isNotNull() Define a is-NOT-null filter (AND-ed WHERE) for column MIDDLENAME.
void	where_MIDDLENAME_isNull() Define a is-null filter (AND-ed WHERE) for column MIDDLENAME.
void	where_MIDDLENAME_notin(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_MIDDLENAME(int operator, java.lang.String filter) Define a filter (AND-ed WHERE with operator) for column MIDDLENAME.
void	where_MIDDLENAME(java.lang.String filter) Define a filter (AND-ed WHERE) for column MIDDLENAME.
void	where_REM_in(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_REM_isEmpty() Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column REM.
void	where_REM_isNotEmpty() Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column REM.
void	where_REM_isNotNull() Define a is-NOT-null filter (AND-ed WHERE) for column REM.
void	where_REM_isNull() Define a is-null filter (AND-ed WHERE) for column REM.
void	where_REM_notin(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_REM(int operator, java.lang.String filter) Define a filter (AND-ed WHERE with operator) for column REM.
void	where_REM(java.lang.String filter) Define a filter (AND-ed WHERE) for column REM.
void	where_SATURATION_in(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_SATURATION_isEmpty() Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column SATURATION.
void	where_SATURATION_isNotEmpty() Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column SATURATION.
void	where_SATURATION_isNotNull() Define a is-NOT-null filter (AND-ed WHERE) for column SATURATION.
void	where_SATURATION_isNull() Define a is-null filter (AND-ed WHERE) for column SATURATION.
void	where_SATURATION_notin(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_SATURATION(int operator, java.lang.String filter) Define a filter (AND-ed WHERE with operator) for column SATURATION.
void	where_SATURATION(java.lang.String filter) Define a filter (AND-ed WHERE) for column SATURATION.
void	where_TIMEFORMAT_in(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_TIMEFORMAT_isEmpty() Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column TIMEFORMAT.
void	where_TIMEFORMAT_isNotEmpty() Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column TIMEFORMAT.
void	where_TIMEFORMAT_isNotNull() Define a is-NOT-null filter (AND-ed WHERE) for column TIMEFORMAT.
void	where_TIMEFORMAT_isNull() Define a is-null filter (AND-ed WHERE) for column TIMEFORMAT.
void	where_TIMEFORMAT_notin(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_TIMEFORMAT(int operator, java.lang.String filter) Define a filter (AND-ed WHERE with operator) for column TIMEFORMAT.
void	where_TIMEFORMAT(java.lang.String filter) Define a filter (AND-ed WHERE) for column TIMEFORMAT.
void	where_TIMEZONE_in(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_TIMEZONE_notin(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_TIMEZONE(int operator, TimeZone filter) Define a filter (AND-ed WHERE with operator) for column TIMEZONE.
void	where_TIMEZONE(TimeZone filter) Define a filter (AND-ed WHERE) for column TIMEZONE.
void	where_VALID_UNTIL_in(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_VALID_UNTIL_isEmpty() Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column VALID_UNTIL.
void	where_VALID_UNTIL_isNotEmpty() Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column VALID_UNTIL.
void	where_VALID_UNTIL_isNotNull() Define a is-NOT-null filter (AND-ed WHERE) for column VALID_UNTIL.
void	where_VALID_UNTIL_isNull() Define a is-null filter (AND-ed WHERE) for column VALID_UNTIL.
void	where_VALID_UNTIL_notin(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_VALID_UNTIL(java.util.Date filter) Define a filter (AND-ed WHERE) for column VALID_UNTIL.
void	where_VALID_UNTIL(int operator, java.util.Date filter) Define a filter (AND-ed WHERE with operator) for column VALID_UNTIL.

Methods inherited from class e4s.db.E4DBFilterOr

_getSVNVersionString, AND, getWhere, isEmpty, isNotEmpty, isNotNull, isNull, 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, toString

Methods inherited from class e4s.db.E4DBFilter

Escape, Escape, finalize, 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 java.lang.Object

clone, equals, getClass, hashCode, notify, notifyAll, wait, wait, wait

Methods inherited from interface e4s.db.E4DBFilter_Intf

getWhere, isWhereDefined, resetWhere

Constructor Detail

T_E4S_COMPANY_USER_Sel.T_E4S_COMPANY_USER_Or

public T_E4S_COMPANY_USER_Sel.T_E4S_COMPANY_USER_Or()

Method Detail

where_COMPANY_ID

public void where_COMPANY_ID(E4CompanyId filter)
                      throws E4DBException

Define a filter (AND-ed WHERE) for column COMPANY_ID. E4CompanyId defined as e4s.util.E4Long Numeric, incremental ID for companies Related Company ID

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

See Also:

E4CompanyId

where_COMPANY_ID

public void where_COMPANY_ID(int operator,
                             E4CompanyId filter)
                      throws E4DBException

Define a filter (AND-ed WHERE with operator) for column COMPANY_ID. E4CompanyId defined as e4s.util.E4Long Numeric, incremental ID for companies Related Company ID

Parameters:

filter - the value to be compared within the SQL statement

operator - the comparsion operator E4DBFilter

Throws:

E4DBException

See Also:

E4CompanyId

where_COMPANY_ID_in

public void where_COMPANY_ID_in(E4DBSelectDistinct filter)
                         throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) COMPANY_ID. E4CompanyId defined as e4s.util.E4Long Numeric, incremental ID for companies Related Company ID

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

See Also:

E4CompanyId

where_COMPANY_ID_notin

public void where_COMPANY_ID_notin(E4DBSelectDistinct filter)
                            throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) COMPANY_ID. E4CompanyId defined as e4s.util.E4Long Numeric, incremental ID for companies Related Company ID

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

See Also:

E4CompanyId

where_DATEFORMAT

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

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

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_DATEFORMAT

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

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

Parameters:

filter - the value to be compared within the SQL statement

operator - the comparsion operator E4DBFilter

Throws:

E4DBException

where_DATEFORMAT_isNull

public void where_DATEFORMAT_isNull()
                             throws E4DBException

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

Throws:

E4DBException

where_DATEFORMAT_isNotNull

public void where_DATEFORMAT_isNotNull()
                                throws E4DBException

Define a is-NOT-null filter (AND-ed WHERE) for column 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 SELECT WHERE column IN (SELECT DISTINCT column FROM..) DATEFORMAT. STRING(10) Date-Format, e,g, dd.MM.yyyy

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_DATEFORMAT_notin

public void where_DATEFORMAT_notin(E4DBSelectDistinct filter)
                            throws E4DBException

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

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_DATEFORMAT_isEmpty

public void where_DATEFORMAT_isEmpty()
                              throws E4DBException

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

Throws:

E4DBException

where_DATEFORMAT_isNotEmpty

public void where_DATEFORMAT_isNotEmpty()
                                 throws E4DBException

Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column DATEFORMAT. STRING(10) Date-Format, e,g, dd.MM.yyyy

Throws:

E4DBException

where_DATMOD

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

Define a filter (AND-ed WHERE) for column DATMOD. DATE Date modified

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_DATMOD

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

Define a filter (AND-ed WHERE with operator) for column DATMOD. DATE Date modified

Parameters:

filter - the value to be compared within the SQL statement

operator - the comparsion operator E4DBFilter

Throws:

E4DBException

where_DATMOD_isNull

public void where_DATMOD_isNull()
                         throws E4DBException

Define a is-null filter (AND-ed WHERE) for column DATMOD. DATE Date modified

Throws:

E4DBException

where_DATMOD_isNotNull

public void where_DATMOD_isNotNull()
                            throws E4DBException

Define a is-NOT-null filter (AND-ed WHERE) for column DATMOD. DATE Date modified

Throws:

E4DBException

where_DATMOD_in

public void where_DATMOD_in(E4DBSelectDistinct filter)
                     throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) DATMOD. DATE Date modified

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_DATMOD_notin

public void where_DATMOD_notin(E4DBSelectDistinct filter)
                        throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) DATMOD. DATE Date modified

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_DATMOD_isEmpty

public void where_DATMOD_isEmpty()
                          throws E4DBException

Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column DATMOD. DATE Date modified

Throws:

E4DBException

where_DATMOD_isNotEmpty

public void where_DATMOD_isNotEmpty()
                             throws E4DBException

Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column DATMOD. DATE Date modified

Throws:

E4DBException

where_DATNEW

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

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

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_DATNEW

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

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

Parameters:

filter - the value to be compared within the SQL statement

operator - the comparsion operator E4DBFilter

Throws:

E4DBException

where_DATNEW_isNull

public void where_DATNEW_isNull()
                         throws E4DBException

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

Throws:

E4DBException

where_DATNEW_isNotNull

public void where_DATNEW_isNotNull()
                            throws E4DBException

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

Throws:

E4DBException

where_DATNEW_in

public void where_DATNEW_in(E4DBSelectDistinct filter)
                     throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) DATNEW. DATE Date created

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_DATNEW_notin

public void where_DATNEW_notin(E4DBSelectDistinct filter)
                        throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) DATNEW. DATE Date created

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_DATNEW_isEmpty

public void where_DATNEW_isEmpty()
                          throws E4DBException

Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column DATNEW. DATE Date created

Throws:

E4DBException

where_DATNEW_isNotEmpty

public void where_DATNEW_isNotEmpty()
                             throws E4DBException

Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column DATNEW. DATE Date created

Throws:

E4DBException

where_DECIMALSIGN

public void where_DECIMALSIGN(E4DecimalSign filter)
                       throws E4DBException

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

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

See Also:

E4DecimalSign

where_DECIMALSIGN

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

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

Parameters:

filter - the value to be compared within the SQL statement

operator - the comparsion operator E4DBFilter

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. E4DecimalSign defined as e4s.util.E4String(1) Definition for Decimal Sign, related to Client/User Decimal Sign

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

See Also:

E4DecimalSign

where_DECIMALSIGN_isNull

public void where_DECIMALSIGN_isNull()
                              throws E4DBException

Define a is-null filter (AND-ed WHERE) for column 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 is-NOT-null filter (AND-ed WHERE) for column 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 SELECT WHERE column IN (SELECT DISTINCT column FROM..) DECIMALSIGN. E4DecimalSign defined as e4s.util.E4String(1) Definition for Decimal Sign, related to Client/User Decimal Sign

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

See Also:

E4DecimalSign

where_DECIMALSIGN_notin

public void where_DECIMALSIGN_notin(E4DBSelectDistinct filter)
                             throws E4DBException

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

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

See Also:

E4DecimalSign

where_DECIMALSIGN_isEmpty

public void where_DECIMALSIGN_isEmpty()
                               throws E4DBException

Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column 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 NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column 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. STRING(80) Userīs E-Mail address

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_EMAIL

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

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

Parameters:

filter - the value to be compared within the SQL statement

operator - the comparsion operator E4DBFilter

Throws:

E4DBException

where_EMAIL_isNull

public void where_EMAIL_isNull()
                        throws E4DBException

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

Throws:

E4DBException

where_EMAIL_isNotNull

public void where_EMAIL_isNotNull()
                           throws E4DBException

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

Throws:

E4DBException

where_EMAIL_in

public void where_EMAIL_in(E4DBSelectDistinct filter)
                    throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) EMAIL. STRING(80) Userīs E-Mail address

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_EMAIL_notin

public void where_EMAIL_notin(E4DBSelectDistinct filter)
                       throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) EMAIL. STRING(80) Userīs E-Mail address

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_EMAIL_isEmpty

public void where_EMAIL_isEmpty()
                         throws E4DBException

Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column EMAIL. STRING(80) Userīs E-Mail address

Throws:

E4DBException

where_EMAIL_isNotEmpty

public void where_EMAIL_isNotEmpty()
                            throws E4DBException

Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column 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. STRING(60) Firstname

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_FIRSTNAME

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

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

Parameters:

filter - the value to be compared within the SQL statement

operator - the comparsion operator E4DBFilter

Throws:

E4DBException

where_FIRSTNAME_isNull

public void where_FIRSTNAME_isNull()
                            throws E4DBException

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

Throws:

E4DBException

where_FIRSTNAME_isNotNull

public void where_FIRSTNAME_isNotNull()
                               throws E4DBException

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

Throws:

E4DBException

where_FIRSTNAME_in

public void where_FIRSTNAME_in(E4DBSelectDistinct filter)
                        throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) FIRSTNAME. STRING(60) Firstname

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_FIRSTNAME_notin

public void where_FIRSTNAME_notin(E4DBSelectDistinct filter)
                           throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) FIRSTNAME. STRING(60) Firstname

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_FIRSTNAME_isEmpty

public void where_FIRSTNAME_isEmpty()
                             throws E4DBException

Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column FIRSTNAME. STRING(60) Firstname

Throws:

E4DBException

where_FIRSTNAME_isNotEmpty

public void where_FIRSTNAME_isNotEmpty()
                                throws E4DBException

Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column 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. E4Gender defined as e4s.util.E4Long male, female

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

See Also:

E4Gender

where_GENDER

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

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

Parameters:

filter - the value to be compared within the SQL statement

operator - the comparsion operator E4DBFilter

Throws:

E4DBException

See Also:

E4Gender

where_GENDER_in

public void where_GENDER_in(E4DBSelectDistinct filter)
                     throws E4DBException

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

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

See Also:

E4Gender

where_GENDER_notin

public void where_GENDER_notin(E4DBSelectDistinct filter)
                        throws E4DBException

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

Parameters:

filter - the value to be compared within the SQL statement

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. STRING(60) Lastname

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_LASTNAME

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

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

Parameters:

filter - the value to be compared within the SQL statement

operator - the comparsion operator E4DBFilter

Throws:

E4DBException

where_LASTNAME_isNull

public void where_LASTNAME_isNull()
                           throws E4DBException

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

Throws:

E4DBException

where_LASTNAME_isNotNull

public void where_LASTNAME_isNotNull()
                              throws E4DBException

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

Throws:

E4DBException

where_LASTNAME_in

public void where_LASTNAME_in(E4DBSelectDistinct filter)
                       throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) LASTNAME. STRING(60) Lastname

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_LASTNAME_notin

public void where_LASTNAME_notin(E4DBSelectDistinct filter)
                          throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) LASTNAME. STRING(60) Lastname

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_LASTNAME_isEmpty

public void where_LASTNAME_isEmpty()
                            throws E4DBException

Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column LASTNAME. STRING(60) Lastname

Throws:

E4DBException

where_LASTNAME_isNotEmpty

public void where_LASTNAME_isNotEmpty()
                               throws E4DBException

Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column LASTNAME. STRING(60) Lastname

Throws:

E4DBException

where_LOGIN_NAME

public void where_LOGIN_NAME(E4CompanyUserId filter)
                      throws E4DBException

Define a filter (AND-ed WHERE) for column 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

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

See Also:

E4CompanyUserId

where_LOGIN_NAME

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

Define a filter (AND-ed WHERE with operator) for column 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

Parameters:

filter - the value to be compared within the SQL statement

operator - the comparsion operator E4DBFilter

Throws:

E4DBException

See Also:

E4CompanyUserId

where_LOGIN_NAME_like

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

Define a filter (AND-ed WHERE) for column 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

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

See Also:

E4CompanyUserId

where_LOGIN_NAME_isNull

public void where_LOGIN_NAME_isNull()
                             throws E4DBException

Define a is-null filter (AND-ed WHERE) for column 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

Throws:

E4DBException

See Also:

E4CompanyUserId

where_LOGIN_NAME_isNotNull

public void where_LOGIN_NAME_isNotNull()
                                throws E4DBException

Define a is-NOT-null filter (AND-ed WHERE) for column 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

Throws:

E4DBException

See Also:

E4CompanyUserId

where_LOGIN_NAME_in

public void where_LOGIN_NAME_in(E4DBSelectDistinct filter)
                         throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) 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

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

See Also:

E4CompanyUserId

where_LOGIN_NAME_notin

public void where_LOGIN_NAME_notin(E4DBSelectDistinct filter)
                            throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) 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

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

See Also:

E4CompanyUserId

where_LOGIN_NAME_isEmpty

public void where_LOGIN_NAME_isEmpty()
                              throws E4DBException

Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column 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

Throws:

E4DBException

See Also:

E4CompanyUserId

where_LOGIN_NAME_isNotEmpty

public void where_LOGIN_NAME_isNotEmpty()
                                 throws E4DBException

Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column 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

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. STRING(32) Password

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_LOGIN_PASSWORD

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

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

Parameters:

filter - the value to be compared within the SQL statement

operator - the comparsion operator E4DBFilter

Throws:

E4DBException

where_LOGIN_PASSWORD_isNull

public void where_LOGIN_PASSWORD_isNull()
                                 throws E4DBException

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

Throws:

E4DBException

where_LOGIN_PASSWORD_isNotNull

public void where_LOGIN_PASSWORD_isNotNull()
                                    throws E4DBException

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

Throws:

E4DBException

where_LOGIN_PASSWORD_in

public void where_LOGIN_PASSWORD_in(E4DBSelectDistinct filter)
                             throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) LOGIN_PASSWORD. STRING(32) Password

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_LOGIN_PASSWORD_notin

public void where_LOGIN_PASSWORD_notin(E4DBSelectDistinct filter)
                                throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) LOGIN_PASSWORD. STRING(32) Password

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_LOGIN_PASSWORD_isEmpty

public void where_LOGIN_PASSWORD_isEmpty()
                                  throws E4DBException

Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column LOGIN_PASSWORD. STRING(32) Password

Throws:

E4DBException

where_LOGIN_PASSWORD_isNotEmpty

public void where_LOGIN_PASSWORD_isNotEmpty()
                                     throws E4DBException

Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column 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. STRING(1) Middlename

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_MIDDLENAME

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

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

Parameters:

filter - the value to be compared within the SQL statement

operator - the comparsion operator E4DBFilter

Throws:

E4DBException

where_MIDDLENAME_isNull

public void where_MIDDLENAME_isNull()
                             throws E4DBException

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

Throws:

E4DBException

where_MIDDLENAME_isNotNull

public void where_MIDDLENAME_isNotNull()
                                throws E4DBException

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

Throws:

E4DBException

where_MIDDLENAME_in

public void where_MIDDLENAME_in(E4DBSelectDistinct filter)
                         throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) MIDDLENAME. STRING(1) Middlename

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_MIDDLENAME_notin

public void where_MIDDLENAME_notin(E4DBSelectDistinct filter)
                            throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) MIDDLENAME. STRING(1) Middlename

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_MIDDLENAME_isEmpty

public void where_MIDDLENAME_isEmpty()
                              throws E4DBException

Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column MIDDLENAME. STRING(1) Middlename

Throws:

E4DBException

where_MIDDLENAME_isNotEmpty

public void where_MIDDLENAME_isNotEmpty()
                                 throws E4DBException

Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column MIDDLENAME. STRING(1) Middlename

Throws:

E4DBException

where_REM

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

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

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_REM

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

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

Parameters:

filter - the value to be compared within the SQL statement

operator - the comparsion operator E4DBFilter

Throws:

E4DBException

where_REM_isNull

public void where_REM_isNull()
                      throws E4DBException

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

Throws:

E4DBException

where_REM_isNotNull

public void where_REM_isNotNull()
                         throws E4DBException

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

Throws:

E4DBException

where_REM_in

public void where_REM_in(E4DBSelectDistinct filter)
                  throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) REM. STRING(255) Free Remark

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_REM_notin

public void where_REM_notin(E4DBSelectDistinct filter)
                     throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) REM. STRING(255) Free Remark

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_REM_isEmpty

public void where_REM_isEmpty()
                       throws E4DBException

Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column REM. STRING(255) Free Remark

Throws:

E4DBException

where_REM_isNotEmpty

public void where_REM_isNotEmpty()
                          throws E4DBException

Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column REM. STRING(255) Free Remark

Throws:

E4DBException

where_SATURATION

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

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

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_SATURATION

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

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

Parameters:

filter - the value to be compared within the SQL statement

operator - the comparsion operator E4DBFilter

Throws:

E4DBException

where_SATURATION_isNull

public void where_SATURATION_isNull()
                             throws E4DBException

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

Throws:

E4DBException

where_SATURATION_isNotNull

public void where_SATURATION_isNotNull()
                                throws E4DBException

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

Throws:

E4DBException

where_SATURATION_in

public void where_SATURATION_in(E4DBSelectDistinct filter)
                         throws E4DBException

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

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_SATURATION_notin

public void where_SATURATION_notin(E4DBSelectDistinct filter)
                            throws E4DBException

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

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_SATURATION_isEmpty

public void where_SATURATION_isEmpty()
                              throws E4DBException

Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column SATURATION. STRING(12) Saturation (e.g. Dr.)

Throws:

E4DBException

where_SATURATION_isNotEmpty

public void where_SATURATION_isNotEmpty()
                                 throws E4DBException

Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column 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. STRING(10) Time-Format, e.g. HH:mm:ss

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_TIMEFORMAT

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

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

Parameters:

filter - the value to be compared within the SQL statement

operator - the comparsion operator E4DBFilter

Throws:

E4DBException

where_TIMEFORMAT_isNull

public void where_TIMEFORMAT_isNull()
                             throws E4DBException

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

Throws:

E4DBException

where_TIMEFORMAT_isNotNull

public void where_TIMEFORMAT_isNotNull()
                                throws E4DBException

Define a is-NOT-null filter (AND-ed WHERE) for column 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 SELECT WHERE column IN (SELECT DISTINCT column FROM..) TIMEFORMAT. STRING(10) Time-Format, e.g. HH:mm:ss

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_TIMEFORMAT_notin

public void where_TIMEFORMAT_notin(E4DBSelectDistinct filter)
                            throws E4DBException

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

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_TIMEFORMAT_isEmpty

public void where_TIMEFORMAT_isEmpty()
                              throws E4DBException

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

Throws:

E4DBException

where_TIMEFORMAT_isNotEmpty

public void where_TIMEFORMAT_isNotEmpty()
                                 throws E4DBException

Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column 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 Relative Timezone to GMT

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_TIMEZONE

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

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

Parameters:

filter - the value to be compared within the SQL statement

operator - the comparsion operator E4DBFilter

Throws:

E4DBException

where_TIMEZONE_in

public void where_TIMEZONE_in(E4DBSelectDistinct filter)
                       throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) TIMEZONE. TimeZone Relative Timezone to GMT

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_TIMEZONE_notin

public void where_TIMEZONE_notin(E4DBSelectDistinct filter)
                          throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) TIMEZONE. TimeZone Relative Timezone to GMT

Parameters:

filter - the value to be compared within the SQL statement

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. DATE Valid until

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_VALID_UNTIL

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

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

Parameters:

filter - the value to be compared within the SQL statement

operator - the comparsion operator E4DBFilter

Throws:

E4DBException

where_VALID_UNTIL_isNull

public void where_VALID_UNTIL_isNull()
                              throws E4DBException

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

Throws:

E4DBException

where_VALID_UNTIL_isNotNull

public void where_VALID_UNTIL_isNotNull()
                                 throws E4DBException

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

Throws:

E4DBException

where_VALID_UNTIL_in

public void where_VALID_UNTIL_in(E4DBSelectDistinct filter)
                          throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) VALID_UNTIL. DATE Valid until

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_VALID_UNTIL_notin

public void where_VALID_UNTIL_notin(E4DBSelectDistinct filter)
                             throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) VALID_UNTIL. DATE Valid until

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_VALID_UNTIL_isEmpty

public void where_VALID_UNTIL_isEmpty()
                               throws E4DBException

Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column VALID_UNTIL. DATE Valid until

Throws:

E4DBException

where_VALID_UNTIL_isNotEmpty

public void where_VALID_UNTIL_isNotEmpty()
                                  throws E4DBException

Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column VALID_UNTIL. DATE Valid until

Throws:

E4DBException

and

public T_E4S_COMPANY_USER_Sel.T_E4S_COMPANY_USER_And and()