T_E4S_MAIL_SENT

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_MAIL_SENT_Sel

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

All Implemented Interfaces:: E4DBFilter_Intf, E4DBFilterAnd_Intf, E4DBSelect_Intf

public class T_E4S_MAIL_SENT_Sel
extends E4DBSelect
implements E4DBSelect_Intf
extends E4DBSelect
implements E4DBSelect_Intf

SQL select for T_E4S_MAIL_SENT: Logging of sent eMails by the E4S mail implementation. created: 20051005 115548, modified: 20071103 130220. $LastChangedRevision: 5290 $ $LastChangedDate: 2009-12-09 18:45:55 +0100 (Mi, 09 Dez 2009) $

Column	Datatype		Remark
CREATED	DATE	2	Date/Time mail created
EMAIL_CC	STRING(255)		E-Mail Address (cc)
EMAIL_FROM	STRING(255)		E-Mail Address (sender)
EMAIL_TO	STRING(255)	1	E-Mail Address (recipient)
ERRMSG	TEXT		Error Message
HEADER	STRING(255)		Header
ID	INTEGER	5	ID
IS_HTML_FORMAT	BOOLEAN		true if HTML, false if Text
SENT	DATE		Date and Time mail sent
TXT	TEXT		Text

Index 1: IDX1 Index 2: IDX2 Index 5: AINCR unique

See Also:: T_E4S_MAIL_SENT_Mod, T_E4S_MAIL_SENT_Obj

Nested Class Summary
`static class`	`T_E4S_MAIL_SENT_Sel.T_E4S_MAIL_SENT_And` Filter to be used as AND condition.
`static class`	`T_E4S_MAIL_SENT_Sel.T_E4S_MAIL_SENT_Or` Filter to be used as OR condition.

