T_E4S_LOGIN_HISTORY

Overview

Package

Class

Tree

Deprecated

Index

Help

www.element4solution.com

PREV CLASS NEXT CLASS

FRAMES NO FRAMES

SUMMARY: NESTED | FIELD | CONSTR | METHOD

DETAIL: FIELD | CONSTR | METHOD

e4s.db.systabledef
Class T_E4S_LOGIN_HISTORY_Sel

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

All Implemented Interfaces:: E4DBFilter_Intf, E4DBFilterAnd_Intf, E4DBSelect_Intf

public class T_E4S_LOGIN_HISTORY_Sel
extends E4DBSelect
implements E4DBSelect_Intf
extends E4DBSelect
implements E4DBSelect_Intf

SQL select for T_E4S_LOGIN_HISTORY: Login History. The login module creates an entry each time a user logs into the system, the entry will be updated when the user terminates the session by logging out. created: 20050408 025943, modified: 20080211 135626. $LastChangedRevision: 5290 $ $LastChangedDate: 2009-12-09 18:45:55 +0100 (Mi, 09 Dez 2009) $

Column	Datatype		Remark
ADDRESS	STRING(255)		Remote address
COMPANY_ID	`E4CompanyId` INTEGER	12	Company ID
D_LOGIN	DATE	2	Login Date & Time
D_LOGOUT	DATE		Logout Date & Time
LANG	Language		Language
SESSION_ID	STRING(32)		Tomcat Session
SUCCESSFUL	BOOLEAN		Successful Login
USER_ID	`E4CompanyUserId` STRING(16)	12	User ID

Index 1: IDX1 Index 2: IDX2

See Also:: T_E4S_LOGIN_HISTORY_Mod, T_E4S_LOGIN_HISTORY_Obj

Nested Class Summary
`static class`	`T_E4S_LOGIN_HISTORY_Sel.T_E4S_LOGIN_HISTORY_And` Filter to be used as AND condition.
`static class`	`T_E4S_LOGIN_HISTORY_Sel.T_E4S_LOGIN_HISTORY_Or` Filter to be used as OR condition.

Field Summary
`static E4DBColumnInfo`	`CI_ADDRESS`
`static E4DBColumnInfo`	`CI_COMPANY_ID`
`static E4DBColumnInfo`	`CI_D_LOGIN`
`static E4DBColumnInfo`	`CI_D_LOGOUT`
`static E4DBColumnInfo`	`CI_LANG`
`static E4DBColumnInfo`	`CI_SESSION_ID`
`static E4DBColumnInfo`	`CI_SUCCESSFUL`
`static E4DBColumnInfo`	`CI_USER_ID`
`static E4DBColumnName`	`COL_ADDRESS` STRING(255) Remote address
`static E4DBColumnName`	`COL_COMPANY_ID` E4CompanyId defined as e4s.util.E4Long Numeric, incremental ID for companies Company ID Member of index: #1,#2.
`static E4DBColumnName`	`COL_D_LOGIN` DATE Login Date & Time Member of index: #2.
`static E4DBColumnName`	`COL_D_LOGOUT` DATE Logout Date & Time
`static E4DBColumnName`	`COL_LANG` Language Language
`static E4DBColumnName`	`COL_SESSION_ID` STRING(32) Tomcat Session
`static E4DBColumnName`	`COL_SUCCESSFUL` BOOLEAN Successful Login
`static E4DBColumnName`	`COL_USER_ID` E4CompanyUserId defined as e4s.util.E4String(16) User login name, unique identification for the user in the login process.
`static E4DBColumnInfo[]`	`COLUMNS` Definition of database columns as array
`static E4DBIndexInfo`	`IDX1` Definition of index IDX1.
`static E4DBIndexInfo`	`IDX2` Definition of index IDX2.
`static E4DBIndexInfo[]`	`INDEXES` Definition of table indexes.
`static boolean`	`IS_CLIENT_DISTINCTIVE` This table enables client distinction.
`static boolean`	`IS_FREEDEF_POSSIBLE` This table does not enable freedefined database fields.
`static int`	`SVN_REVISION` SVN Revision Code.
`static E4DBTableName`	`TABLENAME` Name of the database table.

