e4s.db.systabledef
Class T_E4S_MAIL_SENT_Sel.T_E4S_MAIL_SENT_Or

java.lang.Object
  e4s.util.E4Object
      e4s.db.E4DBFilter
          e4s.db.E4DBFilterOr
              e4s.db.systabledef.T_E4S_MAIL_SENT_Sel.T_E4S_MAIL_SENT_Or

All Implemented Interfaces:

E4DBFilter_Intf, E4DBFilterOr_Intf

Enclosing class:

T_E4S_MAIL_SENT_Sel

public static class T_E4S_MAIL_SENT_Sel.T_E4S_MAIL_SENT_Or
extends E4DBFilterOr
implements E4DBFilter_Intf

Filter to be used as OR condition.

Field Summary

Fields inherited from class e4s.db.E4DBFilter

COMP_EMPTY, COMP_EQUALS, COMP_GREATER, COMP_GREATER_EQUAL, COMP_IN, COMP_IS_NOT_NULL, COMP_IS_NULL, COMP_LESS, COMP_LESS_EQUAL, COMP_LIKE, COMP_NOT_EMPTY, COMP_NOT_EQUALS, COMP_NOT_IN, COMP_NOT_LIKE

Fields inherited from class e4s.util.E4Object

CRLF, E4S_CORE_SYSTEM_LANGUAGE, NBSP, NULLSTR, URL_ENCODING_CHARSET

Constructor Summary

T_E4S_MAIL_SENT_Sel.T_E4S_MAIL_SENT_Or()

Method Summary

T_E4S_MAIL_SENT_Sel.T_E4S_MAIL_SENT_And	and()
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_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_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_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_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_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_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_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_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.E4DBFilterOr

_getSVNVersionString, AND, getWhere, isEmpty, isNotEmpty, isNotNull, isNull, setFilter_NOT, setFilter_NOT, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, toString

Methods inherited from class e4s.db.E4DBFilter

Escape, Escape, finalize, getApplObj, getClient, getSession, getWhere, isWhereDefined, OP, resetWhere, setFilter_IN, setFilter_IN, setFilter_IN, setFilter_IN, setFilter_IN, setFilter_NOT_IN, setFilter_NOT_IN, setFilter_NOT_IN, setFilter_NOT_IN, setFilter_NOT_IN, setFilter, setFilter, setWhere, toString

Methods inherited from class e4s.util.E4Object

Calendar, CName, CName, E4LabelApp, E4LabelApp, E4LabelApp, E4LabelApp, E4LabelApp, E4LabelApp, E4LabelNone, E4LabelNone, E4LabelNone, E4LabelNone, E4LabelSys, E4LabelSys, e4sCopyright, e4sVersion, encode, encode, encode, encodeHtml, encodeHtml, encodeHtml, encodeURL, encodeURL, encodeURL, getLINE, getTRACE, getTRACE, getTRACE, getTRACE, getTRACE, getTRACE, getTraceMemory, HtmlEncode, HtmlEncode, HtmlEncode, isdecimal, isdigit, isnotok, isnotok, isnumeric, isok, isok, isok, isok, lastCallingFunction, lastCallingFunction, lastCallingFunction, lastCallingFunction, lastCallingStack, mkdirs, null2nbsp, null2nbsp, null2nbsp, ok, ok, ok, ok, outPrintln, setLogFile4Trace, setTraceMemory, STACKTRACE, toDebug, toDouble, toFloat, toFloat, TRACE_CALLS, TRACE, TRACE, TRACE, TRACE, TRACE, TRACE, TRACE, TRACE, TRACE, TRACE, TRACE, TRACE, wait

Methods inherited from class java.lang.Object

clone, equals, getClass, hashCode, notify, notifyAll, wait, wait, wait

Methods inherited from interface e4s.db.E4DBFilter_Intf

getWhere, isWhereDefined, resetWhere

Constructor Detail

T_E4S_MAIL_SENT_Sel.T_E4S_MAIL_SENT_Or

public T_E4S_MAIL_SENT_Sel.T_E4S_MAIL_SENT_Or()

Method Detail

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_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_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_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_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

and

public T_E4S_MAIL_SENT_Sel.T_E4S_MAIL_SENT_And and()