e4s.db.systabledef
Class T_E4S_HINT_READ_Sel.T_E4S_HINT_READ_Or

java.lang.Object
  e4s.util.E4Object
      e4s.db.E4DBFilter
          e4s.db.E4DBFilterOr
              e4s.db.systabledef.T_E4S_HINT_READ_Sel.T_E4S_HINT_READ_Or

All Implemented Interfaces:

E4DBFilter_Intf, E4DBFilterOr_Intf

Enclosing class:

T_E4S_HINT_READ_Sel

public static class T_E4S_HINT_READ_Sel.T_E4S_HINT_READ_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_HINT_READ_Sel.T_E4S_HINT_READ_Or()

Method Summary

T_E4S_HINT_READ_Sel.T_E4S_HINT_READ_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_COMPANY_USER_ID_in(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_COMPANY_USER_ID_isEmpty() Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column COMPANY_USER_ID.
void	where_COMPANY_USER_ID_isNotEmpty() Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column COMPANY_USER_ID.
void	where_COMPANY_USER_ID_isNotNull() Define a is-NOT-null filter (AND-ed WHERE) for column COMPANY_USER_ID.
void	where_COMPANY_USER_ID_isNull() Define a is-null filter (AND-ed WHERE) for column COMPANY_USER_ID.
void	where_COMPANY_USER_ID_like(java.lang.String filter) Define a filter (AND-ed WHERE) for column COMPANY_USER_ID.
void	where_COMPANY_USER_ID_notin(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_COMPANY_USER_ID(E4CompanyUserId filter) Define a filter (AND-ed WHERE) for column COMPANY_USER_ID.
void	where_COMPANY_USER_ID(int operator, E4CompanyUserId filter) Define a filter (AND-ed WHERE with operator) for column COMPANY_USER_ID.
void	where_DAT_in(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_DAT_isEmpty() Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column DAT.
void	where_DAT_isNotEmpty() Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column DAT.
void	where_DAT_isNotNull() Define a is-NOT-null filter (AND-ed WHERE) for column DAT.
void	where_DAT_isNull() Define a is-null filter (AND-ed WHERE) for column DAT.
void	where_DAT_notin(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_DAT(java.util.Date filter) Define a filter (AND-ed WHERE) for column DAT.
void	where_DAT(int operator, java.util.Date filter) Define a filter (AND-ed WHERE with operator) for column DAT.
void	where_HINT_ID_in(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_HINT_ID_isEmpty() Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column HINT_ID.
void	where_HINT_ID_isNotEmpty() Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column HINT_ID.
void	where_HINT_ID_isNotNull() Define a is-NOT-null filter (AND-ed WHERE) for column HINT_ID.
void	where_HINT_ID_isNull() Define a is-null filter (AND-ed WHERE) for column HINT_ID.
void	where_HINT_ID_like(java.lang.String filter) Define a filter (AND-ed WHERE) for column HINT_ID.
void	where_HINT_ID_notin(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_HINT_ID(E4HintID filter) Define a filter (AND-ed WHERE) for column HINT_ID.
void	where_HINT_ID(int operator, E4HintID filter) Define a filter (AND-ed WHERE with operator) for column HINT_ID.
void	where_LANG_in(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_LANG_isEmpty() Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column LANG.
void	where_LANG_isNotEmpty() Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column LANG.
void	where_LANG_isNotNull() Define a is-NOT-null filter (AND-ed WHERE) for column LANG.
void	where_LANG_isNull() Define a is-null filter (AND-ed WHERE) for column LANG.
void	where_LANG_like(java.lang.String filter) Define a filter (AND-ed WHERE) for column LANG.
void	where_LANG_notin(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_LANG(int operator, Language filter) Define a filter (AND-ed WHERE with operator) for column LANG.
void	where_LANG(Language filter) Define a filter (AND-ed WHERE) for column LANG.

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_HINT_READ_Sel.T_E4S_HINT_READ_Or

public T_E4S_HINT_READ_Sel.T_E4S_HINT_READ_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 Reference to the 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 Reference to the 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 Reference to the 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 Reference to the company

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

See Also:

E4CompanyId

where_COMPANY_USER_ID

public void where_COMPANY_USER_ID(E4CompanyUserId filter)
                           throws E4DBException

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

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

See Also:

E4CompanyUserId

where_COMPANY_USER_ID

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

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

Parameters:

filter - the value to be compared within the SQL statement

operator - the comparsion operator E4DBFilter

Throws:

E4DBException

See Also:

E4CompanyUserId

where_COMPANY_USER_ID_like

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

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

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

See Also:

E4CompanyUserId

where_COMPANY_USER_ID_isNull

public void where_COMPANY_USER_ID_isNull()
                                  throws E4DBException

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

Throws:

E4DBException

See Also:

E4CompanyUserId

where_COMPANY_USER_ID_isNotNull

public void where_COMPANY_USER_ID_isNotNull()
                                     throws E4DBException

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

Throws:

E4DBException

See Also:

E4CompanyUserId

where_COMPANY_USER_ID_in

public void where_COMPANY_USER_ID_in(E4DBSelectDistinct filter)
                              throws E4DBException

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

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

See Also:

E4CompanyUserId

where_COMPANY_USER_ID_notin

public void where_COMPANY_USER_ID_notin(E4DBSelectDistinct filter)
                                 throws E4DBException

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

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

See Also:

E4CompanyUserId

where_COMPANY_USER_ID_isEmpty

public void where_COMPANY_USER_ID_isEmpty()
                                   throws E4DBException

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

Throws:

E4DBException

See Also:

E4CompanyUserId

where_COMPANY_USER_ID_isNotEmpty

public void where_COMPANY_USER_ID_isNotEmpty()
                                      throws E4DBException

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

Throws:

E4DBException

See Also:

E4CompanyUserId

where_DAT

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

Define a filter (AND-ed WHERE) for column DAT. DATE

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_DAT

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

Define a filter (AND-ed WHERE with operator) for column DAT. DATE

Parameters:

filter - the value to be compared within the SQL statement

operator - the comparsion operator E4DBFilter

Throws:

E4DBException

where_DAT_isNull

public void where_DAT_isNull()
                      throws E4DBException

Define a is-null filter (AND-ed WHERE) for column DAT. DATE

Throws:

E4DBException

where_DAT_isNotNull

public void where_DAT_isNotNull()
                         throws E4DBException

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

Throws:

E4DBException

where_DAT_in

public void where_DAT_in(E4DBSelectDistinct filter)
                  throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) DAT. DATE

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_DAT_notin

public void where_DAT_notin(E4DBSelectDistinct filter)
                     throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) DAT. DATE

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_DAT_isEmpty

public void where_DAT_isEmpty()
                       throws E4DBException

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

Throws:

E4DBException

where_DAT_isNotEmpty

public void where_DAT_isNotEmpty()
                          throws E4DBException

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

Throws:

E4DBException

where_HINT_ID

public void where_HINT_ID(E4HintID filter)
                   throws E4DBException

Define a filter (AND-ed WHERE) for column HINT_ID. E4HintID defined as e4s.util.E4String(60) Reference to the hint

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

See Also:

E4HintID

where_HINT_ID

public void where_HINT_ID(int operator,
                          E4HintID filter)
                   throws E4DBException

Define a filter (AND-ed WHERE with operator) for column HINT_ID. E4HintID defined as e4s.util.E4String(60) Reference to the hint

Parameters:

filter - the value to be compared within the SQL statement

operator - the comparsion operator E4DBFilter

Throws:

E4DBException

See Also:

E4HintID

where_HINT_ID_like

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

Define a filter (AND-ed WHERE) for column HINT_ID. E4HintID defined as e4s.util.E4String(60) Reference to the hint

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

See Also:

E4HintID

where_HINT_ID_isNull

public void where_HINT_ID_isNull()
                          throws E4DBException

Define a is-null filter (AND-ed WHERE) for column HINT_ID. E4HintID defined as e4s.util.E4String(60) Reference to the hint

Throws:

E4DBException

See Also:

E4HintID

where_HINT_ID_isNotNull

public void where_HINT_ID_isNotNull()
                             throws E4DBException

Define a is-NOT-null filter (AND-ed WHERE) for column HINT_ID. E4HintID defined as e4s.util.E4String(60) Reference to the hint

Throws:

E4DBException

See Also:

E4HintID

where_HINT_ID_in

public void where_HINT_ID_in(E4DBSelectDistinct filter)
                      throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) HINT_ID. E4HintID defined as e4s.util.E4String(60) Reference to the hint

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

See Also:

E4HintID

where_HINT_ID_notin

public void where_HINT_ID_notin(E4DBSelectDistinct filter)
                         throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) HINT_ID. E4HintID defined as e4s.util.E4String(60) Reference to the hint

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

See Also:

E4HintID

where_HINT_ID_isEmpty

public void where_HINT_ID_isEmpty()
                           throws E4DBException

Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column HINT_ID. E4HintID defined as e4s.util.E4String(60) Reference to the hint

Throws:

E4DBException

See Also:

E4HintID

where_HINT_ID_isNotEmpty

public void where_HINT_ID_isNotEmpty()
                              throws E4DBException

Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column HINT_ID. E4HintID defined as e4s.util.E4String(60) Reference to the hint

Throws:

E4DBException

See Also:

E4HintID

where_LANG

public void where_LANG(Language filter)
                throws E4DBException

Define a filter (AND-ed WHERE) for column LANG. Language only information

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_LANG

public void where_LANG(int operator,
                       Language filter)
                throws E4DBException

Define a filter (AND-ed WHERE with operator) for column LANG. Language only information

Parameters:

filter - the value to be compared within the SQL statement

operator - the comparsion operator E4DBFilter

Throws:

E4DBException

where_LANG_like

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

Define a filter (AND-ed WHERE) for column LANG. Language only information

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_LANG_isNull

public void where_LANG_isNull()
                       throws E4DBException

Define a is-null filter (AND-ed WHERE) for column LANG. Language only information

Throws:

E4DBException

where_LANG_isNotNull

public void where_LANG_isNotNull()
                          throws E4DBException

Define a is-NOT-null filter (AND-ed WHERE) for column LANG. Language only information

Throws:

E4DBException

where_LANG_in

public void where_LANG_in(E4DBSelectDistinct filter)
                   throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) LANG. Language only information

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_LANG_notin

public void where_LANG_notin(E4DBSelectDistinct filter)
                      throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) LANG. Language only information

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_LANG_isEmpty

public void where_LANG_isEmpty()
                        throws E4DBException

Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column LANG. Language only information

Throws:

E4DBException

where_LANG_isNotEmpty

public void where_LANG_isNotEmpty()
                           throws E4DBException

Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column LANG. Language only information

Throws:

E4DBException

and

public T_E4S_HINT_READ_Sel.T_E4S_HINT_READ_And and()