e4s.db.systabledef
Class T_E4S_LOGIN_HISTORY_Sel.T_E4S_LOGIN_HISTORY_And

java.lang.Object
  e4s.util.E4Object
      e4s.db.E4DBFilter
          e4s.db.E4DBFilterAnd
              e4s.db.systabledef.T_E4S_LOGIN_HISTORY_Sel.T_E4S_LOGIN_HISTORY_And

All Implemented Interfaces:

E4DBFilter_Intf, E4DBFilterAnd_Intf

Enclosing class:

T_E4S_LOGIN_HISTORY_Sel

public static class T_E4S_LOGIN_HISTORY_Sel.T_E4S_LOGIN_HISTORY_And
extends E4DBFilterAnd
implements E4DBFilter_Intf

Filter to be used as AND 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_LOGIN_HISTORY_Sel.T_E4S_LOGIN_HISTORY_And()

Method Summary

T_E4S_LOGIN_HISTORY_Sel.T_E4S_LOGIN_HISTORY_Or	or()
void	where_ADDRESS_in(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_ADDRESS_isEmpty() Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column ADDRESS.
void	where_ADDRESS_isNotEmpty() Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column ADDRESS.
void	where_ADDRESS_isNotNull() Define a is-NOT-null filter (AND-ed WHERE) for column ADDRESS.
void	where_ADDRESS_isNull() Define a is-null filter (AND-ed WHERE) for column ADDRESS.
void	where_ADDRESS_notin(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_ADDRESS(int operator, java.lang.String filter) Define a filter (AND-ed WHERE with operator) for column ADDRESS.
void	where_ADDRESS(java.lang.String filter) Define a filter (AND-ed WHERE) for column ADDRESS.
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_D_LOGIN_in(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_D_LOGIN_isEmpty() Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column D_LOGIN.
void	where_D_LOGIN_isNotEmpty() Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column D_LOGIN.
void	where_D_LOGIN_isNotNull() Define a is-NOT-null filter (AND-ed WHERE) for column D_LOGIN.
void	where_D_LOGIN_isNull() Define a is-null filter (AND-ed WHERE) for column D_LOGIN.
void	where_D_LOGIN_notin(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_D_LOGIN(java.util.Date filter) Define a filter (AND-ed WHERE) for column D_LOGIN.
void	where_D_LOGIN(int operator, java.util.Date filter) Define a filter (AND-ed WHERE with operator) for column D_LOGIN.
void	where_D_LOGOUT_in(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_D_LOGOUT_isEmpty() Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column D_LOGOUT.
void	where_D_LOGOUT_isNotEmpty() Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column D_LOGOUT.
void	where_D_LOGOUT_isNotNull() Define a is-NOT-null filter (AND-ed WHERE) for column D_LOGOUT.
void	where_D_LOGOUT_isNull() Define a is-null filter (AND-ed WHERE) for column D_LOGOUT.
void	where_D_LOGOUT_notin(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_D_LOGOUT(java.util.Date filter) Define a filter (AND-ed WHERE) for column D_LOGOUT.
void	where_D_LOGOUT(int operator, java.util.Date filter) Define a filter (AND-ed WHERE with operator) for column D_LOGOUT.
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.
void	where_SESSION_ID_in(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_SESSION_ID_isEmpty() Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column SESSION_ID.
void	where_SESSION_ID_isNotEmpty() Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column SESSION_ID.
void	where_SESSION_ID_isNotNull() Define a is-NOT-null filter (AND-ed WHERE) for column SESSION_ID.
void	where_SESSION_ID_isNull() Define a is-null filter (AND-ed WHERE) for column SESSION_ID.
void	where_SESSION_ID_notin(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_SESSION_ID(int operator, java.lang.String filter) Define a filter (AND-ed WHERE with operator) for column SESSION_ID.
void	where_SESSION_ID(java.lang.String filter) Define a filter (AND-ed WHERE) for column SESSION_ID.
void	where_SUCCESSFUL(boolean filter) Define a filter (AND-ed WHERE) for column SUCCESSFUL.
void	where_SUCCESSFUL(int operator, boolean filter) Define a filter (AND-ed WHERE with operator) for column SUCCESSFUL.
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.E4DBFilterAnd

_getSVNVersionString, getWhere, isEmpty, isNotEmpty, isNotNull, isNull, OR, setFilter_NOT, setFilter_NOT, 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, 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_LOGIN_HISTORY_Sel.T_E4S_LOGIN_HISTORY_And

public T_E4S_LOGIN_HISTORY_Sel.T_E4S_LOGIN_HISTORY_And()

Method Detail

where_ADDRESS

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

Define a filter (AND-ed WHERE) for column ADDRESS. STRING(255) Remote address

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_ADDRESS

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

Define a filter (AND-ed WHERE with operator) for column ADDRESS. STRING(255) Remote address

Parameters:

filter - the value to be compared within the SQL statement

operator - the comparsion operator E4DBFilter

Throws:

E4DBException

where_ADDRESS_isNull

public void where_ADDRESS_isNull()
                          throws E4DBException

Define a is-null filter (AND-ed WHERE) for column ADDRESS. STRING(255) Remote address

Throws:

E4DBException

where_ADDRESS_isNotNull

public void where_ADDRESS_isNotNull()
                             throws E4DBException

Define a is-NOT-null filter (AND-ed WHERE) for column ADDRESS. STRING(255) Remote address

Throws:

E4DBException

where_ADDRESS_in

public void where_ADDRESS_in(E4DBSelectDistinct filter)
                      throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) ADDRESS. STRING(255) Remote address

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_ADDRESS_notin

public void where_ADDRESS_notin(E4DBSelectDistinct filter)
                         throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) ADDRESS. STRING(255) Remote address

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_ADDRESS_isEmpty

public void where_ADDRESS_isEmpty()
                           throws E4DBException

Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column ADDRESS. STRING(255) Remote address

Throws:

E4DBException

where_ADDRESS_isNotEmpty

public void where_ADDRESS_isNotEmpty()
                              throws E4DBException

Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column ADDRESS. STRING(255) Remote address

Throws:

E4DBException

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 Company ID

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

See Also:

E4CompanyId

where_COMPANY_ID

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

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

Parameters:

filter - the value to be compared within the SQL statement

operator - the comparsion operator E4DBFilter

Throws:

E4DBException

See Also:

E4CompanyId

where_COMPANY_ID_in

public void where_COMPANY_ID_in(E4DBSelectDistinct filter)
                         throws E4DBException

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

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

See Also:

E4CompanyId

where_COMPANY_ID_notin

public void where_COMPANY_ID_notin(E4DBSelectDistinct filter)
                            throws E4DBException

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

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

See Also:

E4CompanyId

where_D_LOGIN

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

Define a filter (AND-ed WHERE) for column D_LOGIN. DATE Login Date & Time

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_D_LOGIN

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

Define a filter (AND-ed WHERE with operator) for column D_LOGIN. DATE Login Date & Time

Parameters:

filter - the value to be compared within the SQL statement

operator - the comparsion operator E4DBFilter

Throws:

E4DBException

where_D_LOGIN_isNull

public void where_D_LOGIN_isNull()
                          throws E4DBException

Define a is-null filter (AND-ed WHERE) for column D_LOGIN. DATE Login Date & Time

Throws:

E4DBException

where_D_LOGIN_isNotNull

public void where_D_LOGIN_isNotNull()
                             throws E4DBException

Define a is-NOT-null filter (AND-ed WHERE) for column D_LOGIN. DATE Login Date & Time

Throws:

E4DBException

where_D_LOGIN_in

public void where_D_LOGIN_in(E4DBSelectDistinct filter)
                      throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) D_LOGIN. DATE Login Date & Time

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_D_LOGIN_notin

public void where_D_LOGIN_notin(E4DBSelectDistinct filter)
                         throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) D_LOGIN. DATE Login Date & Time

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_D_LOGIN_isEmpty

public void where_D_LOGIN_isEmpty()
                           throws E4DBException

Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column D_LOGIN. DATE Login Date & Time

Throws:

E4DBException

where_D_LOGIN_isNotEmpty

public void where_D_LOGIN_isNotEmpty()
                              throws E4DBException

Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column D_LOGIN. DATE Login Date & Time

Throws:

E4DBException

where_D_LOGOUT

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

Define a filter (AND-ed WHERE) for column D_LOGOUT. DATE Logout Date & Time

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_D_LOGOUT

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

Define a filter (AND-ed WHERE with operator) for column D_LOGOUT. DATE Logout Date & Time

Parameters:

filter - the value to be compared within the SQL statement

operator - the comparsion operator E4DBFilter

Throws:

E4DBException

where_D_LOGOUT_isNull

public void where_D_LOGOUT_isNull()
                           throws E4DBException

Define a is-null filter (AND-ed WHERE) for column D_LOGOUT. DATE Logout Date & Time

Throws:

E4DBException

where_D_LOGOUT_isNotNull

public void where_D_LOGOUT_isNotNull()
                              throws E4DBException

Define a is-NOT-null filter (AND-ed WHERE) for column D_LOGOUT. DATE Logout Date & Time

Throws:

E4DBException

where_D_LOGOUT_in

public void where_D_LOGOUT_in(E4DBSelectDistinct filter)
                       throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) D_LOGOUT. DATE Logout Date & Time

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_D_LOGOUT_notin

public void where_D_LOGOUT_notin(E4DBSelectDistinct filter)
                          throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) D_LOGOUT. DATE Logout Date & Time

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_D_LOGOUT_isEmpty

public void where_D_LOGOUT_isEmpty()
                            throws E4DBException

Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column D_LOGOUT. DATE Logout Date & Time

Throws:

E4DBException

where_D_LOGOUT_isNotEmpty

public void where_D_LOGOUT_isNotEmpty()
                               throws E4DBException

Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column D_LOGOUT. DATE Logout Date & Time

Throws:

E4DBException

where_LANG

public void where_LANG(Language filter)
                throws E4DBException

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

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 Language

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 Language

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 Language

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 Language

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 Language

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 Language

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 Language

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 Language

Throws:

E4DBException

where_SESSION_ID

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

Define a filter (AND-ed WHERE) for column SESSION_ID. STRING(32) Tomcat Session

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_SESSION_ID

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

Define a filter (AND-ed WHERE with operator) for column SESSION_ID. STRING(32) Tomcat Session

Parameters:

filter - the value to be compared within the SQL statement

operator - the comparsion operator E4DBFilter

Throws:

E4DBException

where_SESSION_ID_isNull

public void where_SESSION_ID_isNull()
                             throws E4DBException

Define a is-null filter (AND-ed WHERE) for column SESSION_ID. STRING(32) Tomcat Session

Throws:

E4DBException

where_SESSION_ID_isNotNull

public void where_SESSION_ID_isNotNull()
                                throws E4DBException

Define a is-NOT-null filter (AND-ed WHERE) for column SESSION_ID. STRING(32) Tomcat Session

Throws:

E4DBException

where_SESSION_ID_in

public void where_SESSION_ID_in(E4DBSelectDistinct filter)
                         throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) SESSION_ID. STRING(32) Tomcat Session

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_SESSION_ID_notin

public void where_SESSION_ID_notin(E4DBSelectDistinct filter)
                            throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) SESSION_ID. STRING(32) Tomcat Session

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_SESSION_ID_isEmpty

public void where_SESSION_ID_isEmpty()
                              throws E4DBException

Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column SESSION_ID. STRING(32) Tomcat Session

Throws:

E4DBException

where_SESSION_ID_isNotEmpty

public void where_SESSION_ID_isNotEmpty()
                                 throws E4DBException

Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column SESSION_ID. STRING(32) Tomcat Session

Throws:

E4DBException

where_SUCCESSFUL

public void where_SUCCESSFUL(boolean filter)
                      throws E4DBException

Define a filter (AND-ed WHERE) for column SUCCESSFUL. BOOLEAN Successful Login

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_SUCCESSFUL

public void where_SUCCESSFUL(int operator,
                             boolean filter)
                      throws E4DBException

Define a filter (AND-ed WHERE with operator) for column SUCCESSFUL. BOOLEAN Successful Login

Parameters:

filter - the value to be compared within the SQL statement

operator - the comparsion operator E4DBFilter

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. User ID

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. User ID

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. User ID

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. User ID

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. User ID

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. User ID

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. User ID

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. User ID

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. User ID

Throws:

E4DBException

See Also:

E4CompanyUserId

or

public T_E4S_LOGIN_HISTORY_Sel.T_E4S_LOGIN_HISTORY_Or or()