T_E4S_FREEFIELD_DEF_Sel.T_E4S_FREEFIELD_DEF

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_FREEFIELD_DEF_Sel.T_E4S_FREEFIELD_DEF_Or

java.lang.Object
  e4s.util.E4Object
      e4s.db.E4DBFilter
          e4s.db.E4DBFilterOr
              e4s.db.systabledef.T_E4S_FREEFIELD_DEF_Sel.T_E4S_FREEFIELD_DEF_Or

All Implemented Interfaces:: E4DBFilter_Intf, E4DBFilterOr_Intf

Enclosing class:: T_E4S_FREEFIELD_DEF_Sel

public static class T_E4S_FREEFIELD_DEF_Sel.T_E4S_FREEFIELD_DEF_Or
extends E4DBFilterOr
implements E4DBFilter_Intf
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_DEF_Sel.T_E4S_FREEFIELD_DEF_Or()`

Method Summary
`T_E4S_FREEFIELD_DEF_Sel.T_E4S_FREEFIELD_DEF_And`	`and()`
`void`	`where_COLLABEL_in(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_COLLABEL_isEmpty()` Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column COLLABEL.
`void`	`where_COLLABEL_isNotEmpty()` Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column COLLABEL.
`void`	`where_COLLABEL_isNotNull()` Define a is-NOT-null filter (AND-ed WHERE) for column COLLABEL.
`void`	`where_COLLABEL_isNull()` Define a is-null filter (AND-ed WHERE) for column COLLABEL.
`void`	`where_COLLABEL_notin(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_COLLABEL(int operator, java.lang.String filter)` Define a filter (AND-ed WHERE with operator) for column COLLABEL.
`void`	`where_COLLABEL(java.lang.String filter)` Define a filter (AND-ed WHERE) for column COLLABEL.
`void`	`where_DATALEN_in(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_DATALEN_notin(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_DATALEN(int operator, long filter)` Define a filter (AND-ed WHERE with operator) for column DATALEN.
`void`	`where_DATALEN(long filter)` Define a filter (AND-ed WHERE) for column DATALEN.
`void`	`where_DATATYPE_in(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_DATATYPE_isEmpty()` Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column DATATYPE.
`void`	`where_DATATYPE_isNotEmpty()` Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column DATATYPE.
`void`	`where_DATATYPE_isNotNull()` Define a is-NOT-null filter (AND-ed WHERE) for column DATATYPE.
`void`	`where_DATATYPE_isNull()` Define a is-null filter (AND-ed WHERE) for column DATATYPE.
`void`	`where_DATATYPE_notin(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_DATATYPE(int operator, java.lang.String filter)` Define a filter (AND-ed WHERE with operator) for column DATATYPE.
`void`	`where_DATATYPE(java.lang.String filter)` Define a filter (AND-ed WHERE) for column DATATYPE.
`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_DISPLAY_MODE_in(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_DISPLAY_MODE_isEmpty()` Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column DISPLAY_MODE.
`void`	`where_DISPLAY_MODE_isNotEmpty()` Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column DISPLAY_MODE.
`void`	`where_DISPLAY_MODE_isNotNull()` Define a is-NOT-null filter (AND-ed WHERE) for column DISPLAY_MODE.
`void`	`where_DISPLAY_MODE_isNull()` Define a is-null filter (AND-ed WHERE) for column DISPLAY_MODE.
`void`	`where_DISPLAY_MODE_like(java.lang.String filter)` Define a filter (AND-ed WHERE) for column DISPLAY_MODE.
`void`	`where_DISPLAY_MODE_notin(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_DISPLAY_MODE(E4FreeFieldDisplayMode filter)` Define a filter (AND-ed WHERE) for column DISPLAY_MODE.
`void`	`where_DISPLAY_MODE(int operator, E4FreeFieldDisplayMode filter)` Define a filter (AND-ed WHERE with operator) for column DISPLAY_MODE.
`void`	`where_ENABLE_SEARCH(boolean filter)` Define a filter (AND-ed WHERE) for column ENABLE_SEARCH.
`void`	`where_ENABLE_SEARCH(int operator, boolean filter)` Define a filter (AND-ed WHERE with operator) for column ENABLE_SEARCH.
`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_INITVAL_in(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_INITVAL_isEmpty()` Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column INITVAL.
`void`	`where_INITVAL_isNotEmpty()` Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column INITVAL.
`void`	`where_INITVAL_isNotNull()` Define a is-NOT-null filter (AND-ed WHERE) for column INITVAL.
`void`	`where_INITVAL_isNull()` Define a is-null filter (AND-ed WHERE) for column INITVAL.
`void`	`where_INITVAL_notin(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_INITVAL(int operator, java.lang.String filter)` Define a filter (AND-ed WHERE with operator) for column INITVAL.
`void`	`where_INITVAL(java.lang.String filter)` Define a filter (AND-ed WHERE) for column INITVAL.
`void`	`where_LABEL_in(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_LABEL_isEmpty()` Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column LABEL.
`void`	`where_LABEL_isNotEmpty()` Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column LABEL.
`void`	`where_LABEL_isNotNull()` Define a is-NOT-null filter (AND-ed WHERE) for column LABEL.
`void`	`where_LABEL_isNull()` Define a is-null filter (AND-ed WHERE) for column LABEL.
`void`	`where_LABEL_notin(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_LABEL(int operator, java.lang.String filter)` Define a filter (AND-ed WHERE with operator) for column LABEL.
`void`	`where_LABEL(java.lang.String filter)` Define a filter (AND-ed WHERE) for column LABEL.
`void`	`where_MANDATORY(boolean filter)` Define a filter (AND-ed WHERE) for column MANDATORY.
`void`	`where_MANDATORY(int operator, boolean filter)` Define a filter (AND-ed WHERE with operator) for column MANDATORY.
`void`	`where_POSTLABEL_in(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_POSTLABEL_isEmpty()` Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column POSTLABEL.
`void`	`where_POSTLABEL_isNotEmpty()` Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column POSTLABEL.
`void`	`where_POSTLABEL_isNotNull()` Define a is-NOT-null filter (AND-ed WHERE) for column POSTLABEL.
`void`	`where_POSTLABEL_isNull()` Define a is-null filter (AND-ed WHERE) for column POSTLABEL.
`void`	`where_POSTLABEL_notin(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_POSTLABEL(int operator, java.lang.String filter)` Define a filter (AND-ed WHERE with operator) for column POSTLABEL.
`void`	`where_POSTLABEL(java.lang.String filter)` Define a filter (AND-ed WHERE) for column POSTLABEL.
`void`	`where_REM_in(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_REM_isEmpty()` Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column REM.
`void`	`where_REM_isNotEmpty()` Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column REM.
`void`	`where_REM_isNotNull()` Define a is-NOT-null filter (AND-ed WHERE) for column REM.
`void`	`where_REM_isNull()` Define a is-null filter (AND-ed WHERE) for column REM.
`void`	`where_REM_notin(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_REM(int operator, java.lang.String filter)` Define a filter (AND-ed WHERE with operator) for column REM.
`void`	`where_REM(java.lang.String filter)` Define a filter (AND-ed WHERE) for column REM.
`void`	`where_SEL_VALUES(int operator, java.lang.String filter)` Define a filter (AND-ed WHERE with operator) for column SEL_VALUES.
`void`	`where_SEL_VALUES(java.lang.String filter)` Define a filter (AND-ed WHERE) for column SEL_VALUES.
`void`	`where_SORT_in(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_SORT_notin(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_SORT(int operator, long filter)` Define a filter (AND-ed WHERE with operator) for column SORT.
`void`	`where_SORT(long filter)` Define a filter (AND-ed WHERE) for column SORT.

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 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_DEF_Sel.T_E4S_FREEFIELD_DEF_Or

public T_E4S_FREEFIELD_DEF_Sel.T_E4S_FREEFIELD_DEF_Or()

Method Detail

where_COLLABEL

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

Define a filter (AND-ed WHERE) for column COLLABEL. STRING(8) Column�s Label

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

where_COLLABEL

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

Define a filter (AND-ed WHERE with operator) for column COLLABEL. STRING(8) Column�s Label

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

where_COLLABEL_isNull

public void where_COLLABEL_isNull()
                           throws E4DBException

Define a is-null filter (AND-ed WHERE) for column COLLABEL. STRING(8) Column�s Label

Throws:: E4DBException

where_COLLABEL_isNotNull

public void where_COLLABEL_isNotNull()
                              throws E4DBException

Define a is-NOT-null filter (AND-ed WHERE) for column COLLABEL. STRING(8) Column�s Label

Throws:: E4DBException

where_COLLABEL_in

public void where_COLLABEL_in(E4DBSelectDistinct filter)
                       throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) COLLABEL. STRING(8) Column�s Label

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

where_COLLABEL_notin

public void where_COLLABEL_notin(E4DBSelectDistinct filter)
                          throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) COLLABEL. STRING(8) Column�s Label

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

where_COLLABEL_isEmpty

public void where_COLLABEL_isEmpty()
                            throws E4DBException

Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column COLLABEL. STRING(8) Column�s Label

Throws:: E4DBException

where_COLLABEL_isNotEmpty

public void where_COLLABEL_isNotEmpty()
                               throws E4DBException

Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column COLLABEL. STRING(8) Column�s Label

Throws:: E4DBException

where_DATALEN

public void where_DATALEN(long filter)
                   throws E4DBException

Define a filter (AND-ed WHERE) for column DATALEN. INTEGER Length of data (in case of string fields)

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

where_DATALEN

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

Define a filter (AND-ed WHERE with operator) for column DATALEN. INTEGER Length of data (in case of string fields)

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

where_DATALEN_in

public void where_DATALEN_in(E4DBSelectDistinct filter)
                      throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) DATALEN. INTEGER Length of data (in case of string fields)

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

where_DATALEN_notin

public void where_DATALEN_notin(E4DBSelectDistinct filter)
                         throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) DATALEN. INTEGER Length of data (in case of string fields)

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

where_DATATYPE

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

Define a filter (AND-ed WHERE) for column DATATYPE. STRING(32) Datatype

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

where_DATATYPE

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

Define a filter (AND-ed WHERE with operator) for column DATATYPE. STRING(32) Datatype

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

where_DATATYPE_isNull

public void where_DATATYPE_isNull()
                           throws E4DBException

Define a is-null filter (AND-ed WHERE) for column DATATYPE. STRING(32) Datatype

Throws:: E4DBException

where_DATATYPE_isNotNull

public void where_DATATYPE_isNotNull()
                              throws E4DBException

Define a is-NOT-null filter (AND-ed WHERE) for column DATATYPE. STRING(32) Datatype

Throws:: E4DBException

where_DATATYPE_in

public void where_DATATYPE_in(E4DBSelectDistinct filter)
                       throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) DATATYPE. STRING(32) Datatype

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

where_DATATYPE_notin

public void where_DATATYPE_notin(E4DBSelectDistinct filter)
                          throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) DATATYPE. STRING(32) Datatype

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

where_DATATYPE_isEmpty

public void where_DATATYPE_isEmpty()
                            throws E4DBException

Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column DATATYPE. STRING(32) Datatype

Throws:: E4DBException

where_DATATYPE_isNotEmpty

public void where_DATATYPE_isNotEmpty()
                               throws E4DBException

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

Throws:: E4DBException

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) Database 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) Database 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) Database 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) Database 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) Database 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) Database 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) Database 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) Database Table

Throws:: E4DBException

where_DISPLAY_MODE

public void where_DISPLAY_MODE(E4FreeFieldDisplayMode filter)
                        throws E4DBException

Define a filter (AND-ed WHERE) for column DISPLAY_MODE. E4FreeFieldDisplayMode defined as e4s.util.E4String(1) Display Mode

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

where_DISPLAY_MODE

public void where_DISPLAY_MODE(int operator,
                               E4FreeFieldDisplayMode filter)
                        throws E4DBException

Define a filter (AND-ed WHERE with operator) for column DISPLAY_MODE. E4FreeFieldDisplayMode defined as e4s.util.E4String(1) Display Mode

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

where_DISPLAY_MODE_like

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

Define a filter (AND-ed WHERE) for column DISPLAY_MODE. E4FreeFieldDisplayMode defined as e4s.util.E4String(1) Display Mode

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

where_DISPLAY_MODE_isNull

public void where_DISPLAY_MODE_isNull()
                               throws E4DBException

Define a is-null filter (AND-ed WHERE) for column DISPLAY_MODE. E4FreeFieldDisplayMode defined as e4s.util.E4String(1) Display Mode

Throws:: E4DBException
See Also:: E4FreeFieldDisplayMode

where_DISPLAY_MODE_isNotNull

public void where_DISPLAY_MODE_isNotNull()
                                  throws E4DBException

Define a is-NOT-null filter (AND-ed WHERE) for column DISPLAY_MODE. E4FreeFieldDisplayMode defined as e4s.util.E4String(1) Display Mode

Throws:: E4DBException
See Also:: E4FreeFieldDisplayMode

where_DISPLAY_MODE_in

public void where_DISPLAY_MODE_in(E4DBSelectDistinct filter)
                           throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) DISPLAY_MODE. E4FreeFieldDisplayMode defined as e4s.util.E4String(1) Display Mode

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

where_DISPLAY_MODE_notin

public void where_DISPLAY_MODE_notin(E4DBSelectDistinct filter)
                              throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) DISPLAY_MODE. E4FreeFieldDisplayMode defined as e4s.util.E4String(1) Display Mode

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

where_DISPLAY_MODE_isEmpty

public void where_DISPLAY_MODE_isEmpty()
                                throws E4DBException

Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column DISPLAY_MODE. E4FreeFieldDisplayMode defined as e4s.util.E4String(1) Display Mode

Throws:: E4DBException
See Also:: E4FreeFieldDisplayMode

where_DISPLAY_MODE_isNotEmpty

public void where_DISPLAY_MODE_isNotEmpty()
                                   throws E4DBException

Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column DISPLAY_MODE. E4FreeFieldDisplayMode defined as e4s.util.E4String(1) Display Mode

Throws:: E4DBException
See Also:: E4FreeFieldDisplayMode

where_ENABLE_SEARCH

public void where_ENABLE_SEARCH(boolean filter)
                         throws E4DBException

Define a filter (AND-ed WHERE) for column ENABLE_SEARCH. BOOLEAN Enable Search in Editing Framesets?

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

where_ENABLE_SEARCH

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

Define a filter (AND-ed WHERE with operator) for column ENABLE_SEARCH. BOOLEAN Enable Search in Editing Framesets?

Parameters:: filter - the value to be compared within the SQL statement; operator - the comparsion operator E4DBFilter
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_INITVAL

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

Define a filter (AND-ed WHERE) for column INITVAL. STRING(80) Initial Value

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

where_INITVAL

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

Define a filter (AND-ed WHERE with operator) for column INITVAL. STRING(80) Initial Value

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

where_INITVAL_isNull

public void where_INITVAL_isNull()
                          throws E4DBException

Define a is-null filter (AND-ed WHERE) for column INITVAL. STRING(80) Initial Value

Throws:: E4DBException

where_INITVAL_isNotNull

public void where_INITVAL_isNotNull()
                             throws E4DBException

Define a is-NOT-null filter (AND-ed WHERE) for column INITVAL. STRING(80) Initial Value

Throws:: E4DBException

where_INITVAL_in

public void where_INITVAL_in(E4DBSelectDistinct filter)
                      throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) INITVAL. STRING(80) Initial Value

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

where_INITVAL_notin

public void where_INITVAL_notin(E4DBSelectDistinct filter)
                         throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) INITVAL. STRING(80) Initial Value

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

where_INITVAL_isEmpty

public void where_INITVAL_isEmpty()
                           throws E4DBException

Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column INITVAL. STRING(80) Initial Value

Throws:: E4DBException

where_INITVAL_isNotEmpty

public void where_INITVAL_isNotEmpty()
                              throws E4DBException

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

Throws:: E4DBException

where_LABEL

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

Define a filter (AND-ed WHERE) for column LABEL. STRING(32) Label

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

where_LABEL

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

Define a filter (AND-ed WHERE with operator) for column LABEL. STRING(32) Label

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

where_LABEL_isNull

public void where_LABEL_isNull()
                        throws E4DBException

Define a is-null filter (AND-ed WHERE) for column LABEL. STRING(32) Label

Throws:: E4DBException

where_LABEL_isNotNull

public void where_LABEL_isNotNull()
                           throws E4DBException

Define a is-NOT-null filter (AND-ed WHERE) for column LABEL. STRING(32) Label

Throws:: E4DBException

where_LABEL_in

public void where_LABEL_in(E4DBSelectDistinct filter)
                    throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) LABEL. STRING(32) Label

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

where_LABEL_notin

public void where_LABEL_notin(E4DBSelectDistinct filter)
                       throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) LABEL. STRING(32) Label

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

where_LABEL_isEmpty

public void where_LABEL_isEmpty()
                         throws E4DBException

Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column LABEL. STRING(32) Label

Throws:: E4DBException

where_LABEL_isNotEmpty

public void where_LABEL_isNotEmpty()
                            throws E4DBException

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

Throws:: E4DBException

where_MANDATORY

public void where_MANDATORY(boolean filter)
                     throws E4DBException

Define a filter (AND-ed WHERE) for column MANDATORY. BOOLEAN Input is mandatory

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

where_MANDATORY

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

Define a filter (AND-ed WHERE with operator) for column MANDATORY. BOOLEAN Input is mandatory

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

where_POSTLABEL

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

Define a filter (AND-ed WHERE) for column POSTLABEL. STRING(20) Post label (displayed after the field)

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

where_POSTLABEL

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

Define a filter (AND-ed WHERE with operator) for column POSTLABEL. STRING(20) Post label (displayed after the field)

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

where_POSTLABEL_isNull

public void where_POSTLABEL_isNull()
                            throws E4DBException

Define a is-null filter (AND-ed WHERE) for column POSTLABEL. STRING(20) Post label (displayed after the field)

Throws:: E4DBException

where_POSTLABEL_isNotNull

public void where_POSTLABEL_isNotNull()
                               throws E4DBException

Define a is-NOT-null filter (AND-ed WHERE) for column POSTLABEL. STRING(20) Post label (displayed after the field)

Throws:: E4DBException

where_POSTLABEL_in

public void where_POSTLABEL_in(E4DBSelectDistinct filter)
                        throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) POSTLABEL. STRING(20) Post label (displayed after the field)

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

where_POSTLABEL_notin

public void where_POSTLABEL_notin(E4DBSelectDistinct filter)
                           throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) POSTLABEL. STRING(20) Post label (displayed after the field)

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

where_POSTLABEL_isEmpty

public void where_POSTLABEL_isEmpty()
                             throws E4DBException

Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column POSTLABEL. STRING(20) Post label (displayed after the field)

Throws:: E4DBException

where_POSTLABEL_isNotEmpty

public void where_POSTLABEL_isNotEmpty()
                                throws E4DBException

Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column POSTLABEL. STRING(20) Post label (displayed after the field)

Throws:: E4DBException

where_REM

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

Define a filter (AND-ed WHERE) for column REM. STRING(255) Remark

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

where_REM

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

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

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

where_REM_isNull

public void where_REM_isNull()
                      throws E4DBException

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

Throws:: E4DBException

where_REM_isNotNull

public void where_REM_isNotNull()
                         throws E4DBException

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

Throws:: E4DBException

where_REM_in

public void where_REM_in(E4DBSelectDistinct filter)
                  throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) REM. STRING(255) Remark

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

where_REM_notin

public void where_REM_notin(E4DBSelectDistinct filter)
                     throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) REM. STRING(255) Remark

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

where_REM_isEmpty

public void where_REM_isEmpty()
                       throws E4DBException

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

Throws:: E4DBException

where_REM_isNotEmpty

public void where_REM_isNotEmpty()
                          throws E4DBException

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

Throws:: E4DBException

where_SEL_VALUES

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

Define a filter (AND-ed WHERE) for column SEL_VALUES. TEXT Selection

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

where_SEL_VALUES

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

Define a filter (AND-ed WHERE with operator) for column SEL_VALUES. TEXT Selection

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

where_SORT

public void where_SORT(long filter)
                throws E4DBException

Define a filter (AND-ed WHERE) for column SORT. INTEGER Sort order

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

where_SORT

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

Define a filter (AND-ed WHERE with operator) for column SORT. INTEGER Sort order

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

where_SORT_in

public void where_SORT_in(E4DBSelectDistinct filter)
                   throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) SORT. INTEGER Sort order

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

where_SORT_notin

public void where_SORT_notin(E4DBSelectDistinct filter)
                      throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) SORT. INTEGER Sort order

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

and

public T_E4S_FREEFIELD_DEF_Sel.T_E4S_FREEFIELD_DEF_And and()

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_FREEFIELD_DEF_Sel.T_E4S_FREEFIELD_DEF_Or

T_E4S_FREEFIELD_DEF_Sel.T_E4S_FREEFIELD_DEF_Or

where_COLLABEL

where_COLLABEL

where_COLLABEL_isNull

where_COLLABEL_isNotNull

where_COLLABEL_in

where_COLLABEL_notin

where_COLLABEL_isEmpty

where_COLLABEL_isNotEmpty

where_DATALEN

where_DATALEN

where_DATALEN_in

where_DATALEN_notin

where_DATATYPE

where_DATATYPE

where_DATATYPE_isNull

where_DATATYPE_isNotNull

where_DATATYPE_in

where_DATATYPE_notin

where_DATATYPE_isEmpty

where_DATATYPE_isNotEmpty

where_DATMOD

where_DATMOD

where_DATMOD_isNull

where_DATMOD_isNotNull

where_DATMOD_in

where_DATMOD_notin

where_DATMOD_isEmpty

where_DATMOD_isNotEmpty

where_DATNEW

where_DATNEW

where_DATNEW_isNull

where_DATNEW_isNotNull

where_DATNEW_in

where_DATNEW_notin

where_DATNEW_isEmpty

where_DATNEW_isNotEmpty

where_DB_TABLE

where_DB_TABLE

where_DB_TABLE_isNull

where_DB_TABLE_isNotNull

where_DB_TABLE_in

where_DB_TABLE_notin

where_DB_TABLE_isEmpty

where_DB_TABLE_isNotEmpty

where_DISPLAY_MODE

where_DISPLAY_MODE

where_DISPLAY_MODE_like

where_DISPLAY_MODE_isNull

where_DISPLAY_MODE_isNotNull

where_DISPLAY_MODE_in

where_DISPLAY_MODE_notin

where_DISPLAY_MODE_isEmpty

where_DISPLAY_MODE_isNotEmpty

where_ENABLE_SEARCH

where_ENABLE_SEARCH

where_FREEFIELD_NAME

where_FREEFIELD_NAME

where_FREEFIELD_NAME_isNull

where_FREEFIELD_NAME_isNotNull

where_FREEFIELD_NAME_in

where_FREEFIELD_NAME_notin

where_FREEFIELD_NAME_isEmpty

where_FREEFIELD_NAME_isNotEmpty

where_INITVAL

where_INITVAL

where_INITVAL_isNull

where_INITVAL_isNotNull

where_INITVAL_in

where_INITVAL_notin

where_INITVAL_isEmpty

where_INITVAL_isNotEmpty

where_LABEL

where_LABEL

where_LABEL_isNull

where_LABEL_isNotNull

where_LABEL_in

where_LABEL_notin

where_LABEL_isEmpty

e4s.db.systabledef
Class T_E4S_FREEFIELD_DEF_Sel.T_E4S_FREEFIELD_DEF_Or