e4s.db.systabledef
Class T_E4S_OVERVIEW_Sel.T_E4S_OVERVIEW_Or

java.lang.Object
  e4s.util.E4Object
      e4s.db.E4DBFilter
          e4s.db.E4DBFilterOr
              e4s.db.systabledef.T_E4S_OVERVIEW_Sel.T_E4S_OVERVIEW_Or

All Implemented Interfaces:

E4DBFilter_Intf, E4DBFilterOr_Intf

Enclosing class:

T_E4S_OVERVIEW_Sel

public static class T_E4S_OVERVIEW_Sel.T_E4S_OVERVIEW_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_OVERVIEW_Sel.T_E4S_OVERVIEW_Or()

Method Summary

T_E4S_OVERVIEW_Sel.T_E4S_OVERVIEW_And	and()
void	where_ACTIVE(boolean filter) Define a filter (AND-ed WHERE) for column ACTIVE.
void	where_ACTIVE(int operator, boolean filter) Define a filter (AND-ed WHERE with operator) for column ACTIVE.
void	where_GRP_in(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_GRP_isEmpty() Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column GRP.
void	where_GRP_isNotEmpty() Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column GRP.
void	where_GRP_isNotNull() Define a is-NOT-null filter (AND-ed WHERE) for column GRP.
void	where_GRP_isNull() Define a is-null filter (AND-ed WHERE) for column GRP.
void	where_GRP_like(java.lang.String filter) Define a filter (AND-ed WHERE) for column GRP.
void	where_GRP_notin(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_GRP(E4OverviewGroup filter) Define a filter (AND-ed WHERE) for column GRP.
void	where_GRP(int operator, E4OverviewGroup filter) Define a filter (AND-ed WHERE with operator) for column GRP.
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_IMG_in(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_IMG_isEmpty() Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column IMG.
void	where_IMG_isNotEmpty() Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column IMG.
void	where_IMG_isNotNull() Define a is-NOT-null filter (AND-ed WHERE) for column IMG.
void	where_IMG_isNull() Define a is-null filter (AND-ed WHERE) for column IMG.
void	where_IMG_notin(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_IMG(E4Image filter) Define a filter (AND-ed WHERE) for column IMG.
void	where_IMG(int operator, E4Image filter) Define a filter (AND-ed WHERE with operator) for column IMG.
void	where_LANG_in(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_LANG_isEmpty() Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column LANG.
void	where_LANG_isNotEmpty() Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column LANG.
void	where_LANG_isNotNull() Define a is-NOT-null filter (AND-ed WHERE) for column LANG.
void	where_LANG_isNull() Define a is-null filter (AND-ed WHERE) for column LANG.
void	where_LANG_like(java.lang.String filter) Define a filter (AND-ed WHERE) for column LANG.
void	where_LANG_notin(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_LANG(int operator, Language filter) Define a filter (AND-ed WHERE with operator) for column LANG.
void	where_LANG(Language filter) Define a filter (AND-ed WHERE) for column LANG.
void	where_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.
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_OVERVIEW_Sel.T_E4S_OVERVIEW_Or

public T_E4S_OVERVIEW_Sel.T_E4S_OVERVIEW_Or()

Method Detail

where_ACTIVE

public void where_ACTIVE(boolean filter)
                  throws E4DBException

Define a filter (AND-ed WHERE) for column ACTIVE. BOOLEAN Active Record ?

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_ACTIVE

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

Define a filter (AND-ed WHERE with operator) for column ACTIVE. BOOLEAN Active Record ?

Parameters:

filter - the value to be compared within the SQL statement

operator - the comparsion operator E4DBFilter

Throws:

E4DBException

where_GRP

public void where_GRP(E4OverviewGroup filter)
               throws E4DBException

Define a filter (AND-ed WHERE) for column GRP. E4OverviewGroup defined as e4s.util.E4String(12) Overview ID Group

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

See Also:

E4OverviewGroup

where_GRP

public void where_GRP(int operator,
                      E4OverviewGroup filter)
               throws E4DBException

Define a filter (AND-ed WHERE with operator) for column GRP. E4OverviewGroup defined as e4s.util.E4String(12) Overview ID Group

Parameters:

filter - the value to be compared within the SQL statement

operator - the comparsion operator E4DBFilter

Throws:

E4DBException

See Also:

E4OverviewGroup

where_GRP_like

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

Define a filter (AND-ed WHERE) for column GRP. E4OverviewGroup defined as e4s.util.E4String(12) Overview ID Group

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

See Also:

E4OverviewGroup

where_GRP_isNull

public void where_GRP_isNull()
                      throws E4DBException

Define a is-null filter (AND-ed WHERE) for column GRP. E4OverviewGroup defined as e4s.util.E4String(12) Overview ID Group

Throws:

E4DBException

See Also:

E4OverviewGroup

where_GRP_isNotNull

public void where_GRP_isNotNull()
                         throws E4DBException

Define a is-NOT-null filter (AND-ed WHERE) for column GRP. E4OverviewGroup defined as e4s.util.E4String(12) Overview ID Group

Throws:

E4DBException

See Also:

E4OverviewGroup

where_GRP_in

public void where_GRP_in(E4DBSelectDistinct filter)
                  throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) GRP. E4OverviewGroup defined as e4s.util.E4String(12) Overview ID Group

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

See Also:

E4OverviewGroup

where_GRP_notin

public void where_GRP_notin(E4DBSelectDistinct filter)
                     throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) GRP. E4OverviewGroup defined as e4s.util.E4String(12) Overview ID Group

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

See Also:

E4OverviewGroup

where_GRP_isEmpty

public void where_GRP_isEmpty()
                       throws E4DBException

Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column GRP. E4OverviewGroup defined as e4s.util.E4String(12) Overview ID Group

Throws:

E4DBException

See Also:

E4OverviewGroup

where_GRP_isNotEmpty

public void where_GRP_isNotEmpty()
                          throws E4DBException

Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column GRP. E4OverviewGroup defined as e4s.util.E4String(12) Overview ID Group

Throws:

E4DBException

See Also:

E4OverviewGroup

where_HEADER

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

Define a filter (AND-ed WHERE) for column HEADER. STRING(80) 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(80) 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(80) 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(80) 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(80) 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(80) 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(80) 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(80) Header

Throws:

E4DBException

where_ID

public void where_ID(long filter)
              throws E4DBException

Define a filter (AND-ed WHERE) for column ID. INTEGER Identification 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 Identification 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 Identification 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 Identification Autoincremental value

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_IMG

public void where_IMG(E4Image filter)
               throws E4DBException

Define a filter (AND-ed WHERE) for column IMG. E4Image defined as e4s.util.E4StringImage(128) General Image type Image

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

See Also:

E4Image

where_IMG

public void where_IMG(int operator,
                      E4Image filter)
               throws E4DBException

Define a filter (AND-ed WHERE with operator) for column IMG. E4Image defined as e4s.util.E4StringImage(128) General Image type Image

Parameters:

filter - the value to be compared within the SQL statement

operator - the comparsion operator E4DBFilter

Throws:

E4DBException

See Also:

E4Image

where_IMG_isNull

public void where_IMG_isNull()
                      throws E4DBException

Define a is-null filter (AND-ed WHERE) for column IMG. E4Image defined as e4s.util.E4StringImage(128) General Image type Image

Throws:

E4DBException

See Also:

E4Image

where_IMG_isNotNull

public void where_IMG_isNotNull()
                         throws E4DBException

Define a is-NOT-null filter (AND-ed WHERE) for column IMG. E4Image defined as e4s.util.E4StringImage(128) General Image type Image

Throws:

E4DBException

See Also:

E4Image

where_IMG_in

public void where_IMG_in(E4DBSelectDistinct filter)
                  throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) IMG. E4Image defined as e4s.util.E4StringImage(128) General Image type Image

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

See Also:

E4Image

where_IMG_notin

public void where_IMG_notin(E4DBSelectDistinct filter)
                     throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) IMG. E4Image defined as e4s.util.E4StringImage(128) General Image type Image

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

See Also:

E4Image

where_IMG_isEmpty

public void where_IMG_isEmpty()
                       throws E4DBException

Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column IMG. E4Image defined as e4s.util.E4StringImage(128) General Image type Image

Throws:

E4DBException

See Also:

E4Image

where_IMG_isNotEmpty

public void where_IMG_isNotEmpty()
                          throws E4DBException

Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column IMG. E4Image defined as e4s.util.E4StringImage(128) General Image type Image

Throws:

E4DBException

See Also:

E4Image

where_LANG

public void where_LANG(Language filter)
                throws E4DBException

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

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_LANG

public void where_LANG(int operator,
                       Language filter)
                throws E4DBException

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

Parameters:

filter - the value to be compared within the SQL statement

operator - the comparsion operator E4DBFilter

Throws:

E4DBException

where_LANG_like

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

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

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_LANG_isNull

public void where_LANG_isNull()
                       throws E4DBException

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

Throws:

E4DBException

where_LANG_isNotNull

public void where_LANG_isNotNull()
                          throws E4DBException

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

Throws:

E4DBException

where_LANG_in

public void where_LANG_in(E4DBSelectDistinct filter)
                   throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) LANG. Language Language

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_LANG_notin

public void where_LANG_notin(E4DBSelectDistinct filter)
                      throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) LANG. Language Language

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_LANG_isEmpty

public void where_LANG_isEmpty()
                        throws E4DBException

Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column LANG. Language Language

Throws:

E4DBException

where_LANG_isNotEmpty

public void where_LANG_isNotEmpty()
                           throws E4DBException

Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column LANG. Language Language

Throws:

E4DBException

where_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

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_OVERVIEW_Sel.T_E4S_OVERVIEW_And and()