e4s.db.systabledef
Class T_E4S_QUERY_PARAMS_Sel.T_E4S_QUERY_PARAMS_Or

java.lang.Object
  e4s.util.E4Object
      e4s.db.E4DBFilter
          e4s.db.E4DBFilterOr
              e4s.db.systabledef.T_E4S_QUERY_PARAMS_Sel.T_E4S_QUERY_PARAMS_Or

All Implemented Interfaces:

E4DBFilter_Intf, E4DBFilterOr_Intf

Enclosing class:

T_E4S_QUERY_PARAMS_Sel

public static class T_E4S_QUERY_PARAMS_Sel.T_E4S_QUERY_PARAMS_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_QUERY_PARAMS_Sel.T_E4S_QUERY_PARAMS_Or()

Method Summary

T_E4S_QUERY_PARAMS_Sel.T_E4S_QUERY_PARAMS_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_FIELDNAME_in(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_FIELDNAME_isEmpty() Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column FIELDNAME.
void	where_FIELDNAME_isNotEmpty() Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column FIELDNAME.
void	where_FIELDNAME_isNotNull() Define a is-NOT-null filter (AND-ed WHERE) for column FIELDNAME.
void	where_FIELDNAME_isNull() Define a is-null filter (AND-ed WHERE) for column FIELDNAME.
void	where_FIELDNAME_notin(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_FIELDNAME(int operator, java.lang.String filter) Define a filter (AND-ed WHERE with operator) for column FIELDNAME.
void	where_FIELDNAME(java.lang.String filter) Define a filter (AND-ed WHERE) for column FIELDNAME.
void	where_FIELDVAL_in(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_FIELDVAL_isEmpty() Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column FIELDVAL.
void	where_FIELDVAL_isNotEmpty() Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column FIELDVAL.
void	where_FIELDVAL_isNotNull() Define a is-NOT-null filter (AND-ed WHERE) for column FIELDVAL.
void	where_FIELDVAL_isNull() Define a is-null filter (AND-ed WHERE) for column FIELDVAL.
void	where_FIELDVAL_notin(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_FIELDVAL(int operator, java.lang.String filter) Define a filter (AND-ed WHERE with operator) for column FIELDVAL.
void	where_FIELDVAL(java.lang.String filter) Define a filter (AND-ed WHERE) for column FIELDVAL.
void	where_QUERY_ID_in(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_QUERY_ID_notin(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_QUERY_ID(int operator, long filter) Define a filter (AND-ed WHERE with operator) for column QUERY_ID.
void	where_QUERY_ID(long filter) Define a filter (AND-ed WHERE) for column QUERY_ID.
void	where_USER_ID_in(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_USER_ID_isEmpty() Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column USER_ID.
void	where_USER_ID_isNotEmpty() Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column USER_ID.
void	where_USER_ID_isNotNull() Define a is-NOT-null filter (AND-ed WHERE) for column USER_ID.
void	where_USER_ID_isNull() Define a is-null filter (AND-ed WHERE) for column USER_ID.
void	where_USER_ID_like(java.lang.String filter) Define a filter (AND-ed WHERE) for column USER_ID.
void	where_USER_ID_notin(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_USER_ID(E4CompanyUserId filter) Define a filter (AND-ed WHERE) for column USER_ID.
void	where_USER_ID(int operator, E4CompanyUserId filter) Define a filter (AND-ed WHERE with operator) for column USER_ID.

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_QUERY_PARAMS_Sel.T_E4S_QUERY_PARAMS_Or

public T_E4S_QUERY_PARAMS_Sel.T_E4S_QUERY_PARAMS_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

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

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

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

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

See Also:

E4CompanyId

where_FIELDNAME

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

Define a filter (AND-ed WHERE) for column FIELDNAME. STRING(3) Query-Fieldname

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_FIELDNAME

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

Define a filter (AND-ed WHERE with operator) for column FIELDNAME. STRING(3) Query-Fieldname

Parameters:

filter - the value to be compared within the SQL statement

operator - the comparsion operator E4DBFilter

Throws:

E4DBException

where_FIELDNAME_isNull

public void where_FIELDNAME_isNull()
                            throws E4DBException

Define a is-null filter (AND-ed WHERE) for column FIELDNAME. STRING(3) Query-Fieldname

Throws:

E4DBException

where_FIELDNAME_isNotNull

public void where_FIELDNAME_isNotNull()
                               throws E4DBException

Define a is-NOT-null filter (AND-ed WHERE) for column FIELDNAME. STRING(3) Query-Fieldname

Throws:

E4DBException

where_FIELDNAME_in

public void where_FIELDNAME_in(E4DBSelectDistinct filter)
                        throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) FIELDNAME. STRING(3) Query-Fieldname

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_FIELDNAME_notin

public void where_FIELDNAME_notin(E4DBSelectDistinct filter)
                           throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) FIELDNAME. STRING(3) Query-Fieldname

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_FIELDNAME_isEmpty

public void where_FIELDNAME_isEmpty()
                             throws E4DBException

Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column FIELDNAME. STRING(3) Query-Fieldname

Throws:

E4DBException

where_FIELDNAME_isNotEmpty

public void where_FIELDNAME_isNotEmpty()
                                throws E4DBException

Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column FIELDNAME. STRING(3) Query-Fieldname

Throws:

E4DBException

where_FIELDVAL

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

Define a filter (AND-ed WHERE) for column FIELDVAL. STRING(255) Field-Value

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_FIELDVAL

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

Define a filter (AND-ed WHERE with operator) for column FIELDVAL. STRING(255) Field-Value

Parameters:

filter - the value to be compared within the SQL statement

operator - the comparsion operator E4DBFilter

Throws:

E4DBException

where_FIELDVAL_isNull

public void where_FIELDVAL_isNull()
                           throws E4DBException

Define a is-null filter (AND-ed WHERE) for column FIELDVAL. STRING(255) Field-Value

Throws:

E4DBException

where_FIELDVAL_isNotNull

public void where_FIELDVAL_isNotNull()
                              throws E4DBException

Define a is-NOT-null filter (AND-ed WHERE) for column FIELDVAL. STRING(255) Field-Value

Throws:

E4DBException

where_FIELDVAL_in

public void where_FIELDVAL_in(E4DBSelectDistinct filter)
                       throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) FIELDVAL. STRING(255) Field-Value

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_FIELDVAL_notin

public void where_FIELDVAL_notin(E4DBSelectDistinct filter)
                          throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) FIELDVAL. STRING(255) Field-Value

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_FIELDVAL_isEmpty

public void where_FIELDVAL_isEmpty()
                            throws E4DBException

Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column FIELDVAL. STRING(255) Field-Value

Throws:

E4DBException

where_FIELDVAL_isNotEmpty

public void where_FIELDVAL_isNotEmpty()
                               throws E4DBException

Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column FIELDVAL. STRING(255) Field-Value

Throws:

E4DBException

where_QUERY_ID

public void where_QUERY_ID(long filter)
                    throws E4DBException

Define a filter (AND-ed WHERE) for column QUERY_ID. INTEGER Query-ID

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_QUERY_ID

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

Define a filter (AND-ed WHERE with operator) for column QUERY_ID. INTEGER Query-ID

Parameters:

filter - the value to be compared within the SQL statement

operator - the comparsion operator E4DBFilter

Throws:

E4DBException

where_QUERY_ID_in

public void where_QUERY_ID_in(E4DBSelectDistinct filter)
                       throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) QUERY_ID. INTEGER Query-ID

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_QUERY_ID_notin

public void where_QUERY_ID_notin(E4DBSelectDistinct filter)
                          throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) QUERY_ID. INTEGER Query-ID

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_USER_ID

public void where_USER_ID(E4CompanyUserId filter)
                   throws E4DBException

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

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

See Also:

E4CompanyUserId

where_USER_ID

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

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

Parameters:

filter - the value to be compared within the SQL statement

operator - the comparsion operator E4DBFilter

Throws:

E4DBException

See Also:

E4CompanyUserId

where_USER_ID_like

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

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

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

See Also:

E4CompanyUserId

where_USER_ID_isNull

public void where_USER_ID_isNull()
                          throws E4DBException

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

Throws:

E4DBException

See Also:

E4CompanyUserId

where_USER_ID_isNotNull

public void where_USER_ID_isNotNull()
                             throws E4DBException

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

Throws:

E4DBException

See Also:

E4CompanyUserId

where_USER_ID_in

public void where_USER_ID_in(E4DBSelectDistinct filter)
                      throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) USER_ID. E4CompanyUserId defined as e4s.util.E4String(16) User login name, unique identification for the user in the login process. Related User

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

See Also:

E4CompanyUserId

where_USER_ID_notin

public void where_USER_ID_notin(E4DBSelectDistinct filter)
                         throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) USER_ID. E4CompanyUserId defined as e4s.util.E4String(16) User login name, unique identification for the user in the login process. Related User

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

See Also:

E4CompanyUserId

where_USER_ID_isEmpty

public void where_USER_ID_isEmpty()
                           throws E4DBException

Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column USER_ID. E4CompanyUserId defined as e4s.util.E4String(16) User login name, unique identification for the user in the login process. Related User

Throws:

E4DBException

See Also:

E4CompanyUserId

where_USER_ID_isNotEmpty

public void where_USER_ID_isNotEmpty()
                              throws E4DBException

Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column USER_ID. E4CompanyUserId defined as e4s.util.E4String(16) User login name, unique identification for the user in the login process. Related User

Throws:

E4DBException

See Also:

E4CompanyUserId

and

public T_E4S_QUERY_PARAMS_Sel.T_E4S_QUERY_PARAMS_And and()