e4s.db.systabledef
Class T_E4S_COMPANY_GROUP_Sel.T_E4S_COMPANY_GROUP_Or

java.lang.Object
  e4s.util.E4Object
      e4s.db.E4DBFilter
          e4s.db.E4DBFilterOr
              e4s.db.systabledef.T_E4S_COMPANY_GROUP_Sel.T_E4S_COMPANY_GROUP_Or

All Implemented Interfaces:

E4DBFilter_Intf, E4DBFilterOr_Intf

Enclosing class:

T_E4S_COMPANY_GROUP_Sel

public static class T_E4S_COMPANY_GROUP_Sel.T_E4S_COMPANY_GROUP_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_GROUP_Sel.T_E4S_COMPANY_GROUP_Or()

Method Summary

T_E4S_COMPANY_GROUP_Sel.T_E4S_COMPANY_GROUP_And	and()
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_DESIGNATION_in(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_DESIGNATION_isEmpty() Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column DESIGNATION.
void	where_DESIGNATION_isNotEmpty() Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column DESIGNATION.
void	where_DESIGNATION_isNotNull() Define a is-NOT-null filter (AND-ed WHERE) for column DESIGNATION.
void	where_DESIGNATION_isNull() Define a is-null filter (AND-ed WHERE) for column DESIGNATION.
void	where_DESIGNATION_notin(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_DESIGNATION(int operator, java.lang.String filter) Define a filter (AND-ed WHERE with operator) for column DESIGNATION.
void	where_DESIGNATION(java.lang.String filter) Define a filter (AND-ed WHERE) for column DESIGNATION.
void	where_ID_in(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_ID_isEmpty() Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column ID.
void	where_ID_isNotEmpty() Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column ID.
void	where_ID_isNotNull() Define a is-NOT-null filter (AND-ed WHERE) for column ID.
void	where_ID_isNull() Define a is-null filter (AND-ed WHERE) for column ID.
void	where_ID_like(java.lang.String filter) Define a filter (AND-ed WHERE) for column ID.
void	where_ID_notin(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_ID(E4CompanyGroup filter) Define a filter (AND-ed WHERE) for column ID.
void	where_ID(int operator, E4CompanyGroup filter) Define a filter (AND-ed WHERE with operator) for column ID.
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_TIMEOUT_in(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_TIMEOUT_notin(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_TIMEOUT(int operator, long filter) Define a filter (AND-ed WHERE with operator) for column TIMEOUT.
void	where_TIMEOUT(long filter) Define a filter (AND-ed WHERE) for column TIMEOUT.

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_GROUP_Sel.T_E4S_COMPANY_GROUP_Or

public T_E4S_COMPANY_GROUP_Sel.T_E4S_COMPANY_GROUP_Or()

Method Detail

where_DATMOD

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

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

Throws:

E4DBException

where_DESIGNATION

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

Define a filter (AND-ed WHERE) for column DESIGNATION. STRING(40) Designation

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_DESIGNATION

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

Define a filter (AND-ed WHERE with operator) for column DESIGNATION. STRING(40) Designation

Parameters:

filter - the value to be compared within the SQL statement

operator - the comparsion operator E4DBFilter

Throws:

E4DBException

where_DESIGNATION_isNull

public void where_DESIGNATION_isNull()
                              throws E4DBException

Define a is-null filter (AND-ed WHERE) for column DESIGNATION. STRING(40) Designation

Throws:

E4DBException

where_DESIGNATION_isNotNull

public void where_DESIGNATION_isNotNull()
                                 throws E4DBException

Define a is-NOT-null filter (AND-ed WHERE) for column DESIGNATION. STRING(40) Designation

Throws:

E4DBException

where_DESIGNATION_in

public void where_DESIGNATION_in(E4DBSelectDistinct filter)
                          throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) DESIGNATION. STRING(40) Designation

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_DESIGNATION_notin

public void where_DESIGNATION_notin(E4DBSelectDistinct filter)
                             throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) DESIGNATION. STRING(40) Designation

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_DESIGNATION_isEmpty

public void where_DESIGNATION_isEmpty()
                               throws E4DBException

Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column DESIGNATION. STRING(40) Designation

Throws:

E4DBException

where_DESIGNATION_isNotEmpty

public void where_DESIGNATION_isNotEmpty()
                                  throws E4DBException

Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column DESIGNATION. STRING(40) Designation

Throws:

E4DBException

where_ID

public void where_ID(E4CompanyGroup filter)
              throws E4DBException

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

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

See Also:

E4CompanyGroup

where_ID

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

Define a filter (AND-ed WHERE with operator) for column ID. E4CompanyGroup defined as e4s.util.E4String(16) Company Group Group ID

Parameters:

filter - the value to be compared within the SQL statement

operator - the comparsion operator E4DBFilter

Throws:

E4DBException

See Also:

E4CompanyGroup

where_ID_like

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

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

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

See Also:

E4CompanyGroup

where_ID_isNull

public void where_ID_isNull()
                     throws E4DBException

Define a is-null filter (AND-ed WHERE) for column ID. E4CompanyGroup defined as e4s.util.E4String(16) Company Group Group ID

Throws:

E4DBException

See Also:

E4CompanyGroup

where_ID_isNotNull

public void where_ID_isNotNull()
                        throws E4DBException

Define a is-NOT-null filter (AND-ed WHERE) for column ID. E4CompanyGroup defined as e4s.util.E4String(16) Company Group Group ID

Throws:

E4DBException

See Also:

E4CompanyGroup

where_ID_in

public void where_ID_in(E4DBSelectDistinct filter)
                 throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) ID. E4CompanyGroup defined as e4s.util.E4String(16) Company Group Group ID

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

See Also:

E4CompanyGroup

where_ID_notin

public void where_ID_notin(E4DBSelectDistinct filter)
                    throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) ID. E4CompanyGroup defined as e4s.util.E4String(16) Company Group Group ID

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

See Also:

E4CompanyGroup

where_ID_isEmpty

public void where_ID_isEmpty()
                      throws E4DBException

Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column ID. E4CompanyGroup defined as e4s.util.E4String(16) Company Group Group ID

Throws:

E4DBException

See Also:

E4CompanyGroup

where_ID_isNotEmpty

public void where_ID_isNotEmpty()
                         throws E4DBException

Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column ID. E4CompanyGroup defined as e4s.util.E4String(16) Company Group Group ID

Throws:

E4DBException

See Also:

E4CompanyGroup

where_REM

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

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

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) Remarks

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) Remarks

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) Remarks

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) Remarks

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) Remarks

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) Remarks

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) Remarks

Throws:

E4DBException

where_TIMEOUT

public void where_TIMEOUT(long filter)
                   throws E4DBException

Define a filter (AND-ed WHERE) for column TIMEOUT. INTEGER Interactive Timeout in seconds

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_TIMEOUT

public void where_TIMEOUT(int operator,
                          long filter)
                   throws E4DBException

Define a filter (AND-ed WHERE with operator) for column TIMEOUT. INTEGER Interactive Timeout in seconds

Parameters:

filter - the value to be compared within the SQL statement

operator - the comparsion operator E4DBFilter

Throws:

E4DBException

where_TIMEOUT_in

public void where_TIMEOUT_in(E4DBSelectDistinct filter)
                      throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) TIMEOUT. INTEGER Interactive Timeout in seconds

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_TIMEOUT_notin

public void where_TIMEOUT_notin(E4DBSelectDistinct filter)
                         throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) TIMEOUT. INTEGER Interactive Timeout in seconds

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

and

public T_E4S_COMPANY_GROUP_Sel.T_E4S_COMPANY_GROUP_And and()