e4s.db.systabledef
Class T_E4S_FREEFIELD_VAL_Sel.T_E4S_FREEFIELD_VAL_Or

java.lang.Object
  e4s.util.E4Object
      e4s.db.E4DBFilter
          e4s.db.E4DBFilterOr
              e4s.db.systabledef.T_E4S_FREEFIELD_VAL_Sel.T_E4S_FREEFIELD_VAL_Or

All Implemented Interfaces:

E4DBFilter_Intf, E4DBFilterOr_Intf

Enclosing class:

T_E4S_FREEFIELD_VAL_Sel

public static class T_E4S_FREEFIELD_VAL_Sel.T_E4S_FREEFIELD_VAL_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_FREEFIELD_VAL_Sel.T_E4S_FREEFIELD_VAL_Or()

Method Summary

T_E4S_FREEFIELD_VAL_Sel.T_E4S_FREEFIELD_VAL_And	and()
void	where_DATMOD_in(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_DATMOD_isEmpty() Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column DATMOD.
void	where_DATMOD_isNotEmpty() Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column DATMOD.
void	where_DATMOD_isNotNull() Define a is-NOT-null filter (AND-ed WHERE) for column DATMOD.
void	where_DATMOD_isNull() Define a is-null filter (AND-ed WHERE) for column DATMOD.
void	where_DATMOD_notin(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_DATMOD(java.util.Date filter) Define a filter (AND-ed WHERE) for column DATMOD.
void	where_DATMOD(int operator, java.util.Date filter) Define a filter (AND-ed WHERE with operator) for column DATMOD.
void	where_DATNEW_in(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_DATNEW_isEmpty() Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column DATNEW.
void	where_DATNEW_isNotEmpty() Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column DATNEW.
void	where_DATNEW_isNotNull() Define a is-NOT-null filter (AND-ed WHERE) for column DATNEW.
void	where_DATNEW_isNull() Define a is-null filter (AND-ed WHERE) for column DATNEW.
void	where_DATNEW_notin(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_DATNEW(java.util.Date filter) Define a filter (AND-ed WHERE) for column DATNEW.
void	where_DATNEW(int operator, java.util.Date filter) Define a filter (AND-ed WHERE with operator) for column DATNEW.
void	where_DB_TABLE_in(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_DB_TABLE_isEmpty() Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column DB_TABLE.
void	where_DB_TABLE_isNotEmpty() Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column DB_TABLE.
void	where_DB_TABLE_isNotNull() Define a is-NOT-null filter (AND-ed WHERE) for column DB_TABLE.
void	where_DB_TABLE_isNull() Define a is-null filter (AND-ed WHERE) for column DB_TABLE.
void	where_DB_TABLE_notin(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_DB_TABLE(int operator, java.lang.String filter) Define a filter (AND-ed WHERE with operator) for column DB_TABLE.
void	where_DB_TABLE(java.lang.String filter) Define a filter (AND-ed WHERE) for column DB_TABLE.
void	where_FREEFIELD_NAME_in(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_FREEFIELD_NAME_isEmpty() Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column FREEFIELD_NAME.
void	where_FREEFIELD_NAME_isNotEmpty() Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column FREEFIELD_NAME.
void	where_FREEFIELD_NAME_isNotNull() Define a is-NOT-null filter (AND-ed WHERE) for column FREEFIELD_NAME.
void	where_FREEFIELD_NAME_isNull() Define a is-null filter (AND-ed WHERE) for column FREEFIELD_NAME.
void	where_FREEFIELD_NAME_notin(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_FREEFIELD_NAME(int operator, java.lang.String filter) Define a filter (AND-ed WHERE with operator) for column FREEFIELD_NAME.
void	where_FREEFIELD_NAME(java.lang.String filter) Define a filter (AND-ed WHERE) for column FREEFIELD_NAME.
void	where_IDX1_in(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_IDX1_isEmpty() Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column IDX1.
void	where_IDX1_isNotEmpty() Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column IDX1.
void	where_IDX1_isNotNull() Define a is-NOT-null filter (AND-ed WHERE) for column IDX1.
void	where_IDX1_isNull() Define a is-null filter (AND-ed WHERE) for column IDX1.
void	where_IDX1_notin(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_IDX1(int operator, java.lang.String filter) Define a filter (AND-ed WHERE with operator) for column IDX1.
void	where_IDX1(java.lang.String filter) Define a filter (AND-ed WHERE) for column IDX1.
void	where_IDX2_in(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_IDX2_isEmpty() Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column IDX2.
void	where_IDX2_isNotEmpty() Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column IDX2.
void	where_IDX2_isNotNull() Define a is-NOT-null filter (AND-ed WHERE) for column IDX2.
void	where_IDX2_isNull() Define a is-null filter (AND-ed WHERE) for column IDX2.
void	where_IDX2_notin(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_IDX2(int operator, java.lang.String filter) Define a filter (AND-ed WHERE with operator) for column IDX2.
void	where_IDX2(java.lang.String filter) Define a filter (AND-ed WHERE) for column IDX2.
void	where_IDX3_in(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_IDX3_isEmpty() Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column IDX3.
void	where_IDX3_isNotEmpty() Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column IDX3.
void	where_IDX3_isNotNull() Define a is-NOT-null filter (AND-ed WHERE) for column IDX3.
void	where_IDX3_isNull() Define a is-null filter (AND-ed WHERE) for column IDX3.
void	where_IDX3_notin(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_IDX3(int operator, java.lang.String filter) Define a filter (AND-ed WHERE with operator) for column IDX3.
void	where_IDX3(java.lang.String filter) Define a filter (AND-ed WHERE) for column IDX3.
void	where_VAL_in(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_VAL_isEmpty() Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column VAL.
void	where_VAL_isNotEmpty() Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column VAL.
void	where_VAL_isNotNull() Define a is-NOT-null filter (AND-ed WHERE) for column VAL.
void	where_VAL_isNull() Define a is-null filter (AND-ed WHERE) for column VAL.
void	where_VAL_notin(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_VAL(int operator, java.lang.String filter) Define a filter (AND-ed WHERE with operator) for column VAL.
void	where_VAL(java.lang.String filter) Define a filter (AND-ed WHERE) for column VAL.

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_FREEFIELD_VAL_Sel.T_E4S_FREEFIELD_VAL_Or

public T_E4S_FREEFIELD_VAL_Sel.T_E4S_FREEFIELD_VAL_Or()

Method Detail

where_DATMOD

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

Define a filter (AND-ed WHERE) for column DATMOD. DATE Date modified

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_DATMOD

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

Define a filter (AND-ed WHERE with operator) for column DATMOD. DATE Date modified

Parameters:

filter - the value to be compared within the SQL statement

operator - the comparsion operator E4DBFilter

Throws:

E4DBException

where_DATMOD_isNull

public void where_DATMOD_isNull()
                         throws E4DBException

Define a is-null filter (AND-ed WHERE) for column DATMOD. DATE Date modified

Throws:

E4DBException

where_DATMOD_isNotNull

public void where_DATMOD_isNotNull()
                            throws E4DBException

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

Throws:

E4DBException

where_DATMOD_in

public void where_DATMOD_in(E4DBSelectDistinct filter)
                     throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) DATMOD. DATE Date modified

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_DATMOD_notin

public void where_DATMOD_notin(E4DBSelectDistinct filter)
                        throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) DATMOD. DATE Date modified

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_DATMOD_isEmpty

public void where_DATMOD_isEmpty()
                          throws E4DBException

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

Throws:

E4DBException

where_DATMOD_isNotEmpty

public void where_DATMOD_isNotEmpty()
                             throws E4DBException

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

Throws:

E4DBException

where_DATNEW

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

Define a filter (AND-ed WHERE) for column DATNEW. DATE Date created

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_DATNEW

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

Define a filter (AND-ed WHERE with operator) for column DATNEW. DATE Date created

Parameters:

filter - the value to be compared within the SQL statement

operator - the comparsion operator E4DBFilter

Throws:

E4DBException

where_DATNEW_isNull

public void where_DATNEW_isNull()
                         throws E4DBException

Define a is-null filter (AND-ed WHERE) for column DATNEW. DATE Date created

Throws:

E4DBException

where_DATNEW_isNotNull

public void where_DATNEW_isNotNull()
                            throws E4DBException

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

Throws:

E4DBException

where_DATNEW_in

public void where_DATNEW_in(E4DBSelectDistinct filter)
                     throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) DATNEW. DATE Date created

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_DATNEW_notin

public void where_DATNEW_notin(E4DBSelectDistinct filter)
                        throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) DATNEW. DATE Date created

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_DATNEW_isEmpty

public void where_DATNEW_isEmpty()
                          throws E4DBException

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

Throws:

E4DBException

where_DATNEW_isNotEmpty

public void where_DATNEW_isNotEmpty()
                             throws E4DBException

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

Throws:

E4DBException

where_DB_TABLE

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

Define a filter (AND-ed WHERE) for column DB_TABLE. STRING(32) Associated table

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_DB_TABLE

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

Define a filter (AND-ed WHERE with operator) for column DB_TABLE. STRING(32) Associated table

Parameters:

filter - the value to be compared within the SQL statement

operator - the comparsion operator E4DBFilter

Throws:

E4DBException

where_DB_TABLE_isNull

public void where_DB_TABLE_isNull()
                           throws E4DBException

Define a is-null filter (AND-ed WHERE) for column DB_TABLE. STRING(32) Associated table

Throws:

E4DBException

where_DB_TABLE_isNotNull

public void where_DB_TABLE_isNotNull()
                              throws E4DBException

Define a is-NOT-null filter (AND-ed WHERE) for column DB_TABLE. STRING(32) Associated table

Throws:

E4DBException

where_DB_TABLE_in

public void where_DB_TABLE_in(E4DBSelectDistinct filter)
                       throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) DB_TABLE. STRING(32) Associated table

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_DB_TABLE_notin

public void where_DB_TABLE_notin(E4DBSelectDistinct filter)
                          throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) DB_TABLE. STRING(32) Associated table

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_DB_TABLE_isEmpty

public void where_DB_TABLE_isEmpty()
                            throws E4DBException

Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column DB_TABLE. STRING(32) Associated table

Throws:

E4DBException

where_DB_TABLE_isNotEmpty

public void where_DB_TABLE_isNotEmpty()
                               throws E4DBException

Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column DB_TABLE. STRING(32) Associated table

Throws:

E4DBException

where_FREEFIELD_NAME

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

Define a filter (AND-ed WHERE) for column FREEFIELD_NAME. STRING(32) Name of the free-field

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_FREEFIELD_NAME

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

Define a filter (AND-ed WHERE with operator) for column FREEFIELD_NAME. STRING(32) Name of the free-field

Parameters:

filter - the value to be compared within the SQL statement

operator - the comparsion operator E4DBFilter

Throws:

E4DBException

where_FREEFIELD_NAME_isNull

public void where_FREEFIELD_NAME_isNull()
                                 throws E4DBException

Define a is-null filter (AND-ed WHERE) for column FREEFIELD_NAME. STRING(32) Name of the free-field

Throws:

E4DBException

where_FREEFIELD_NAME_isNotNull

public void where_FREEFIELD_NAME_isNotNull()
                                    throws E4DBException

Define a is-NOT-null filter (AND-ed WHERE) for column FREEFIELD_NAME. STRING(32) Name of the free-field

Throws:

E4DBException

where_FREEFIELD_NAME_in

public void where_FREEFIELD_NAME_in(E4DBSelectDistinct filter)
                             throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) FREEFIELD_NAME. STRING(32) Name of the free-field

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_FREEFIELD_NAME_notin

public void where_FREEFIELD_NAME_notin(E4DBSelectDistinct filter)
                                throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) FREEFIELD_NAME. STRING(32) Name of the free-field

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_FREEFIELD_NAME_isEmpty

public void where_FREEFIELD_NAME_isEmpty()
                                  throws E4DBException

Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column FREEFIELD_NAME. STRING(32) Name of the free-field

Throws:

E4DBException

where_FREEFIELD_NAME_isNotEmpty

public void where_FREEFIELD_NAME_isNotEmpty()
                                     throws E4DBException

Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column FREEFIELD_NAME. STRING(32) Name of the free-field

Throws:

E4DBException

where_IDX1

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

Define a filter (AND-ed WHERE) for column IDX1. STRING(64) Index #1

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_IDX1

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

Define a filter (AND-ed WHERE with operator) for column IDX1. STRING(64) Index #1

Parameters:

filter - the value to be compared within the SQL statement

operator - the comparsion operator E4DBFilter

Throws:

E4DBException

where_IDX1_isNull

public void where_IDX1_isNull()
                       throws E4DBException

Define a is-null filter (AND-ed WHERE) for column IDX1. STRING(64) Index #1

Throws:

E4DBException

where_IDX1_isNotNull

public void where_IDX1_isNotNull()
                          throws E4DBException

Define a is-NOT-null filter (AND-ed WHERE) for column IDX1. STRING(64) Index #1

Throws:

E4DBException

where_IDX1_in

public void where_IDX1_in(E4DBSelectDistinct filter)
                   throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) IDX1. STRING(64) Index #1

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_IDX1_notin

public void where_IDX1_notin(E4DBSelectDistinct filter)
                      throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) IDX1. STRING(64) Index #1

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_IDX1_isEmpty

public void where_IDX1_isEmpty()
                        throws E4DBException

Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column IDX1. STRING(64) Index #1

Throws:

E4DBException

where_IDX1_isNotEmpty

public void where_IDX1_isNotEmpty()
                           throws E4DBException

Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column IDX1. STRING(64) Index #1

Throws:

E4DBException

where_IDX2

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

Define a filter (AND-ed WHERE) for column IDX2. STRING(64) Index #2

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_IDX2

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

Define a filter (AND-ed WHERE with operator) for column IDX2. STRING(64) Index #2

Parameters:

filter - the value to be compared within the SQL statement

operator - the comparsion operator E4DBFilter

Throws:

E4DBException

where_IDX2_isNull

public void where_IDX2_isNull()
                       throws E4DBException

Define a is-null filter (AND-ed WHERE) for column IDX2. STRING(64) Index #2

Throws:

E4DBException

where_IDX2_isNotNull

public void where_IDX2_isNotNull()
                          throws E4DBException

Define a is-NOT-null filter (AND-ed WHERE) for column IDX2. STRING(64) Index #2

Throws:

E4DBException

where_IDX2_in

public void where_IDX2_in(E4DBSelectDistinct filter)
                   throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) IDX2. STRING(64) Index #2

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_IDX2_notin

public void where_IDX2_notin(E4DBSelectDistinct filter)
                      throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) IDX2. STRING(64) Index #2

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_IDX2_isEmpty

public void where_IDX2_isEmpty()
                        throws E4DBException

Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column IDX2. STRING(64) Index #2

Throws:

E4DBException

where_IDX2_isNotEmpty

public void where_IDX2_isNotEmpty()
                           throws E4DBException

Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column IDX2. STRING(64) Index #2

Throws:

E4DBException

where_IDX3

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

Define a filter (AND-ed WHERE) for column IDX3. STRING(64) Index #3

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_IDX3

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

Define a filter (AND-ed WHERE with operator) for column IDX3. STRING(64) Index #3

Parameters:

filter - the value to be compared within the SQL statement

operator - the comparsion operator E4DBFilter

Throws:

E4DBException

where_IDX3_isNull

public void where_IDX3_isNull()
                       throws E4DBException

Define a is-null filter (AND-ed WHERE) for column IDX3. STRING(64) Index #3

Throws:

E4DBException

where_IDX3_isNotNull

public void where_IDX3_isNotNull()
                          throws E4DBException

Define a is-NOT-null filter (AND-ed WHERE) for column IDX3. STRING(64) Index #3

Throws:

E4DBException

where_IDX3_in

public void where_IDX3_in(E4DBSelectDistinct filter)
                   throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) IDX3. STRING(64) Index #3

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_IDX3_notin

public void where_IDX3_notin(E4DBSelectDistinct filter)
                      throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) IDX3. STRING(64) Index #3

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_IDX3_isEmpty

public void where_IDX3_isEmpty()
                        throws E4DBException

Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column IDX3. STRING(64) Index #3

Throws:

E4DBException

where_IDX3_isNotEmpty

public void where_IDX3_isNotEmpty()
                           throws E4DBException

Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column IDX3. STRING(64) Index #3

Throws:

E4DBException

where_VAL

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

Define a filter (AND-ed WHERE) for column VAL. STRING(255) Value

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_VAL

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

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

Parameters:

filter - the value to be compared within the SQL statement

operator - the comparsion operator E4DBFilter

Throws:

E4DBException

where_VAL_isNull

public void where_VAL_isNull()
                      throws E4DBException

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

Throws:

E4DBException

where_VAL_isNotNull

public void where_VAL_isNotNull()
                         throws E4DBException

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

Throws:

E4DBException

where_VAL_in

public void where_VAL_in(E4DBSelectDistinct filter)
                  throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) VAL. STRING(255) Value

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_VAL_notin

public void where_VAL_notin(E4DBSelectDistinct filter)
                     throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) VAL. STRING(255) Value

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_VAL_isEmpty

public void where_VAL_isEmpty()
                       throws E4DBException

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

Throws:

E4DBException

where_VAL_isNotEmpty

public void where_VAL_isNotEmpty()
                          throws E4DBException

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

Throws:

E4DBException

and

public T_E4S_FREEFIELD_VAL_Sel.T_E4S_FREEFIELD_VAL_And and()