e4s.db.systabledef
Class T_E4S_CLIENT_Sel.T_E4S_CLIENT_Or

java.lang.Object
  e4s.util.E4Object
      e4s.db.E4DBFilter
          e4s.db.E4DBFilterOr
              e4s.db.systabledef.T_E4S_CLIENT_Sel.T_E4S_CLIENT_Or

All Implemented Interfaces:

E4DBFilter_Intf, E4DBFilterOr_Intf

Enclosing class:

T_E4S_CLIENT_Sel

public static class T_E4S_CLIENT_Sel.T_E4S_CLIENT_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_CLIENT_Sel.T_E4S_CLIENT_Or()

Method Summary

T_E4S_CLIENT_Sel.T_E4S_CLIENT_And	and()
void	where_BELONGS_TO_in(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_BELONGS_TO_isEmpty() Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column BELONGS_TO.
void	where_BELONGS_TO_isNotEmpty() Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column BELONGS_TO.
void	where_BELONGS_TO_isNotNull() Define a is-NOT-null filter (AND-ed WHERE) for column BELONGS_TO.
void	where_BELONGS_TO_isNull() Define a is-null filter (AND-ed WHERE) for column BELONGS_TO.
void	where_BELONGS_TO_notin(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_BELONGS_TO(int operator, java.lang.String filter) Define a filter (AND-ed WHERE with operator) for column BELONGS_TO.
void	where_BELONGS_TO(java.lang.String filter) Define a filter (AND-ed WHERE) for column BELONGS_TO.
void	where_CLIENT_ID_in(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_CLIENT_ID_isEmpty() Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column CLIENT_ID.
void	where_CLIENT_ID_isNotEmpty() Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column CLIENT_ID.
void	where_CLIENT_ID_isNotNull() Define a is-NOT-null filter (AND-ed WHERE) for column CLIENT_ID.
void	where_CLIENT_ID_isNull() Define a is-null filter (AND-ed WHERE) for column CLIENT_ID.
void	where_CLIENT_ID_notin(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_CLIENT_ID(int operator, java.lang.String filter) Define a filter (AND-ed WHERE with operator) for column CLIENT_ID.
void	where_CLIENT_ID(java.lang.String filter) Define a filter (AND-ed WHERE) for column CLIENT_ID.
void	where_COUNTRY_in(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_COUNTRY_isEmpty() Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column COUNTRY.
void	where_COUNTRY_isNotEmpty() Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column COUNTRY.
void	where_COUNTRY_isNotNull() Define a is-NOT-null filter (AND-ed WHERE) for column COUNTRY.
void	where_COUNTRY_isNull() Define a is-null filter (AND-ed WHERE) for column COUNTRY.
void	where_COUNTRY_like(java.lang.String filter) Define a filter (AND-ed WHERE) for column COUNTRY.
void	where_COUNTRY_notin(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_COUNTRY(CountryCode filter) Define a filter (AND-ed WHERE) for column COUNTRY.
void	where_COUNTRY(int operator, CountryCode filter) Define a filter (AND-ed WHERE with operator) for column COUNTRY.
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_LOGO_in(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_LOGO_isEmpty() Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column LOGO.
void	where_LOGO_isNotEmpty() Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column LOGO.
void	where_LOGO_isNotNull() Define a is-NOT-null filter (AND-ed WHERE) for column LOGO.
void	where_LOGO_isNull() Define a is-null filter (AND-ed WHERE) for column LOGO.
void	where_LOGO_notin(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_LOGO(E4ClientLogo filter) Define a filter (AND-ed WHERE) for column LOGO.
void	where_LOGO(int operator, E4ClientLogo filter) Define a filter (AND-ed WHERE with operator) for column LOGO.
void	where_MAIN_COMPANY_ID_in(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_MAIN_COMPANY_ID_notin(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_MAIN_COMPANY_ID(E4CompanyId filter) Define a filter (AND-ed WHERE) for column MAIN_COMPANY_ID.
void	where_MAIN_COMPANY_ID(int operator, E4CompanyId filter) Define a filter (AND-ed WHERE with operator) for column MAIN_COMPANY_ID.
void	where_NAME_in(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_NAME_isEmpty() Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column NAME.
void	where_NAME_isNotEmpty() Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column NAME.
void	where_NAME_isNotNull() Define a is-NOT-null filter (AND-ed WHERE) for column NAME.
void	where_NAME_isNull() Define a is-null filter (AND-ed WHERE) for column NAME.
void	where_NAME_notin(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_NAME(int operator, java.lang.String filter) Define a filter (AND-ed WHERE with operator) for column NAME.
void	where_NAME(java.lang.String filter) Define a filter (AND-ed WHERE) for column NAME.
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_CLIENT_Sel.T_E4S_CLIENT_Or

public T_E4S_CLIENT_Sel.T_E4S_CLIENT_Or()

Method Detail

where_BELONGS_TO

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

Define a filter (AND-ed WHERE) for column BELONGS_TO. STRING(16) Client, to whom this record belongs, can be empty/null

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_BELONGS_TO

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

Define a filter (AND-ed WHERE with operator) for column BELONGS_TO. STRING(16) Client, to whom this record belongs, can be empty/null

Parameters:

filter - the value to be compared within the SQL statement

operator - the comparsion operator E4DBFilter

Throws:

E4DBException

where_BELONGS_TO_isNull

public void where_BELONGS_TO_isNull()
                             throws E4DBException

Define a is-null filter (AND-ed WHERE) for column BELONGS_TO. STRING(16) Client, to whom this record belongs, can be empty/null

Throws:

E4DBException

where_BELONGS_TO_isNotNull

public void where_BELONGS_TO_isNotNull()
                                throws E4DBException

Define a is-NOT-null filter (AND-ed WHERE) for column BELONGS_TO. STRING(16) Client, to whom this record belongs, can be empty/null

Throws:

E4DBException

where_BELONGS_TO_in

public void where_BELONGS_TO_in(E4DBSelectDistinct filter)
                         throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) BELONGS_TO. STRING(16) Client, to whom this record belongs, can be empty/null

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_BELONGS_TO_notin

public void where_BELONGS_TO_notin(E4DBSelectDistinct filter)
                            throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) BELONGS_TO. STRING(16) Client, to whom this record belongs, can be empty/null

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_BELONGS_TO_isEmpty

public void where_BELONGS_TO_isEmpty()
                              throws E4DBException

Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column BELONGS_TO. STRING(16) Client, to whom this record belongs, can be empty/null

Throws:

E4DBException

where_BELONGS_TO_isNotEmpty

public void where_BELONGS_TO_isNotEmpty()
                                 throws E4DBException

Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column BELONGS_TO. STRING(16) Client, to whom this record belongs, can be empty/null

Throws:

E4DBException

where_CLIENT_ID

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

Define a filter (AND-ed WHERE) for column CLIENT_ID. STRING(16) ID of the client (primary key)

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_CLIENT_ID

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

Define a filter (AND-ed WHERE with operator) for column CLIENT_ID. STRING(16) ID of the client (primary key)

Parameters:

filter - the value to be compared within the SQL statement

operator - the comparsion operator E4DBFilter

Throws:

E4DBException

where_CLIENT_ID_isNull

public void where_CLIENT_ID_isNull()
                            throws E4DBException

Define a is-null filter (AND-ed WHERE) for column CLIENT_ID. STRING(16) ID of the client (primary key)

Throws:

E4DBException

where_CLIENT_ID_isNotNull

public void where_CLIENT_ID_isNotNull()
                               throws E4DBException

Define a is-NOT-null filter (AND-ed WHERE) for column CLIENT_ID. STRING(16) ID of the client (primary key)

Throws:

E4DBException

where_CLIENT_ID_in

public void where_CLIENT_ID_in(E4DBSelectDistinct filter)
                        throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) CLIENT_ID. STRING(16) ID of the client (primary key)

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_CLIENT_ID_notin

public void where_CLIENT_ID_notin(E4DBSelectDistinct filter)
                           throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) CLIENT_ID. STRING(16) ID of the client (primary key)

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_CLIENT_ID_isEmpty

public void where_CLIENT_ID_isEmpty()
                             throws E4DBException

Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column CLIENT_ID. STRING(16) ID of the client (primary key)

Throws:

E4DBException

where_CLIENT_ID_isNotEmpty

public void where_CLIENT_ID_isNotEmpty()
                                throws E4DBException

Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column CLIENT_ID. STRING(16) ID of the client (primary key)

Throws:

E4DBException

where_COUNTRY

public void where_COUNTRY(CountryCode filter)
                   throws E4DBException

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

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_COUNTRY

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

Define a filter (AND-ed WHERE with operator) for column COUNTRY. CountryCode Countrycode

Parameters:

filter - the value to be compared within the SQL statement

operator - the comparsion operator E4DBFilter

Throws:

E4DBException

where_COUNTRY_like

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

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

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_COUNTRY_isNull

public void where_COUNTRY_isNull()
                          throws E4DBException

Define a is-null filter (AND-ed WHERE) for column COUNTRY. CountryCode Countrycode

Throws:

E4DBException

where_COUNTRY_isNotNull

public void where_COUNTRY_isNotNull()
                             throws E4DBException

Define a is-NOT-null filter (AND-ed WHERE) for column COUNTRY. CountryCode Countrycode

Throws:

E4DBException

where_COUNTRY_in

public void where_COUNTRY_in(E4DBSelectDistinct filter)
                      throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) COUNTRY. CountryCode Countrycode

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_COUNTRY_notin

public void where_COUNTRY_notin(E4DBSelectDistinct filter)
                         throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) COUNTRY. CountryCode Countrycode

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_COUNTRY_isEmpty

public void where_COUNTRY_isEmpty()
                           throws E4DBException

Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column COUNTRY. CountryCode Countrycode

Throws:

E4DBException

where_COUNTRY_isNotEmpty

public void where_COUNTRY_isNotEmpty()
                              throws E4DBException

Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column COUNTRY. CountryCode Countrycode

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 of modification

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 of modification

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 of modification

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 of modification

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 of modification

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 of modification

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 of modification

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 of modification

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 of creation

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 of creation

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 of creation

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 of creation

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 of creation

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 of creation

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 of creation

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 of creation

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 Default decimal sign (but user overridden)

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 Default decimal sign (but user overridden)

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 Default decimal sign (but user overridden)

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 Default decimal sign (but user overridden)

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 Default decimal sign (but user overridden)

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 Default decimal sign (but user overridden)

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 Default decimal sign (but user overridden)

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 Default decimal sign (but user overridden)

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 Default decimal sign (but user overridden)

Throws:

E4DBException

See Also:

E4DecimalSign

where_LOGO

public void where_LOGO(E4ClientLogo filter)
                throws E4DBException

Define a filter (AND-ed WHERE) for column LOGO. E4ClientLogo defined as e4s.util.E4StringImage(128) Image (Company Logo) for Client Associated Logo for the client

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

See Also:

E4ClientLogo

where_LOGO

public void where_LOGO(int operator,
                       E4ClientLogo filter)
                throws E4DBException

Define a filter (AND-ed WHERE with operator) for column LOGO. E4ClientLogo defined as e4s.util.E4StringImage(128) Image (Company Logo) for Client Associated Logo for the client

Parameters:

filter - the value to be compared within the SQL statement

operator - the comparsion operator E4DBFilter

Throws:

E4DBException

See Also:

E4ClientLogo

where_LOGO_isNull

public void where_LOGO_isNull()
                       throws E4DBException

Define a is-null filter (AND-ed WHERE) for column LOGO. E4ClientLogo defined as e4s.util.E4StringImage(128) Image (Company Logo) for Client Associated Logo for the client

Throws:

E4DBException

See Also:

E4ClientLogo

where_LOGO_isNotNull

public void where_LOGO_isNotNull()
                          throws E4DBException

Define a is-NOT-null filter (AND-ed WHERE) for column LOGO. E4ClientLogo defined as e4s.util.E4StringImage(128) Image (Company Logo) for Client Associated Logo for the client

Throws:

E4DBException

See Also:

E4ClientLogo

where_LOGO_in

public void where_LOGO_in(E4DBSelectDistinct filter)
                   throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) LOGO. E4ClientLogo defined as e4s.util.E4StringImage(128) Image (Company Logo) for Client Associated Logo for the client

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

See Also:

E4ClientLogo

where_LOGO_notin

public void where_LOGO_notin(E4DBSelectDistinct filter)
                      throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) LOGO. E4ClientLogo defined as e4s.util.E4StringImage(128) Image (Company Logo) for Client Associated Logo for the client

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

See Also:

E4ClientLogo

where_LOGO_isEmpty

public void where_LOGO_isEmpty()
                        throws E4DBException

Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column LOGO. E4ClientLogo defined as e4s.util.E4StringImage(128) Image (Company Logo) for Client Associated Logo for the client

Throws:

E4DBException

See Also:

E4ClientLogo

where_LOGO_isNotEmpty

public void where_LOGO_isNotEmpty()
                           throws E4DBException

Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column LOGO. E4ClientLogo defined as e4s.util.E4StringImage(128) Image (Company Logo) for Client Associated Logo for the client

Throws:

E4DBException

See Also:

E4ClientLogo

where_MAIN_COMPANY_ID

public void where_MAIN_COMPANY_ID(E4CompanyId filter)
                           throws E4DBException

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

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

See Also:

E4CompanyId

where_MAIN_COMPANY_ID

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

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

Parameters:

filter - the value to be compared within the SQL statement

operator - the comparsion operator E4DBFilter

Throws:

E4DBException

See Also:

E4CompanyId

where_MAIN_COMPANY_ID_in

public void where_MAIN_COMPANY_ID_in(E4DBSelectDistinct filter)
                              throws E4DBException

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

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

See Also:

E4CompanyId

where_MAIN_COMPANY_ID_notin

public void where_MAIN_COMPANY_ID_notin(E4DBSelectDistinct filter)
                                 throws E4DBException

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

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

See Also:

E4CompanyId

where_NAME

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

Define a filter (AND-ed WHERE) for column NAME. STRING(40) Name of this client

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_NAME

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

Define a filter (AND-ed WHERE with operator) for column NAME. STRING(40) Name of this client

Parameters:

filter - the value to be compared within the SQL statement

operator - the comparsion operator E4DBFilter

Throws:

E4DBException

where_NAME_isNull

public void where_NAME_isNull()
                       throws E4DBException

Define a is-null filter (AND-ed WHERE) for column NAME. STRING(40) Name of this client

Throws:

E4DBException

where_NAME_isNotNull

public void where_NAME_isNotNull()
                          throws E4DBException

Define a is-NOT-null filter (AND-ed WHERE) for column NAME. STRING(40) Name of this client

Throws:

E4DBException

where_NAME_in

public void where_NAME_in(E4DBSelectDistinct filter)
                   throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) NAME. STRING(40) Name of this client

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_NAME_notin

public void where_NAME_notin(E4DBSelectDistinct filter)
                      throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) NAME. STRING(40) Name of this client

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_NAME_isEmpty

public void where_NAME_isEmpty()
                        throws E4DBException

Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column NAME. STRING(40) Name of this client

Throws:

E4DBException

where_NAME_isNotEmpty

public void where_NAME_isNotEmpty()
                           throws E4DBException

Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column NAME. STRING(40) Name of this client

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 Date, until this client is valid

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 Date, until this client is valid

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 Date, until this client is valid

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 Date, until this client is valid

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 Date, until this client is valid

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 Date, until this client is valid

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 Date, until this client is valid

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 Date, until this client is valid

Throws:

E4DBException

and

public T_E4S_CLIENT_Sel.T_E4S_CLIENT_And and()