Fields inherited from class e4s.db.E4DBSelect
`COLUMN_NAME_COUNT, COLUMN_NAME_SUM, DB_DATEFORMAT, DB_DATEPICTURE, ms_isunicode, NULL`

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(E4ApplObj_Intf applobj)` Construct an object for selecting data from T_E4S_LOGIN_HISTORY using the default database connection, the table uses client distinction.
`T_E4S_LOGIN_HISTORY_Sel(E4DBConnection_Intf dbcon, E4ApplObj_Intf applobj)` Construct an object for selecting data from T_E4S_LOGIN_HISTORY using a database connection, the table uses client distinction.
`T_E4S_LOGIN_HISTORY_Sel(T_E4S_LOGIN_HISTORY_Sel dbtable, boolean copy_where)` Construct an object for selecting data from T_E4S_LOGIN_HISTORY using an existing T_E4S_LOGIN_HISTORY_Sel instance.

Method Summary
`static java.lang.String`	`_getSVNVersionString()` Return the version info patched by CVS.
`boolean`	`canHaveFreeDefinedFields()` Check, if this table might have freedefined fields.
`static void`	`checkConsistency()` Check table consistency (structure only) against database.
`static void`	`checkConsistency(boolean check_structure, boolean check_index)` Check table consistency against database.
`static E4Fieldset`	`createFIELDSET()`
`static E4Fieldset`	`createFIELDSET(E4ApplObj_Intf applobj)`
`E4Fieldset`	`createFIELDSET(FORM form)`
`E4ID`	`E4ID()`
`java.lang.String`	`get_ADDRESS()` Get value for column ADDRESS.
`E4Client`	`get_CLIENT()` Get value for client.
`E4CompanyId`	`get_COMPANY_ID()` Get value for column COMPANY_ID.
`java.util.Date`	`get_D_LOGIN()` Get value for column D_LOGIN.
`java.util.Date`	`get_D_LOGOUT()` Get value for column D_LOGOUT.
`E4Fieldset`	`get_FIELDSET()`
`E4Fieldset`	`get_FIELDSET(FORM form)`
`Language`	`get_LANG()` Get value for column LANG.
`java.lang.String`	`get_SESSION_ID()` Get value for column SESSION_ID.
`boolean`	`get_SUCCESSFUL()` Get value for column SUCCESSFUL.
`E4CompanyUserId`	`get_USER_ID()` Get value for column USER_ID.
`T_E4S_LOGIN_HISTORY_Obj`	`get()` Get the data object for T_E4S_LOGIN_HISTORY without reading freedefined values.
`void`	`get(E4Fieldset fieldset)`
`E4DBColumnInfo[]`	`getColInfo()` Get information about the columns defined for this database table.
`E4DBIndexInfo[]`	`getIdxInfo()` Get information about the indexes defined for this database table.
`java.lang.Class`	`getModifyClass()` Get the defined and generated class for the modifications, this means INSERT, UPDATE and DELETE, related to this table T_E4S_LOGIN_HISTORY.
`java.lang.Class`	`getObjectClass()` Get the defined and generated class for the data-object related to this table.
`E4PersistantVector`	`getQuery()` `E4DBSelect.executeQuery()` and store elements of type T_E4S_LOGIN_HISTORY_Obj in a Vector.
`E4DBReference[]`	`getReferenceDelete(E4DBColumnName cName)` Return null.
`E4DBReference[]`	`getReferenceLookup(E4DBColumnName cName)` Return null.
`E4DBTypeUsage[]`	`getUsage(E4DBColumnName colname)` For the case, that the specified column is a e4s defined type (e.g.
`boolean`	`hasClientDistinctive()` Get the state if data of this table will be distincted by `E4Client`.
`static boolean`	`isEmpty(E4DBConnection_Intf con, E4ApplObj_Intf applobj)` Check, if this table contains any data.
`E4DBModify_Intf`	`makeInstance_Modify(boolean copy_where)` Make an instance of the associated class for modification of database table entries.
`E4DBSelect_Intf`	`makeInstance(boolean copy_where)` Create a new instance for T_E4S_LOGIN_HISTORY_Sel
`boolean`	`next()` Fetch next record.
`T_E4S_LOGIN_HISTORY_Sel.T_E4S_LOGIN_HISTORY_Or`	`or()`
`void`	`sort_ADDRESS_descending()` Sort descending by column ADDRESS.
`void`	`sort_ADDRESS()` Sort ascending by column ADDRESS.
`void`	`sort_COMPANY_ID_descending()` Sort descending by column COMPANY_ID.
`void`	`sort_COMPANY_ID()` Sort ascending by column COMPANY_ID.
`void`	`sort_D_LOGIN_descending()` Sort descending by column D_LOGIN.
`void`	`sort_D_LOGIN()` Sort ascending by column D_LOGIN.
`void`	`sort_D_LOGOUT_descending()` Sort descending by column D_LOGOUT.
`void`	`sort_D_LOGOUT()` Sort ascending by column D_LOGOUT.
`void`	`sort_LANG_descending()` Sort descending by column LANG.
`void`	`sort_LANG()` Sort ascending by column LANG.
`void`	`sort_SESSION_ID_descending()` Sort descending by column SESSION_ID.
`void`	`sort_SESSION_ID()` Sort ascending by column SESSION_ID.
`void`	`sort_SUCCESSFUL_descending()` Sort descending by column SUCCESSFUL.
`void`	`sort_SUCCESSFUL()` Sort ascending by column SUCCESSFUL.
`void`	`sort_USER_ID_descending()` Sort descending by column USER_ID.
`void`	`sort_USER_ID()` Sort ascending by column USER_ID.
`static int`	`toCsv(E4ApplObj_Intf appobj, java.lang.String path)` Export data from database table to CSV file (MS-Excel input format).
`int`	`toCsv(E4PrintStream out)` Export data from database table to CSV file (MS-Excel compatible input format).
`static void`	`toSql(E4ApplObj_Intf applobj, java.lang.String path)` Export data from database table to SQL script file.
`static int`	`toSql(E4ApplObj_Intf appobj, java.lang.String path, int include_freefields)` Export data from database table to XML file.
`int`	`toSql(E4PrintStream out)` Export data from database table to SQL file.
`int`	`toSql(E4PrintStream out, int include_freefields)` Export data from database table to SQL script file.
`static void`	`toXml(E4ApplObj_Intf applobj, java.lang.String path)` Export data from database table to XML file.
`static void`	`toXml(E4ApplObj_Intf applobj, java.lang.String path, E4StatusInformation_Intf status)`
`static int`	`toXml(E4ApplObj_Intf appobj, java.lang.String path, int include_freefields)` Export data from database table to XML file.
`static int`	`toXml(E4ApplObj_Intf appobj, java.lang.String path, int include_freefields, E4DBColumnName distinctCol)` Export data from database table to XML file.
`static int`	`toXml(E4ApplObj_Intf appobj, java.lang.String path, int include_freefields, E4StatusInformation_Intf status)` Export data from database table to XML file.
`static int`	`toXml(E4ApplObj_Intf appobj, java.lang.String path, int include_freefields, E4StatusInformation_Intf status, E4DBColumnName distinctCol)` Export data from database table to XML file.
`int`	`toXml(E4PrintStream out)` Export data from database table to XML file.
`int`	`toXml(E4PrintStream out, E4StatusInformation_Intf status)` Export data from database table to XML file.
`int`	`toXml(E4PrintStream out, int include_freefields)` Export data from database table to XML file.
`int`	`toXml(E4PrintStream out, int include_freefields, E4StatusInformation_Intf status)` Export data from database table to XML file.
`void`	`where_ADDRESS_in(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_ADDRESS_in(java.lang.String[] filter)` Define a IN-filter (AND-ed WHERE) for column ADDRESS.
`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_not_in(java.lang.String[] filter)` Define a NOT-IN-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_in(Language[] filter)` Define a IN-filter (AND-ed WHERE) for column LANG.
`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_not_in(Language[] filter)` Define a NOT-IN-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_in(java.lang.String[] filter)` Define a IN-filter (AND-ed WHERE) for column SESSION_ID.
`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_not_in(java.lang.String[] filter)` Define a NOT-IN-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(E4CompanyUserId[] filter)` Define a IN-filter (AND-ed WHERE) for column USER_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_not_in(E4CompanyUserId[] filter)` Define a NOT-IN-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.E4DBSelect
checkConsistencyIndex, checkConsistencyIndex, checkConsistencyTable, checkConsistencyTable, checkConsistencyTable, close, data2csv, data2csv, data2csv, data2csv, data2csv, data2csv, data2csv, data2csvHeader, data2csvHeader, disableLogging, enableLogging, enableUnicode, executeCount, executeCountQuery, executeCountQuery, executeCountQuery, executeDistinctQuery, executeDistinctQuery, executeMax, executeMaxDate, executeMaxString, executeMin, executeMinDate, executeMinString, executeQuery, executeQuery, executeQuery, executeSQL, executeSQL, executeSQL, executeSumQuery, executeSumQuery, executeSumQuery, finalize, getBoolean, getConnection, getDate, getDistinctData, getDouble, getE4Long, getE4String, getFirstPrimaryIndex, getFloat, getInt, getLong, getMetaData, getResultSet, getStatement, getString, getTableName, isLogging, isTable, isUnicodeEnabled, isView, removeOwnTableColumn, reset, resetOrderBy, setConnection, setFilterQuery, setFilterQuery, setOrderBy, setOrderBy, setOrderExtended, supportsSorting, toDate, toString, toString

Methods inherited from class e4s.db.E4DBSelect

checkConsistencyIndex, checkConsistencyIndex, checkConsistencyTable, checkConsistencyTable, checkConsistencyTable, close, data2csv, data2csv, data2csv, data2csv, data2csv, data2csv, data2csv, data2csvHeader, data2csvHeader, disableLogging, enableLogging, enableUnicode, executeCount, executeCountQuery, executeCountQuery, executeCountQuery, executeDistinctQuery, executeDistinctQuery, executeMax, executeMaxDate, executeMaxString, executeMin, executeMinDate, executeMinString, executeQuery, executeQuery, executeQuery, executeSQL, executeSQL, executeSQL, executeSumQuery, executeSumQuery, executeSumQuery, finalize, getBoolean, getConnection, getDate, getDistinctData, getDouble, getE4Long, getE4String, getFirstPrimaryIndex, getFloat, getInt, getLong, getMetaData, getResultSet, getStatement, getString, getTableName, isLogging, isTable, isUnicodeEnabled, isView, removeOwnTableColumn, reset, resetOrderBy, setConnection, setFilterQuery, setFilterQuery, setOrderBy, setOrderBy, setOrderExtended, supportsSorting, toDate, toString, toString

Methods inherited from class e4s.db.E4DBFilterAnd
`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`

Methods inherited from class e4s.db.E4DBFilterAnd

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

Methods inherited from class e4s.db.E4DBFilter
`Escape, Escape, 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 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.E4DBSelect_Intf
`close, executeQuery, getApplObj, getBoolean, getConnection, getDate, getFirstPrimaryIndex, getFloat, getLong, getMetaData, getString, getTableName, getWhere, isTable, isView, isWhereDefined, reset, resetOrderBy, resetWhere, setConnection, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setOrderBy, setWhere, supportsSorting, toString`

Methods inherited from interface e4s.db.E4DBFilter_Intf
`isWhereDefined, resetWhere`

Field Detail

TABLENAME

public static final E4DBTableName TABLENAME

Name of the database table.

SVN_REVISION

public static final int SVN_REVISION

SVN Revision Code.

IS_CLIENT_DISTINCTIVE

public static final boolean IS_CLIENT_DISTINCTIVE

This table enables client distinction.

See Also:: E4Client, hasClientDistinctive(), Constant Field Values

IS_FREEDEF_POSSIBLE

public static final boolean IS_FREEDEF_POSSIBLE

This table does not enable freedefined database fields.

See Also:: E4DBFreeFieldName, canHaveFreeDefinedFields(), Constant Field Values

COL_ADDRESS

public static final E4DBColumnName COL_ADDRESS

STRING(255) Remote address

CI_ADDRESS

public static final E4DBColumnInfo CI_ADDRESS

COL_COMPANY_ID

public static final E4DBColumnName COL_COMPANY_ID

E4CompanyId defined as e4s.util.E4Long Numeric, incremental ID for companies Company ID Member of index: #1,#2.

See Also:: E4CompanyId, IDX1, IDX2

CI_COMPANY_ID

public static final E4DBColumnInfo CI_COMPANY_ID

COL_D_LOGIN

public static final E4DBColumnName COL_D_LOGIN

DATE Login Date & Time Member of index: #2.

See Also:: IDX2

CI_D_LOGIN

public static final E4DBColumnInfo CI_D_LOGIN

COL_D_LOGOUT

public static final E4DBColumnName COL_D_LOGOUT

DATE Logout Date & Time

CI_D_LOGOUT

public static final E4DBColumnInfo CI_D_LOGOUT

COL_LANG

public static final E4DBColumnName COL_LANG

Language Language

CI_LANG

public static final E4DBColumnInfo CI_LANG

COL_SESSION_ID

public static final E4DBColumnName COL_SESSION_ID

STRING(32) Tomcat Session

CI_SESSION_ID

public static final E4DBColumnInfo CI_SESSION_ID

COL_SUCCESSFUL

public static final E4DBColumnName COL_SUCCESSFUL

BOOLEAN Successful Login

CI_SUCCESSFUL

public static final E4DBColumnInfo CI_SUCCESSFUL

COL_USER_ID

public static final E4DBColumnName COL_USER_ID

E4CompanyUserId defined as e4s.util.E4String(16) User login name, unique identification for the user in the login process. User ID Member of index: #1,#2.

See Also:: E4CompanyUserId, IDX1, IDX2

CI_USER_ID

public static final E4DBColumnInfo CI_USER_ID

COLUMNS

public static final E4DBColumnInfo[] COLUMNS

Definition of database columns as array

See Also:: INDEXES

IDX1

public static final E4DBIndexInfo IDX1

Definition of index IDX1.

See Also:: COL_USER_ID, COL_USER_ID, COL_COMPANY_ID

IDX2

public static final E4DBIndexInfo IDX2

Definition of index IDX2.

See Also:: COL_COMPANY_ID, COL_COMPANY_ID, COL_D_LOGIN, COL_COMPANY_ID, COL_COMPANY_ID, COL_D_LOGIN, COL_USER_ID

INDEXES

public static final E4DBIndexInfo[] INDEXES

Definition of table indexes.

See Also:: COLUMNS

Constructor Detail

T_E4S_LOGIN_HISTORY_Sel

public T_E4S_LOGIN_HISTORY_Sel(E4DBConnection_Intf dbcon,
                               E4ApplObj_Intf applobj)

Construct an object for selecting data from T_E4S_LOGIN_HISTORY using a database connection, the table uses client distinction.

Parameters:: dbcon - a database connection; applobj - an application object, containing client and other information
See Also:: E4ModuleImplementation.getApplObj(), E4ServletImplementation_Intf.getApplObj()

T_E4S_LOGIN_HISTORY_Sel

public T_E4S_LOGIN_HISTORY_Sel(E4ApplObj_Intf applobj)
                        throws E4DBException

Construct an object for selecting data from T_E4S_LOGIN_HISTORY using the default database connection, the table uses client distinction.

Parameters:: applobj - an application object, containing client and other information
Throws:: E4DBException
See Also:: E4ModuleImplementation.getApplObj(), E4ServletImplementation_Intf.getApplObj()

T_E4S_LOGIN_HISTORY_Sel

public T_E4S_LOGIN_HISTORY_Sel(T_E4S_LOGIN_HISTORY_Sel dbtable,
                               boolean copy_where)
                        throws E4DBException

Construct an object for selecting data from T_E4S_LOGIN_HISTORY using an existing T_E4S_LOGIN_HISTORY_Sel instance.

Parameters:: dbtable - a previous created T_E4S_LOGIN_HISTORY_Sel; copy_where - if true, the WHERE statement from the table is also copied to the new created table.
Throws:: E4DBException

Method Detail

or

public T_E4S_LOGIN_HISTORY_Sel.T_E4S_LOGIN_HISTORY_Or or()

makeInstance

public E4DBSelect_Intf makeInstance(boolean copy_where)
                             throws E4DBException

Create a new instance for T_E4S_LOGIN_HISTORY_Sel

Specified by:: makeInstance in interface E4DBSelect_Intf

Parameters:: copy_where - if true, the WHERE statement from the table is also copied to the new created table.
Throws:: E4DBException

E4ID

public E4ID E4ID()

hasClientDistinctive

public boolean hasClientDistinctive()

Get the state if data of this table will be distincted by E4Client. This is the case, if the E4ApplObj_Intf object was involved during construction of the object.

Specified by:: hasClientDistinctive in interface E4DBSelect_Intf

Returns:: true (client distinction for this table is enabled)
See Also:: E4Client, IS_CLIENT_DISTINCTIVE

canHaveFreeDefinedFields

public boolean canHaveFreeDefinedFields()

Check, if this table might have freedefined fields.

Specified by:: canHaveFreeDefinedFields in interface E4DBSelect_Intf

Returns:: false (table does not enable freedefined database fields)
See Also:: IS_FREEDEF_POSSIBLE

getModifyClass

public java.lang.Class getModifyClass()

Get the defined and generated class for the modifications, this means INSERT, UPDATE and DELETE, related to this table T_E4S_LOGIN_HISTORY.

Specified by:: getModifyClass in interface E4DBSelect_Intf

Returns:: class for the modifications
See Also:: E4DBModify_Intf, E4DBModifyFreefields_Intf, T_E4S_LOGIN_HISTORY_Mod

makeInstance_Modify

public E4DBModify_Intf makeInstance_Modify(boolean copy_where)
                                    throws E4DBException

Make an instance of the associated class for modification of database table entries. If an application object is defined, it will also be handled to the new created instance, as well as the database connection.

Specified by:: makeInstance_Modify in interface E4DBSelect_Intf

Parameters:: copy_where - if true, the WHERE statement from the table is also copied to the new created table.
Throws:: E4DBException
See Also:: makeInstance(boolean)

getObjectClass

public java.lang.Class getObjectClass()

Get the defined and generated class for the data-object related to this table.

Specified by:: getObjectClass in interface E4DBSelect_Intf

Returns:: the data object class
See Also:: T_E4S_LOGIN_HISTORY_Obj

getColInfo

public E4DBColumnInfo[] getColInfo()

Get information about the columns defined for this database table.

Specified by:: getColInfo in interface E4DBSelect_Intf

Returns:: null if no columns are defined, an array of E4DBColumnType objects
See Also:: COLUMNS

getIdxInfo

public E4DBIndexInfo[] getIdxInfo()

Get information about the indexes defined for this database table.

Returns:: null if no index is defined, an array of E4DBIndexInfo objects
See Also:: INDEXES

public boolean next()
             throws E4DBException

Fetch next record.

Specified by:: next in interface E4DBSelect_Intf
Overrides:: next in class E4DBSelect

Returns:: true, if a record is available
Throws:: E4DBException

get_CLIENT

public E4Client get_CLIENT()
                    throws E4DBException

Get value for client.

Returns:: the value for the client.
Throws:: E4DBException

get_ADDRESS

public java.lang.String get_ADDRESS()
                             throws E4DBException

Get value for column ADDRESS. STRING(255) Remote address

Returns:: the database column value retrieved for field ADDRESS
Throws:: E4DBException

get_COMPANY_ID

public E4CompanyId get_COMPANY_ID()
                           throws E4DBException

Get value for column COMPANY_ID. E4CompanyId defined as e4s.util.E4Long Numeric, incremental ID for companies Company ID

Returns:: the database column value retrieved for field COMPANY_ID
Throws:: E4DBException
See Also:: E4CompanyId

get_D_LOGIN

public java.util.Date get_D_LOGIN()
                           throws E4DBException

Get value for column D_LOGIN. DATE Login Date & Time

Returns:: the database column value retrieved for field D_LOGIN
Throws:: E4DBException

get_D_LOGOUT

public java.util.Date get_D_LOGOUT()
                            throws E4DBException

Get value for column D_LOGOUT. DATE Logout Date & Time

Returns:: the database column value retrieved for field D_LOGOUT
Throws:: E4DBException

get_LANG

public Language get_LANG()
                  throws E4DBException

Get value for column LANG. Language Language

Returns:: the database column value retrieved for field LANG
Throws:: E4DBException

get_SESSION_ID

public java.lang.String get_SESSION_ID()
                                throws E4DBException

Get value for column SESSION_ID. STRING(32) Tomcat Session

Returns:: the database column value retrieved for field SESSION_ID
Throws:: E4DBException

get_SUCCESSFUL

public boolean get_SUCCESSFUL()
                       throws E4DBException

Get value for column SUCCESSFUL. BOOLEAN Successful Login

Returns:: the database column value retrieved for field SUCCESSFUL
Throws:: E4DBException

get_USER_ID

public E4CompanyUserId get_USER_ID()
                            throws E4DBException

Get value 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

Returns:: the database column value retrieved for field USER_ID
Throws:: E4DBException
See Also:: E4CompanyUserId

get

public T_E4S_LOGIN_HISTORY_Obj get()
                            throws E4DBException

Get the data object for T_E4S_LOGIN_HISTORY without reading freedefined values.

Parameters:: readfreefields - also include the freefields.
Returns:: the data object.
Throws:: E4DBException

getQuery

public E4PersistantVector getQuery()
                            throws E4DBException

E4DBSelect.executeQuery() and store elements of type T_E4S_LOGIN_HISTORY_Obj in a Vector. Perform a E4DBSelect.close() afterwards.

Throws:: E4DBException

sort_ADDRESS

public void sort_ADDRESS()

Sort ascending by column ADDRESS. STRING(255) Remote address

sort_ADDRESS_descending

public void sort_ADDRESS_descending()

Sort descending by column ADDRESS. STRING(255) Remote address

sort_COMPANY_ID

public void sort_COMPANY_ID()

Sort ascending by column COMPANY_ID. E4CompanyId defined as e4s.util.E4Long Numeric, incremental ID for companies Company ID

See Also:: E4CompanyId

sort_COMPANY_ID_descending

public void sort_COMPANY_ID_descending()

Sort descending by column COMPANY_ID. E4CompanyId defined as e4s.util.E4Long Numeric, incremental ID for companies Company ID

See Also:: E4CompanyId

sort_D_LOGIN

public void sort_D_LOGIN()

Sort ascending by column D_LOGIN. DATE Login Date & Time

sort_D_LOGIN_descending

public void sort_D_LOGIN_descending()

Sort descending by column D_LOGIN. DATE Login Date & Time

sort_D_LOGOUT

public void sort_D_LOGOUT()

Sort ascending by column D_LOGOUT. DATE Logout Date & Time

sort_D_LOGOUT_descending

public void sort_D_LOGOUT_descending()

Sort descending by column D_LOGOUT. DATE Logout Date & Time

sort_LANG

public void sort_LANG()

Sort ascending by column LANG. Language Language

sort_LANG_descending

public void sort_LANG_descending()

Sort descending by column LANG. Language Language

sort_SESSION_ID

public void sort_SESSION_ID()

Sort ascending by column SESSION_ID. STRING(32) Tomcat Session

sort_SESSION_ID_descending

public void sort_SESSION_ID_descending()

Sort descending by column SESSION_ID. STRING(32) Tomcat Session

sort_SUCCESSFUL

public void sort_SUCCESSFUL()

Sort ascending by column SUCCESSFUL. BOOLEAN Successful Login

sort_SUCCESSFUL_descending

public void sort_SUCCESSFUL_descending()

Sort descending by column SUCCESSFUL. BOOLEAN Successful Login

sort_USER_ID

public void sort_USER_ID()

Sort ascending by column USER_ID. E4CompanyUserId defined as e4s.util.E4String(16) User login name, unique identification for the user in the login process. User ID

See Also:: E4CompanyUserId

sort_USER_ID_descending

public void sort_USER_ID_descending()

Sort descending by column USER_ID. E4CompanyUserId defined as e4s.util.E4String(16) User login name, unique identification for the user in the login process. User ID

See Also:: E4CompanyUserId

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_in

public void where_ADDRESS_in(java.lang.String[] filter)
                      throws E4DBException

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

Throws:: E4DBException

where_ADDRESS_not_in

public void where_ADDRESS_not_in(java.lang.String[] filter)
                          throws E4DBException

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

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_in

public void where_LANG_in(Language[] filter)
                   throws E4DBException

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

Throws:: E4DBException

where_LANG_not_in

public void where_LANG_not_in(Language[] filter)
                       throws E4DBException

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

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_in

public void where_SESSION_ID_in(java.lang.String[] filter)
                         throws E4DBException

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

Throws:: E4DBException

where_SESSION_ID_not_in

public void where_SESSION_ID_not_in(java.lang.String[] filter)
                             throws E4DBException

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

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_in

public void where_USER_ID_in(E4CompanyUserId[] filter)
                      throws E4DBException

Define a IN-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_not_in

public void where_USER_ID_not_in(E4CompanyUserId[] filter)
                          throws E4DBException

Define a NOT-IN-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_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

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

getReferenceDelete

public E4DBReference[] getReferenceDelete(E4DBColumnName cName)

Description copied from class: E4DBSelect

Return null.

Specified by:: getReferenceDelete in interface E4DBSelect_Intf
Overrides:: getReferenceDelete in class E4DBSelect

Parameters:: cName - the column which references needs to be deleted (the "master")
Returns:: null, if no referential delete is defined for that column, or a list of references (the "detail")

getReferenceLookup

public E4DBReference[] getReferenceLookup(E4DBColumnName cName)

Description copied from class: E4DBSelect

Return null.

Specified by:: getReferenceLookup in interface E4DBSelect_Intf
Overrides:: getReferenceLookup in class E4DBSelect

Parameters:: cName - the column which references needs to be deleted (the "master")
Returns:: null, if no referential lookup is defined for that column, or a list of references (the "detail")

createFIELDSET

public E4Fieldset createFIELDSET(FORM form)

Specified by:: createFIELDSET in interface E4DBSelect_Intf

createFIELDSET

public static E4Fieldset createFIELDSET()

createFIELDSET

public static E4Fieldset createFIELDSET(E4ApplObj_Intf applobj)

get_FIELDSET

public E4Fieldset get_FIELDSET()
                        throws E4DBException

Throws:: E4DBException

get_FIELDSET

public E4Fieldset get_FIELDSET(FORM form)
                        throws E4DBException

Specified by:: get_FIELDSET in interface E4DBSelect_Intf

Throws:: E4DBException

get

public void get(E4Fieldset fieldset)
         throws E4DBException

Specified by:: get in interface E4DBSelect_Intf

Throws:: E4DBException

getUsage

public E4DBTypeUsage[] getUsage(E4DBColumnName colname)

For the case, that the specified column is a e4s defined type (e.g. E4Long, E4String) this function returns an array in which tables and columns this type is used, except the current table and the specified column.

Specified by:: getUsage in interface E4DBSelect_Intf

Parameters:: colname - the column to be checked
See Also:: E4DBIntegrity

isEmpty

public static boolean isEmpty(E4DBConnection_Intf con,
                              E4ApplObj_Intf applobj)
                       throws E4DBException

Check, if this table contains any data.

Parameters:: con - the connection; applobj - the application object containing the Client to be checked
Throws:: E4DBException

toXml

public static void toXml(E4ApplObj_Intf applobj,
                         java.lang.String path)
                  throws E4DBException,
                         java.io.IOException

Export data from database table to XML file.

Parameters:: applobj - a valid application object.; path - the output path.
Throws:: E4DBException; java.io.IOException

toXml

public int toXml(E4PrintStream out)
          throws E4DBException

Export data from database table to XML file.

Parameters:: out - an opened output stream
Returns:: the number of records written
Throws:: E4DBException
See Also:: toCsv(e4s.util.E4PrintStream), #toXml(String)

toXml

public static void toXml(E4ApplObj_Intf applobj,
                         java.lang.String path,
                         E4StatusInformation_Intf status)
                  throws E4DBException,
                         java.io.IOException

Throws:: E4DBException; java.io.IOException

toXml

public int toXml(E4PrintStream out,
                 E4StatusInformation_Intf status)
          throws E4DBException

Export data from database table to XML file.

Parameters:: out - an opened output stream
Returns:: the number of records written
Throws:: E4DBException
See Also:: toCsv(e4s.util.E4PrintStream), #toXml(String)

toXml

public int toXml(E4PrintStream out,
                 int include_freefields)
          throws E4DBException

Export data from database table to XML file.

Parameters:: out - an opened output stream
Returns:: the number of records written
Throws:: E4DBException
See Also:: toCsv(e4s.util.E4PrintStream), #toXml(String)

toXml

public int toXml(E4PrintStream out,
                 int include_freefields,
                 E4StatusInformation_Intf status)
          throws E4DBException

Export data from database table to XML file.

Parameters:: out - an opened output stream; include_freefields - mode, how freefields shall be included; status - an optional status tracker interface
Returns:: the number of records written
Throws:: E4DBException
See Also:: toCsv(e4s.util.E4PrintStream), #toXml(String)

toXml

public static int toXml(E4ApplObj_Intf appobj,
                        java.lang.String path,
                        int include_freefields)
                 throws E4DBException,
                        java.io.IOException

Export data from database table to XML file.

Parameters:: appobj - the current application object containing client informations; path - the path for file export
Returns:: the number of records written
Throws:: E4DBException; java.io.IOException

toXml

public static int toXml(E4ApplObj_Intf appobj,
                        java.lang.String path,
                        int include_freefields,
                        E4DBColumnName distinctCol)
                 throws E4DBException,
                        java.io.IOException

Export data from database table to XML file.

Parameters:: appobj - the current application object containing client informations; path - the path for file export
Returns:: the number of records written
Throws:: E4DBException; java.io.IOException

toXml

public static int toXml(E4ApplObj_Intf appobj,
                        java.lang.String path,
                        int include_freefields,
                        E4StatusInformation_Intf status)
                 throws E4DBException,
                        java.io.IOException

Export data from database table to XML file.

Parameters:: appobj - the current application object containing client informations; path - the path for file export
Returns:: the number of records written
Throws:: E4DBException; java.io.IOException

toXml

public static int toXml(E4ApplObj_Intf appobj,
                        java.lang.String path,
                        int include_freefields,
                        E4StatusInformation_Intf status,
                        E4DBColumnName distinctCol)
                 throws E4DBException,
                        java.io.IOException

Export data from database table to XML file.

Parameters:: appobj - the current application object containing client informations; path - the path for file export
Returns:: the number of records written
Throws:: E4DBException; java.io.IOException

toCsv

public int toCsv(E4PrintStream out)
          throws E4DBException

Export data from database table to CSV file (MS-Excel compatible input format).

Parameters:: out - an opened output stream; freefields - true include freefield values in export.
Returns:: the number of records written
Throws:: E4DBException

toCsv

public static int toCsv(E4ApplObj_Intf appobj,
                        java.lang.String path)
                 throws E4DBException,
                        java.io.IOException

Export data from database table to CSV file (MS-Excel input format).

Parameters:: appobj - the current application object containing client informations; path - the path for file export
Returns:: the number of records written
Throws:: E4DBException; java.io.IOException

toSql

public static void toSql(E4ApplObj_Intf applobj,
                         java.lang.String path)
                  throws E4DBException,
                         java.io.IOException

Export data from database table to SQL script file.

Parameters:: applobj - a valid application object.; path - the output path.
Throws:: E4DBException; java.io.IOException

toSql

public int toSql(E4PrintStream out)
          throws E4DBException

Export data from database table to SQL file.

Parameters:: out - an opened output stream
Returns:: the number of records written
Throws:: E4DBException
See Also:: toXml(e4s.util.E4PrintStream), toCsv(e4s.util.E4PrintStream), #toSql(String)

toSql

public int toSql(E4PrintStream out,
                 int include_freefields)
          throws E4DBException

Export data from database table to SQL script file.

Parameters:: out - an opened output stream
Returns:: the number of records written
Throws:: E4DBException
See Also:: toXml(e4s.util.E4PrintStream), toCsv(e4s.util.E4PrintStream), #toSql(String)

toSql

public static int toSql(E4ApplObj_Intf appobj,
                        java.lang.String path,
                        int include_freefields)
                 throws E4DBException,
                        java.io.IOException

Export data from database table to XML file.

Parameters:: appobj - the current application object containing client informations; path - the path for file export
Returns:: the number of records written
Throws:: E4DBException; java.io.IOException

checkConsistency

public static void checkConsistency()
                             throws E4DBException

Check table consistency (structure only) against database.

Throws:: E4DBException

checkConsistency

public static void checkConsistency(boolean check_structure,
                                    boolean check_index)
                             throws E4DBException

Check table consistency against database.

Parameters:: check_structure - check the table structure; check_index - check the index (can be time consuming on startup)
Throws:: E4DBException

_getSVNVersionString

public static java.lang.String _getSVNVersionString()

Return the version info patched by CVS.

Overview

Package

Class

Tree

Deprecated

Index

Help

www.element4solution.com

PREV CLASS NEXT CLASS

FRAMES NO FRAMES

SUMMARY: NESTED | FIELD | CONSTR | METHOD

DETAIL: FIELD | CONSTR | METHOD

e4s.db.systabledef Class T_E4S_LOGIN_HISTORY_Sel

TABLENAME

SVN_REVISION

IS_CLIENT_DISTINCTIVE

IS_FREEDEF_POSSIBLE

COL_ADDRESS

CI_ADDRESS

COL_COMPANY_ID

CI_COMPANY_ID

COL_D_LOGIN

CI_D_LOGIN

COL_D_LOGOUT

CI_D_LOGOUT

COL_LANG

CI_LANG

COL_SESSION_ID

CI_SESSION_ID

COL_SUCCESSFUL

CI_SUCCESSFUL

COL_USER_ID

CI_USER_ID

COLUMNS

IDX1

IDX2

INDEXES

T_E4S_LOGIN_HISTORY_Sel

T_E4S_LOGIN_HISTORY_Sel

T_E4S_LOGIN_HISTORY_Sel

or

makeInstance

E4ID

hasClientDistinctive

canHaveFreeDefinedFields

getModifyClass

makeInstance_Modify

getObjectClass

getColInfo

getIdxInfo

next

get_CLIENT

get_ADDRESS

get_COMPANY_ID

get_D_LOGIN

get_D_LOGOUT

get_LANG

get_SESSION_ID

get_SUCCESSFUL

get_USER_ID

get

getQuery

sort_ADDRESS

sort_ADDRESS_descending

sort_COMPANY_ID

sort_COMPANY_ID_descending

sort_D_LOGIN

sort_D_LOGIN_descending

sort_D_LOGOUT

sort_D_LOGOUT_descending

sort_LANG

sort_LANG_descending

sort_SESSION_ID

sort_SESSION_ID_descending

sort_SUCCESSFUL

sort_SUCCESSFUL_descending

sort_USER_ID

sort_USER_ID_descending

where_ADDRESS

where_ADDRESS

where_ADDRESS_in

where_ADDRESS_not_in

where_ADDRESS_isNull

where_ADDRESS_isNotNull

where_ADDRESS_in

where_ADDRESS_notin

where_ADDRESS_isEmpty

where_ADDRESS_isNotEmpty

where_COMPANY_ID

where_COMPANY_ID

where_COMPANY_ID_in

where_COMPANY_ID_notin

e4s.db.systabledef
Class T_E4S_LOGIN_HISTORY_Sel