Field Summary
`static E4DBColumnInfo`	`CI_CREATED`
`static E4DBColumnInfo`	`CI_EMAIL_CC`
`static E4DBColumnInfo`	`CI_EMAIL_FROM`
`static E4DBColumnInfo`	`CI_EMAIL_TO`
`static E4DBColumnInfo`	`CI_ERRMSG`
`static E4DBColumnInfo`	`CI_HEADER`
`static E4DBColumnInfo`	`CI_ID`
`static E4DBColumnInfo`	`CI_IS_HTML_FORMAT`
`static E4DBColumnInfo`	`CI_SENT`
`static E4DBColumnInfo`	`CI_TXT`
`static E4DBColumnName`	`COL_CREATED` DATE Date/Time mail created Member of index: #2.
`static E4DBColumnName`	`COL_EMAIL_CC` STRING(255) E-Mail Address (cc)
`static E4DBColumnName`	`COL_EMAIL_FROM` STRING(255) E-Mail Address (sender)
`static E4DBColumnName`	`COL_EMAIL_TO` STRING(255) E-Mail Address (recipient) Member of index: #1.
`static E4DBColumnName`	`COL_ERRMSG` TEXT Error Message
`static E4DBColumnName`	`COL_HEADER` STRING(255) Header
`static E4DBColumnName`	`COL_ID` INTEGER ID Autoincremental value Member of index: AINCR.
`static E4DBColumnName`	`COL_IS_HTML_FORMAT` BOOLEAN true if HTML, false if Text
`static E4DBColumnName`	`COL_SENT` DATE Date and Time mail sent
`static E4DBColumnName`	`COL_TXT` TEXT Text
`static E4DBColumnInfo[]`	`COLUMNS` Definition of database columns as array
`static E4DBIndexInfo`	`IDX_AINCR` Definition of index IDX_AINCR.
`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_MAIL_SENT_Sel(E4ApplObj_Intf applobj)` Construct an object for selecting data from T_E4S_MAIL_SENT using the default database connection, the table uses client distinction.
`T_E4S_MAIL_SENT_Sel(E4DBConnection_Intf dbcon, E4ApplObj_Intf applobj)` Construct an object for selecting data from T_E4S_MAIL_SENT using a database connection, the table uses client distinction.
`T_E4S_MAIL_SENT_Sel(T_E4S_MAIL_SENT_Sel dbtable, boolean copy_where)` Construct an object for selecting data from T_E4S_MAIL_SENT using an existing T_E4S_MAIL_SENT_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()`
`static T_E4S_MAIL_SENT_Obj`	`find_AINCR(E4ApplObj_Intf appobj, long qID)` Find a record associates with unique index 5 (AINCR).
`static T_E4S_MAIL_SENT_Obj`	`find_AINCR(E4DBConnection_Intf con, E4ApplObj_Intf appobj, long qID)` Find a record associates with index 5 (AINCR).
`E4Client`	`get_CLIENT()` Get value for client.
`java.util.Date`	`get_CREATED()` Get value for column CREATED.
`java.lang.String`	`get_EMAIL_CC()` Get value for column EMAIL_CC.
`java.lang.String`	`get_EMAIL_FROM()` Get value for column EMAIL_FROM.
`java.lang.String`	`get_EMAIL_TO()` Get value for column EMAIL_TO.
`java.lang.String`	`get_ERRMSG()` Get value for column ERRMSG.
`E4Fieldset`	`get_FIELDSET()`
`E4Fieldset`	`get_FIELDSET(FORM form)`
`java.lang.String`	`get_HEADER()` Get value for column HEADER.
`long`	`get_ID()` Get value for column ID.
`boolean`	`get_IS_HTML_FORMAT()` Get value for column IS_HTML_FORMAT.
`java.util.Date`	`get_SENT()` Get value for column SENT.
`java.lang.String`	`get_TXT()` Get value for column TXT.
`T_E4S_MAIL_SENT_Obj`	`get()` Get the data object for T_E4S_MAIL_SENT without reading freedefined values.
`void`	`get(E4Fieldset fieldset)`
`E4DBColumnInfo[]`	`getColInfo()` Get information about the columns defined for this database table.
`E4DBIndexInfo`	`getFirstPrimaryIndex()` Get the fields defined for the first unique index `IDX_AINCR`.
`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_MAIL_SENT.
`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_MAIL_SENT_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_MAIL_SENT_Sel
`boolean`	`next()` Fetch next record.
`T_E4S_MAIL_SENT_Sel.T_E4S_MAIL_SENT_Or`	`or()`
`void`	`sort_CREATED_descending()` Sort descending by column CREATED.
`void`	`sort_CREATED()` Sort ascending by column CREATED.
`void`	`sort_EMAIL_CC_descending()` Sort descending by column EMAIL_CC.
`void`	`sort_EMAIL_CC()` Sort ascending by column EMAIL_CC.
`void`	`sort_EMAIL_FROM_descending()` Sort descending by column EMAIL_FROM.
`void`	`sort_EMAIL_FROM()` Sort ascending by column EMAIL_FROM.
`void`	`sort_EMAIL_TO_descending()` Sort descending by column EMAIL_TO.
`void`	`sort_EMAIL_TO()` Sort ascending by column EMAIL_TO.
`void`	`sort_HEADER_descending()` Sort descending by column HEADER.
`void`	`sort_HEADER()` Sort ascending by column HEADER.
`void`	`sort_ID_descending()` Sort descending by column ID.
`void`	`sort_ID()` Sort ascending by column ID.
`void`	`sort_IS_HTML_FORMAT_descending()` Sort descending by column IS_HTML_FORMAT.
`void`	`sort_IS_HTML_FORMAT()` Sort ascending by column IS_HTML_FORMAT.
`void`	`sort_SENT_descending()` Sort descending by column SENT.
`void`	`sort_SENT()` Sort ascending by column SENT.
`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_CREATED_in(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_CREATED_isEmpty()` Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column CREATED.
`void`	`where_CREATED_isNotEmpty()` Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column CREATED.
`void`	`where_CREATED_isNotNull()` Define a is-NOT-null filter (AND-ed WHERE) for column CREATED.
`void`	`where_CREATED_isNull()` Define a is-null filter (AND-ed WHERE) for column CREATED.
`void`	`where_CREATED_notin(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_CREATED(java.util.Date filter)` Define a filter (AND-ed WHERE) for column CREATED.
`void`	`where_CREATED(int operator, java.util.Date filter)` Define a filter (AND-ed WHERE with operator) for column CREATED.
`void`	`where_EMAIL_CC_in(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_EMAIL_CC_in(java.lang.String[] filter)` Define a IN-filter (AND-ed WHERE) for column EMAIL_CC.
`void`	`where_EMAIL_CC_isEmpty()` Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column EMAIL_CC.
`void`	`where_EMAIL_CC_isNotEmpty()` Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column EMAIL_CC.
`void`	`where_EMAIL_CC_isNotNull()` Define a is-NOT-null filter (AND-ed WHERE) for column EMAIL_CC.
`void`	`where_EMAIL_CC_isNull()` Define a is-null filter (AND-ed WHERE) for column EMAIL_CC.
`void`	`where_EMAIL_CC_not_in(java.lang.String[] filter)` Define a NOT-IN-filter (AND-ed WHERE) for column EMAIL_CC.
`void`	`where_EMAIL_CC_notin(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_EMAIL_CC(int operator, java.lang.String filter)` Define a filter (AND-ed WHERE with operator) for column EMAIL_CC.
`void`	`where_EMAIL_CC(java.lang.String filter)` Define a filter (AND-ed WHERE) for column EMAIL_CC.
`void`	`where_EMAIL_FROM_in(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_EMAIL_FROM_in(java.lang.String[] filter)` Define a IN-filter (AND-ed WHERE) for column EMAIL_FROM.
`void`	`where_EMAIL_FROM_isEmpty()` Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column EMAIL_FROM.
`void`	`where_EMAIL_FROM_isNotEmpty()` Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column EMAIL_FROM.
`void`	`where_EMAIL_FROM_isNotNull()` Define a is-NOT-null filter (AND-ed WHERE) for column EMAIL_FROM.
`void`	`where_EMAIL_FROM_isNull()` Define a is-null filter (AND-ed WHERE) for column EMAIL_FROM.
`void`	`where_EMAIL_FROM_not_in(java.lang.String[] filter)` Define a NOT-IN-filter (AND-ed WHERE) for column EMAIL_FROM.
`void`	`where_EMAIL_FROM_notin(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_EMAIL_FROM(int operator, java.lang.String filter)` Define a filter (AND-ed WHERE with operator) for column EMAIL_FROM.
`void`	`where_EMAIL_FROM(java.lang.String filter)` Define a filter (AND-ed WHERE) for column EMAIL_FROM.
`void`	`where_EMAIL_TO_in(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_EMAIL_TO_in(java.lang.String[] filter)` Define a IN-filter (AND-ed WHERE) for column EMAIL_TO.
`void`	`where_EMAIL_TO_isEmpty()` Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column EMAIL_TO.
`void`	`where_EMAIL_TO_isNotEmpty()` Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column EMAIL_TO.
`void`	`where_EMAIL_TO_isNotNull()` Define a is-NOT-null filter (AND-ed WHERE) for column EMAIL_TO.
`void`	`where_EMAIL_TO_isNull()` Define a is-null filter (AND-ed WHERE) for column EMAIL_TO.
`void`	`where_EMAIL_TO_not_in(java.lang.String[] filter)` Define a NOT-IN-filter (AND-ed WHERE) for column EMAIL_TO.
`void`	`where_EMAIL_TO_notin(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_EMAIL_TO(int operator, java.lang.String filter)` Define a filter (AND-ed WHERE with operator) for column EMAIL_TO.
`void`	`where_EMAIL_TO(java.lang.String filter)` Define a filter (AND-ed WHERE) for column EMAIL_TO.
`void`	`where_ERRMSG(int operator, java.lang.String filter)` Define a filter (AND-ed WHERE with operator) for column ERRMSG.
`void`	`where_ERRMSG(java.lang.String filter)` Define a filter (AND-ed WHERE) for column ERRMSG.
`void`	`where_HEADER_in(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_HEADER_in(java.lang.String[] filter)` Define a IN-filter (AND-ed WHERE) for column HEADER.
`void`	`where_HEADER_isEmpty()` Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column HEADER.
`void`	`where_HEADER_isNotEmpty()` Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column HEADER.
`void`	`where_HEADER_isNotNull()` Define a is-NOT-null filter (AND-ed WHERE) for column HEADER.
`void`	`where_HEADER_isNull()` Define a is-null filter (AND-ed WHERE) for column HEADER.
`void`	`where_HEADER_not_in(java.lang.String[] filter)` Define a NOT-IN-filter (AND-ed WHERE) for column HEADER.
`void`	`where_HEADER_notin(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_HEADER(int operator, java.lang.String filter)` Define a filter (AND-ed WHERE with operator) for column HEADER.
`void`	`where_HEADER(java.lang.String filter)` Define a filter (AND-ed WHERE) for column HEADER.
`void`	`where_ID_in(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_ID_notin(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_ID(int operator, long filter)` Define a filter (AND-ed WHERE with operator) for column ID.
`void`	`where_ID(long filter)` Define a filter (AND-ed WHERE) for column ID.
`void`	`where_IS_HTML_FORMAT(boolean filter)` Define a filter (AND-ed WHERE) for column IS_HTML_FORMAT.
`void`	`where_IS_HTML_FORMAT(int operator, boolean filter)` Define a filter (AND-ed WHERE with operator) for column IS_HTML_FORMAT.
`void`	`where_SENT_in(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_SENT_isEmpty()` Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column SENT.
`void`	`where_SENT_isNotEmpty()` Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column SENT.
`void`	`where_SENT_isNotNull()` Define a is-NOT-null filter (AND-ed WHERE) for column SENT.
`void`	`where_SENT_isNull()` Define a is-null filter (AND-ed WHERE) for column SENT.
`void`	`where_SENT_notin(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_SENT(java.util.Date filter)` Define a filter (AND-ed WHERE) for column SENT.
`void`	`where_SENT(int operator, java.util.Date filter)` Define a filter (AND-ed WHERE with operator) for column SENT.
`void`	`where_TXT(int operator, java.lang.String filter)` Define a filter (AND-ed WHERE with operator) for column TXT.
`void`	`where_TXT(java.lang.String filter)` Define a filter (AND-ed WHERE) for column TXT.

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, 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, 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, toString, wait, wait, wait`

Methods inherited from interface e4s.db.E4DBSelect_Intf
`close, executeQuery, getApplObj, getBoolean, getConnection, getDate, 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_CREATED

public static final E4DBColumnName COL_CREATED

DATE Date/Time mail created Member of index: #2.

See Also:: IDX2

CI_CREATED

public static final E4DBColumnInfo CI_CREATED

COL_EMAIL_CC

public static final E4DBColumnName COL_EMAIL_CC

STRING(255) E-Mail Address (cc)

CI_EMAIL_CC

public static final E4DBColumnInfo CI_EMAIL_CC

COL_EMAIL_FROM

public static final E4DBColumnName COL_EMAIL_FROM

STRING(255) E-Mail Address (sender)

CI_EMAIL_FROM

public static final E4DBColumnInfo CI_EMAIL_FROM

COL_EMAIL_TO

public static final E4DBColumnName COL_EMAIL_TO

STRING(255) E-Mail Address (recipient) Member of index: #1.

See Also:: IDX1

CI_EMAIL_TO

public static final E4DBColumnInfo CI_EMAIL_TO

COL_ERRMSG

public static final E4DBColumnName COL_ERRMSG

TEXT Error Message

CI_ERRMSG

public static final E4DBColumnInfo CI_ERRMSG

COL_HEADER

public static final E4DBColumnName COL_HEADER

STRING(255) Header

CI_HEADER

public static final E4DBColumnInfo CI_HEADER

COL_ID

public static final E4DBColumnName COL_ID

INTEGER ID Autoincremental value Member of index: AINCR.

See Also:: IDX_AINCR

CI_ID

public static final E4DBColumnInfo CI_ID

COL_IS_HTML_FORMAT

public static final E4DBColumnName COL_IS_HTML_FORMAT

BOOLEAN true if HTML, false if Text

CI_IS_HTML_FORMAT

public static final E4DBColumnInfo CI_IS_HTML_FORMAT

COL_SENT

public static final E4DBColumnName COL_SENT

DATE Date and Time mail sent

CI_SENT

public static final E4DBColumnInfo CI_SENT

COL_TXT

public static final E4DBColumnName COL_TXT

TEXT Text

CI_TXT

public static final E4DBColumnInfo CI_TXT

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_EMAIL_TO

IDX2

public static final E4DBIndexInfo IDX2

Definition of index IDX2.

See Also:: COL_CREATED

IDX_AINCR

public static final E4DBIndexInfo IDX_AINCR

Definition of index IDX_AINCR.

See Also:: COL_ID

INDEXES

public static final E4DBIndexInfo[] INDEXES

Definition of table indexes.

See Also:: COLUMNS

Constructor Detail

T_E4S_MAIL_SENT_Sel

public T_E4S_MAIL_SENT_Sel(E4DBConnection_Intf dbcon,
                           E4ApplObj_Intf applobj)

Construct an object for selecting data from T_E4S_MAIL_SENT 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_MAIL_SENT_Sel

public T_E4S_MAIL_SENT_Sel(E4ApplObj_Intf applobj)
                    throws E4DBException

Construct an object for selecting data from T_E4S_MAIL_SENT 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_MAIL_SENT_Sel

public T_E4S_MAIL_SENT_Sel(T_E4S_MAIL_SENT_Sel dbtable,
                           boolean copy_where)
                    throws E4DBException

Construct an object for selecting data from T_E4S_MAIL_SENT using an existing T_E4S_MAIL_SENT_Sel instance.

Parameters:: dbtable - a previous created T_E4S_MAIL_SENT_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_MAIL_SENT_Sel.T_E4S_MAIL_SENT_Or or()

makeInstance

public E4DBSelect_Intf makeInstance(boolean copy_where)
                             throws E4DBException

Create a new instance for T_E4S_MAIL_SENT_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_MAIL_SENT.

Specified by:: getModifyClass in interface E4DBSelect_Intf

Returns:: class for the modifications
See Also:: E4DBModify_Intf, E4DBModifyFreefields_Intf, T_E4S_MAIL_SENT_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_MAIL_SENT_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

getFirstPrimaryIndex

public E4DBIndexInfo getFirstPrimaryIndex()

Get the fields defined for the first unique index IDX_AINCR.

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

Returns:: IDX_AINCR.

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_CREATED

public java.util.Date get_CREATED()
                           throws E4DBException

Get value for column CREATED. DATE Date/Time mail created

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

get_EMAIL_CC

public java.lang.String get_EMAIL_CC()
                              throws E4DBException

Get value for column EMAIL_CC. STRING(255) E-Mail Address (cc)

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

get_EMAIL_FROM

public java.lang.String get_EMAIL_FROM()
                                throws E4DBException

Get value for column EMAIL_FROM. STRING(255) E-Mail Address (sender)

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

get_EMAIL_TO

public java.lang.String get_EMAIL_TO()
                              throws E4DBException

Get value for column EMAIL_TO. STRING(255) E-Mail Address (recipient)

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

get_ERRMSG

public java.lang.String get_ERRMSG()
                            throws E4DBException

Get value for column ERRMSG. TEXT Error Message

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

get_HEADER

public java.lang.String get_HEADER()
                            throws E4DBException

Get value for column HEADER. STRING(255) Header

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

get_ID

public long get_ID()
            throws E4DBException

Get value for column ID. INTEGER ID Autoincremental value

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

get_IS_HTML_FORMAT

public boolean get_IS_HTML_FORMAT()
                           throws E4DBException

Get value for column IS_HTML_FORMAT. BOOLEAN true if HTML, false if Text

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

get_SENT

public java.util.Date get_SENT()
                        throws E4DBException

Get value for column SENT. DATE Date and Time mail sent

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

get_TXT

public java.lang.String get_TXT()
                         throws E4DBException

Get value for column TXT. TEXT Text

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

get

public T_E4S_MAIL_SENT_Obj get()
                        throws E4DBException

Get the data object for T_E4S_MAIL_SENT 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_MAIL_SENT_Obj in a Vector. Perform a E4DBSelect.close() afterwards.

Throws:: E4DBException

sort_CREATED

public void sort_CREATED()

Sort ascending by column CREATED. DATE Date/Time mail created

sort_CREATED_descending

public void sort_CREATED_descending()

Sort descending by column CREATED. DATE Date/Time mail created

sort_EMAIL_CC

public void sort_EMAIL_CC()

Sort ascending by column EMAIL_CC. STRING(255) E-Mail Address (cc)

sort_EMAIL_CC_descending

public void sort_EMAIL_CC_descending()

Sort descending by column EMAIL_CC. STRING(255) E-Mail Address (cc)

sort_EMAIL_FROM

public void sort_EMAIL_FROM()

Sort ascending by column EMAIL_FROM. STRING(255) E-Mail Address (sender)

sort_EMAIL_FROM_descending

public void sort_EMAIL_FROM_descending()

Sort descending by column EMAIL_FROM. STRING(255) E-Mail Address (sender)

sort_EMAIL_TO

public void sort_EMAIL_TO()

Sort ascending by column EMAIL_TO. STRING(255) E-Mail Address (recipient)

sort_EMAIL_TO_descending

public void sort_EMAIL_TO_descending()

Sort descending by column EMAIL_TO. STRING(255) E-Mail Address (recipient)

sort_HEADER

public void sort_HEADER()

Sort ascending by column HEADER. STRING(255) Header

sort_HEADER_descending

public void sort_HEADER_descending()

Sort descending by column HEADER. STRING(255) Header

sort_ID

public void sort_ID()

Sort ascending by column ID. INTEGER ID Autoincremental value

sort_ID_descending

public void sort_ID_descending()

Sort descending by column ID. INTEGER ID Autoincremental value

sort_IS_HTML_FORMAT

public void sort_IS_HTML_FORMAT()

Sort ascending by column IS_HTML_FORMAT. BOOLEAN true if HTML, false if Text

sort_IS_HTML_FORMAT_descending

public void sort_IS_HTML_FORMAT_descending()

Sort descending by column IS_HTML_FORMAT. BOOLEAN true if HTML, false if Text

sort_SENT

public void sort_SENT()

Sort ascending by column SENT. DATE Date and Time mail sent

sort_SENT_descending

public void sort_SENT_descending()

Sort descending by column SENT. DATE Date and Time mail sent

where_CREATED

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

Define a filter (AND-ed WHERE) for column CREATED. DATE Date/Time mail created

Parameters:: filter - the value to be compared within the SQL statement
Throws:: E4DBException

where_CREATED

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

Define a filter (AND-ed WHERE with operator) for column CREATED. DATE Date/Time mail created

Parameters:: filter - the value to be compared within the SQL statement; operator - the comparsion operator E4DBFilter
Throws:: E4DBException

where_CREATED_isNull

public void where_CREATED_isNull()
                          throws E4DBException

Define a is-null filter (AND-ed WHERE) for column CREATED. DATE Date/Time mail created

Throws:: E4DBException

where_CREATED_isNotNull

public void where_CREATED_isNotNull()
                             throws E4DBException

Define a is-NOT-null filter (AND-ed WHERE) for column CREATED. DATE Date/Time mail created

Throws:: E4DBException

where_CREATED_in

public void where_CREATED_in(E4DBSelectDistinct filter)
                      throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) CREATED. DATE Date/Time mail created

Parameters:: filter - the value to be compared within the SQL statement
Throws:: E4DBException

where_CREATED_notin

public void where_CREATED_notin(E4DBSelectDistinct filter)
                         throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) CREATED. DATE Date/Time mail created

Parameters:: filter - the value to be compared within the SQL statement
Throws:: E4DBException

where_CREATED_isEmpty

public void where_CREATED_isEmpty()
                           throws E4DBException

Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column CREATED. DATE Date/Time mail created

Throws:: E4DBException

where_CREATED_isNotEmpty

public void where_CREATED_isNotEmpty()
                              throws E4DBException

Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column CREATED. DATE Date/Time mail created

Throws:: E4DBException

where_EMAIL_CC

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

Define a filter (AND-ed WHERE) for column EMAIL_CC. STRING(255) E-Mail Address (cc)

Parameters:: filter - the value to be compared within the SQL statement
Throws:: E4DBException

where_EMAIL_CC

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

Define a filter (AND-ed WHERE with operator) for column EMAIL_CC. STRING(255) E-Mail Address (cc)

Parameters:: filter - the value to be compared within the SQL statement; operator - the comparsion operator E4DBFilter
Throws:: E4DBException

where_EMAIL_CC_in

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

Define a IN-filter (AND-ed WHERE) for column EMAIL_CC. STRING(255) E-Mail Address (cc)

Throws:: E4DBException

where_EMAIL_CC_not_in

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

Define a NOT-IN-filter (AND-ed WHERE) for column EMAIL_CC. STRING(255) E-Mail Address (cc)

Throws:: E4DBException

where_EMAIL_CC_isNull

public void where_EMAIL_CC_isNull()
                           throws E4DBException

Define a is-null filter (AND-ed WHERE) for column EMAIL_CC. STRING(255) E-Mail Address (cc)

Throws:: E4DBException

where_EMAIL_CC_isNotNull

public void where_EMAIL_CC_isNotNull()
                              throws E4DBException

Define a is-NOT-null filter (AND-ed WHERE) for column EMAIL_CC. STRING(255) E-Mail Address (cc)

Throws:: E4DBException

where_EMAIL_CC_in

public void where_EMAIL_CC_in(E4DBSelectDistinct filter)
                       throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) EMAIL_CC. STRING(255) E-Mail Address (cc)

Parameters:: filter - the value to be compared within the SQL statement
Throws:: E4DBException

where_EMAIL_CC_notin

public void where_EMAIL_CC_notin(E4DBSelectDistinct filter)
                          throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) EMAIL_CC. STRING(255) E-Mail Address (cc)

Parameters:: filter - the value to be compared within the SQL statement
Throws:: E4DBException

where_EMAIL_CC_isEmpty

public void where_EMAIL_CC_isEmpty()
                            throws E4DBException

Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column EMAIL_CC. STRING(255) E-Mail Address (cc)

Throws:: E4DBException

where_EMAIL_CC_isNotEmpty

public void where_EMAIL_CC_isNotEmpty()
                               throws E4DBException

Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column EMAIL_CC. STRING(255) E-Mail Address (cc)

Throws:: E4DBException

where_EMAIL_FROM

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

Define a filter (AND-ed WHERE) for column EMAIL_FROM. STRING(255) E-Mail Address (sender)

Parameters:: filter - the value to be compared within the SQL statement
Throws:: E4DBException

where_EMAIL_FROM

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

Define a filter (AND-ed WHERE with operator) for column EMAIL_FROM. STRING(255) E-Mail Address (sender)

Parameters:: filter - the value to be compared within the SQL statement; operator - the comparsion operator E4DBFilter
Throws:: E4DBException

where_EMAIL_FROM_in

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

Define a IN-filter (AND-ed WHERE) for column EMAIL_FROM. STRING(255) E-Mail Address (sender)

Throws:: E4DBException

where_EMAIL_FROM_not_in

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

Define a NOT-IN-filter (AND-ed WHERE) for column EMAIL_FROM. STRING(255) E-Mail Address (sender)

Throws:: E4DBException

where_EMAIL_FROM_isNull

public void where_EMAIL_FROM_isNull()
                             throws E4DBException

Define a is-null filter (AND-ed WHERE) for column EMAIL_FROM. STRING(255) E-Mail Address (sender)

Throws:: E4DBException

where_EMAIL_FROM_isNotNull

public void where_EMAIL_FROM_isNotNull()
                                throws E4DBException

Define a is-NOT-null filter (AND-ed WHERE) for column EMAIL_FROM. STRING(255) E-Mail Address (sender)

Throws:: E4DBException

where_EMAIL_FROM_in

public void where_EMAIL_FROM_in(E4DBSelectDistinct filter)
                         throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) EMAIL_FROM. STRING(255) E-Mail Address (sender)

Parameters:: filter - the value to be compared within the SQL statement
Throws:: E4DBException

where_EMAIL_FROM_notin

public void where_EMAIL_FROM_notin(E4DBSelectDistinct filter)
                            throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) EMAIL_FROM. STRING(255) E-Mail Address (sender)

Parameters:: filter - the value to be compared within the SQL statement
Throws:: E4DBException

where_EMAIL_FROM_isEmpty

public void where_EMAIL_FROM_isEmpty()
                              throws E4DBException

Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column EMAIL_FROM. STRING(255) E-Mail Address (sender)

Throws:: E4DBException

where_EMAIL_FROM_isNotEmpty

public void where_EMAIL_FROM_isNotEmpty()
                                 throws E4DBException

Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column EMAIL_FROM. STRING(255) E-Mail Address (sender)

Throws:: E4DBException

where_EMAIL_TO

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

Define a filter (AND-ed WHERE) for column EMAIL_TO. STRING(255) E-Mail Address (recipient)

Parameters:: filter - the value to be compared within the SQL statement
Throws:: E4DBException

where_EMAIL_TO

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

Define a filter (AND-ed WHERE with operator) for column EMAIL_TO. STRING(255) E-Mail Address (recipient)

Parameters:: filter - the value to be compared within the SQL statement; operator - the comparsion operator E4DBFilter
Throws:: E4DBException

where_EMAIL_TO_in

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

Define a IN-filter (AND-ed WHERE) for column EMAIL_TO. STRING(255) E-Mail Address (recipient)

Throws:: E4DBException

where_EMAIL_TO_not_in

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

Define a NOT-IN-filter (AND-ed WHERE) for column EMAIL_TO. STRING(255) E-Mail Address (recipient)

Throws:: E4DBException

where_EMAIL_TO_isNull

public void where_EMAIL_TO_isNull()
                           throws E4DBException

Define a is-null filter (AND-ed WHERE) for column EMAIL_TO. STRING(255) E-Mail Address (recipient)

Throws:: E4DBException

where_EMAIL_TO_isNotNull

public void where_EMAIL_TO_isNotNull()
                              throws E4DBException

Define a is-NOT-null filter (AND-ed WHERE) for column EMAIL_TO. STRING(255) E-Mail Address (recipient)

Throws:: E4DBException

where_EMAIL_TO_in

public void where_EMAIL_TO_in(E4DBSelectDistinct filter)
                       throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) EMAIL_TO. STRING(255) E-Mail Address (recipient)

Parameters:: filter - the value to be compared within the SQL statement
Throws:: E4DBException

where_EMAIL_TO_notin

public void where_EMAIL_TO_notin(E4DBSelectDistinct filter)
                          throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) EMAIL_TO. STRING(255) E-Mail Address (recipient)

Parameters:: filter - the value to be compared within the SQL statement
Throws:: E4DBException

where_EMAIL_TO_isEmpty

public void where_EMAIL_TO_isEmpty()
                            throws E4DBException

Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column EMAIL_TO. STRING(255) E-Mail Address (recipient)

Throws:: E4DBException

where_EMAIL_TO_isNotEmpty

public void where_EMAIL_TO_isNotEmpty()
                               throws E4DBException

Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column EMAIL_TO. STRING(255) E-Mail Address (recipient)

Throws:: E4DBException

where_ERRMSG

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

Define a filter (AND-ed WHERE) for column ERRMSG. TEXT Error Message

Parameters:: filter - the value to be compared within the SQL statement
Throws:: E4DBException

where_ERRMSG

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

Define a filter (AND-ed WHERE with operator) for column ERRMSG. TEXT Error Message

Parameters:: filter - the value to be compared within the SQL statement; operator - the comparsion operator E4DBFilter
Throws:: E4DBException

where_HEADER

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

Define a filter (AND-ed WHERE) for column HEADER. STRING(255) Header

Parameters:: filter - the value to be compared within the SQL statement
Throws:: E4DBException

where_HEADER

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

Define a filter (AND-ed WHERE with operator) for column HEADER. STRING(255) Header

Parameters:: filter - the value to be compared within the SQL statement; operator - the comparsion operator E4DBFilter
Throws:: E4DBException

where_HEADER_in

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

Define a IN-filter (AND-ed WHERE) for column HEADER. STRING(255) Header

Throws:: E4DBException

where_HEADER_not_in

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

Define a NOT-IN-filter (AND-ed WHERE) for column HEADER. STRING(255) Header

Throws:: E4DBException

where_HEADER_isNull

public void where_HEADER_isNull()
                         throws E4DBException

Define a is-null filter (AND-ed WHERE) for column HEADER. STRING(255) Header

Throws:: E4DBException

where_HEADER_isNotNull

public void where_HEADER_isNotNull()
                            throws E4DBException

Define a is-NOT-null filter (AND-ed WHERE) for column HEADER. STRING(255) Header

Throws:: E4DBException

where_HEADER_in

public void where_HEADER_in(E4DBSelectDistinct filter)
                     throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) HEADER. STRING(255) Header

Parameters:: filter - the value to be compared within the SQL statement
Throws:: E4DBException

where_HEADER_notin

public void where_HEADER_notin(E4DBSelectDistinct filter)
                        throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) HEADER. STRING(255) Header

Parameters:: filter - the value to be compared within the SQL statement
Throws:: E4DBException

where_HEADER_isEmpty

public void where_HEADER_isEmpty()
                          throws E4DBException

Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column HEADER. STRING(255) Header

Throws:: E4DBException

where_HEADER_isNotEmpty

public void where_HEADER_isNotEmpty()
                             throws E4DBException

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

Throws:: E4DBException

where_ID

public void where_ID(long filter)
              throws E4DBException

Define a filter (AND-ed WHERE) for column ID. INTEGER ID Autoincremental value

Parameters:: filter - the value to be compared within the SQL statement
Throws:: E4DBException

where_ID

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

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

Parameters:: filter - the value to be compared within the SQL statement; operator - the comparsion operator E4DBFilter
Throws:: E4DBException

where_ID_in

public void where_ID_in(E4DBSelectDistinct filter)
                 throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) ID. INTEGER ID Autoincremental value

Parameters:: filter - the value to be compared within the SQL statement
Throws:: E4DBException

where_ID_notin

public void where_ID_notin(E4DBSelectDistinct filter)
                    throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) ID. INTEGER ID Autoincremental value

Parameters:: filter - the value to be compared within the SQL statement
Throws:: E4DBException

where_IS_HTML_FORMAT

public void where_IS_HTML_FORMAT(boolean filter)
                          throws E4DBException

Define a filter (AND-ed WHERE) for column IS_HTML_FORMAT. BOOLEAN true if HTML, false if Text

Parameters:: filter - the value to be compared within the SQL statement
Throws:: E4DBException

where_IS_HTML_FORMAT

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

Define a filter (AND-ed WHERE with operator) for column IS_HTML_FORMAT. BOOLEAN true if HTML, false if Text

Parameters:: filter - the value to be compared within the SQL statement; operator - the comparsion operator E4DBFilter
Throws:: E4DBException

where_SENT

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

Define a filter (AND-ed WHERE) for column SENT. DATE Date and Time mail sent

Parameters:: filter - the value to be compared within the SQL statement
Throws:: E4DBException

where_SENT

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

Define a filter (AND-ed WHERE with operator) for column SENT. DATE Date and Time mail sent

Parameters:: filter - the value to be compared within the SQL statement; operator - the comparsion operator E4DBFilter
Throws:: E4DBException

where_SENT_isNull

public void where_SENT_isNull()
                       throws E4DBException

Define a is-null filter (AND-ed WHERE) for column SENT. DATE Date and Time mail sent

Throws:: E4DBException

where_SENT_isNotNull

public void where_SENT_isNotNull()
                          throws E4DBException

Define a is-NOT-null filter (AND-ed WHERE) for column SENT. DATE Date and Time mail sent

Throws:: E4DBException

where_SENT_in

public void where_SENT_in(E4DBSelectDistinct filter)
                   throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) SENT. DATE Date and Time mail sent

Parameters:: filter - the value to be compared within the SQL statement
Throws:: E4DBException

where_SENT_notin

public void where_SENT_notin(E4DBSelectDistinct filter)
                      throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) SENT. DATE Date and Time mail sent

Parameters:: filter - the value to be compared within the SQL statement
Throws:: E4DBException

where_SENT_isEmpty

public void where_SENT_isEmpty()
                        throws E4DBException

Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column SENT. DATE Date and Time mail sent

Throws:: E4DBException

where_SENT_isNotEmpty

public void where_SENT_isNotEmpty()
                           throws E4DBException

Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column SENT. DATE Date and Time mail sent

Throws:: E4DBException

where_TXT

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

Define a filter (AND-ed WHERE) for column TXT. TEXT Text

Parameters:: filter - the value to be compared within the SQL statement
Throws:: E4DBException

where_TXT

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

Define a filter (AND-ed WHERE with operator) for column TXT. TEXT Text

Parameters:: filter - the value to be compared within the SQL statement; operator - the comparsion operator E4DBFilter
Throws:: E4DBException

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

find_AINCR

public static T_E4S_MAIL_SENT_Obj find_AINCR(E4ApplObj_Intf appobj,
                                             long qID)
                                      throws E4DBException

Find a record associates with unique index 5 (AINCR).

Parameters:: appobj - the current application object containing client informations; qID - query ID
Throws:: E4DBException

find_AINCR

public static T_E4S_MAIL_SENT_Obj find_AINCR(E4DBConnection_Intf con,
                                             E4ApplObj_Intf appobj,
                                             long qID)
                                      throws E4DBException

Find a record associates with index 5 (AINCR).

Parameters:: con - the database connection; appobj - the current application object containing client informations; qID - query ID
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_MAIL_SENT_Sel

TABLENAME

SVN_REVISION

IS_CLIENT_DISTINCTIVE

IS_FREEDEF_POSSIBLE

COL_CREATED

CI_CREATED

COL_EMAIL_CC

CI_EMAIL_CC

COL_EMAIL_FROM

CI_EMAIL_FROM

COL_EMAIL_TO

CI_EMAIL_TO

COL_ERRMSG

CI_ERRMSG

COL_HEADER

CI_HEADER

COL_ID

CI_ID

COL_IS_HTML_FORMAT

CI_IS_HTML_FORMAT

COL_SENT

CI_SENT

COL_TXT

CI_TXT

COLUMNS

IDX1

IDX2

IDX_AINCR

INDEXES

T_E4S_MAIL_SENT_Sel

T_E4S_MAIL_SENT_Sel

T_E4S_MAIL_SENT_Sel

or

makeInstance

E4ID

hasClientDistinctive

canHaveFreeDefinedFields

getModifyClass

makeInstance_Modify

getObjectClass

getColInfo

getIdxInfo

getFirstPrimaryIndex

next

get_CLIENT

get_CREATED

get_EMAIL_CC

get_EMAIL_FROM

get_EMAIL_TO

get_ERRMSG

get_HEADER

get_ID

get_IS_HTML_FORMAT

get_SENT

get_TXT

get

getQuery

sort_CREATED

sort_CREATED_descending

sort_EMAIL_CC

sort_EMAIL_CC_descending

sort_EMAIL_FROM

sort_EMAIL_FROM_descending

sort_EMAIL_TO

sort_EMAIL_TO_descending

sort_HEADER

sort_HEADER_descending

sort_ID

sort_ID_descending

sort_IS_HTML_FORMAT

sort_IS_HTML_FORMAT_descending

sort_SENT

sort_SENT_descending

where_CREATED

where_CREATED

where_CREATED_isNull

where_CREATED_isNotNull

where_CREATED_in

where_CREATED_notin

e4s.db.systabledef
Class T_E4S_MAIL_SENT_Sel