e4s.db
Interface E4DBFilterOr_Intf

All Superinterfaces:

E4DBFilter_Intf

All Known Implementing Classes:

E4DBFilterOr, T_E4S_CLIENT_Sel.T_E4S_CLIENT_Or, T_E4S_CLIENT_VAL_Sel.T_E4S_CLIENT_VAL_Or, T_E4S_COMPANY_GROUP_Sel.T_E4S_COMPANY_GROUP_Or, T_E4S_COMPANY_Sel.T_E4S_COMPANY_Or, T_E4S_COMPANY_USER_Sel.T_E4S_COMPANY_USER_Or, T_E4S_FREEFIELD_DEF_Sel.T_E4S_FREEFIELD_DEF_Or, T_E4S_FREEFIELD_VAL_Sel.T_E4S_FREEFIELD_VAL_Or, T_E4S_HINT_READ_Sel.T_E4S_HINT_READ_Or, T_E4S_HINT_Sel.T_E4S_HINT_Or, T_E4S_LOGIN_HISTORY_Sel.T_E4S_LOGIN_HISTORY_Or, T_E4S_MAIL_SENT_Sel.T_E4S_MAIL_SENT_Or, T_E4S_OVERVIEW_Sel.T_E4S_OVERVIEW_Or, T_E4S_PERMISSION_COMPANY_Sel.T_E4S_PERMISSION_COMPANY_Or, T_E4S_PERMISSION_GROUP_Sel.T_E4S_PERMISSION_GROUP_Or, T_E4S_PERMISSION_USER_Sel.T_E4S_PERMISSION_USER_Or, T_E4S_QUERY_CLIENTS_Sel.T_E4S_QUERY_CLIENTS_Or, T_E4S_QUERY_PARAMS_Sel.T_E4S_QUERY_PARAMS_Or, T_E4S_QUERY_Sel.T_E4S_QUERY_Or, T_E4S_TRANS_APP_Sel.T_E4S_TRANS_APP_Or, T_E4S_TRANS_DATA_Sel.T_E4S_TRANS_DATA_Or, T_E4S_TRANS_SYS_Sel.T_E4S_TRANS_SYS_Or, T_E4S_USER_VAL_Sel.T_E4S_USER_VAL_Or

public interface E4DBFilterOr_Intf
extends E4DBFilter_Intf

Method Summary

E4DBFilterAnd_Intf	AND() Create an AND-where element, linked to this OR-ed where.
java.lang.String	getWhere()
void	isEmpty(E4DBColumnName fieldname) Set a filter on a column that must either be empty or null
void	isNotEmpty(E4DBColumnName fieldname) Set an E4DBFilterAnd filter on a column that must not be empty and not null (...
void	isNotNull(E4DBColumnName fieldname) Set a filter on a column that must not be null
void	isNull(E4DBColumnName fieldname) Set a filter on a column that must be null
void	setFilter_NOT(E4DBColumnName fieldname, long[] filter) Creates a filter using the SQL NOT-IN statement.
void	setFilter_NOT(E4DBColumnName fieldname, java.lang.String[] filter) Creates a filter using the SQL NOT-IN statement.
void	setFilter(E4DBColumnName fieldname, boolean filter)
void	setFilter(E4DBColumnName fieldname, E4Long filter)
void	setFilter(E4DBColumnName fieldname, E4String filter)
void	setFilter(E4DBColumnName fieldname, E4String[] filter) Creates a filter using the SQL IN statement.
void	setFilter(E4DBColumnName fieldname, float filter)
void	setFilter(E4DBColumnName fieldname, int filter)
void	setFilter(E4DBColumnName fieldname, int comp_operator, boolean filter)
void	setFilter(E4DBColumnName fieldname, int comp_operator, java.util.Date filter)
void	setFilter(E4DBColumnName fieldname, int comp_operator, E4DBColumnName compareTo)
void	setFilter(E4DBColumnName fieldname, int comp_operator, E4Long filter)
void	setFilter(E4DBColumnName fieldname, int comp_operator, E4String filter)
void	setFilter(E4DBColumnName fieldname, int comp_operator, E4String filter, boolean quote)
void	setFilter(E4DBColumnName fieldname, int comp_operator, float filter)
void	setFilter(E4DBColumnName fieldname, int comp_operator, int filter)
void	setFilter(E4DBColumnName fieldname, int comp_operator, long filter)
void	setFilter(E4DBColumnName fieldname, int comp_operator, java.lang.String filter)
void	setFilter(E4DBColumnName fieldname, int comp_operator, java.lang.String filter, boolean quote)
void	setFilter(E4DBColumnName fieldname, long filter)
void	setFilter(E4DBColumnName fieldname, long[] filter) Creates a filter using the SQL IN statement.
void	setFilter(E4DBColumnName fieldname, java.lang.String filter)
void	setFilter(E4DBColumnName fieldname, java.lang.String[] filter) Creates a filter using the SQL IN statement.

Methods inherited from interface e4s.db.E4DBFilter_Intf

isWhereDefined, resetWhere

Method Detail

isNull

void isNull(E4DBColumnName fieldname)
            throws E4DBException

Set a filter on a column that must be null. [..x IS NULL..].

Parameters:

fieldname - the column to filter

Throws:

E4DBException

See Also:

isNotNull(e4s.db.E4DBColumnName), isEmpty(e4s.db.E4DBColumnName)

isNotNull

void isNotNull(E4DBColumnName fieldname)
               throws E4DBException

Set a filter on a column that must not be null. [..x IS NOT NULL..].

Parameters:

fieldname - the column to filter

Throws:

E4DBException

See Also:

isNull(e4s.db.E4DBColumnName), isNotEmpty(e4s.db.E4DBColumnName)

isEmpty

void isEmpty(E4DBColumnName fieldname)
             throws E4DBException

Set a filter on a column that must either be empty or null. [..x = '' OR x IS NULL..].

Parameters:

fieldname - the column to filter

Throws:

E4DBException

See Also:

isNull(e4s.db.E4DBColumnName), isNotEmpty(e4s.db.E4DBColumnName)

isNotEmpty

void isNotEmpty(E4DBColumnName fieldname)
                throws E4DBException

Set an E4DBFilterAnd filter on a column that must not be empty and not null (... WHERE (x IS NOT NULL AND x != '')...).

Parameters:

fieldname - the column to filter

Throws:

E4DBException

See Also:

isNull(e4s.db.E4DBColumnName), isNotEmpty(e4s.db.E4DBColumnName)

AND

E4DBFilterAnd_Intf AND()

Create an AND-where element, linked to this OR-ed where.

 e.g.  E4DBSelect record = new E4DBSelect(new e4s.db.TableName("mytable"));
       record.setFilter("A",1);
       E4DBFilterOr or = record.OR();
       or.setFilter("B",2);
       E4DBFilterAnd and = or.AND();
       and.setFilter("C",3);
       and.setFilter("D",4);
 results in 
       SELECT * FROM mytable WHERE A=1 OR (B=2 OR (C=3 AND D=4))
 

Returns:

the created and added OR-filter element.

setFilter

void setFilter(E4DBColumnName fieldname,
               java.lang.String filter)
               throws E4DBException

Throws:

E4DBException

setFilter

void setFilter(E4DBColumnName fieldname,
               E4String filter)
               throws E4DBException

Throws:

E4DBException

setFilter

void setFilter(E4DBColumnName fieldname,
               long filter)
               throws E4DBException

Throws:

E4DBException

setFilter

void setFilter(E4DBColumnName fieldname,
               float filter)
               throws E4DBException

Throws:

E4DBException

setFilter

void setFilter(E4DBColumnName fieldname,
               E4Long filter)
               throws E4DBException

Throws:

E4DBException

setFilter

void setFilter(E4DBColumnName fieldname,
               int comp_operator,
               java.lang.String filter)
               throws E4DBException

Throws:

E4DBException

setFilter

void setFilter(E4DBColumnName fieldname,
               int comp_operator,
               java.lang.String filter,
               boolean quote)
               throws E4DBException

Throws:

E4DBException

setFilter

void setFilter(E4DBColumnName fieldname,
               int comp_operator,
               E4String filter)
               throws E4DBException

Throws:

E4DBException

setFilter

void setFilter(E4DBColumnName fieldname,
               int comp_operator,
               E4String filter,
               boolean quote)
               throws E4DBException

Throws:

E4DBException

setFilter

void setFilter(E4DBColumnName fieldname,
               int comp_operator,
               long filter)
               throws E4DBException

Throws:

E4DBException

setFilter

void setFilter(E4DBColumnName fieldname,
               int comp_operator,
               float filter)
               throws E4DBException

Throws:

E4DBException

setFilter

void setFilter(E4DBColumnName fieldname,
               int comp_operator,
               E4Long filter)
               throws E4DBException

Throws:

E4DBException

setFilter

void setFilter(E4DBColumnName fieldname,
               int comp_operator,
               int filter)
               throws E4DBException

Throws:

E4DBException

setFilter

void setFilter(E4DBColumnName fieldname,
               int filter)
               throws E4DBException

Throws:

E4DBException

setFilter

void setFilter(E4DBColumnName fieldname,
               boolean filter)
               throws E4DBException

Throws:

E4DBException

setFilter

void setFilter(E4DBColumnName fieldname,
               int comp_operator,
               boolean filter)
               throws E4DBException

Throws:

E4DBException

setFilter

void setFilter(E4DBColumnName fieldname,
               int comp_operator,
               java.util.Date filter)
               throws E4DBException

Throws:

E4DBException

setFilter

void setFilter(E4DBColumnName fieldname,
               int comp_operator,
               E4DBColumnName compareTo)
               throws E4DBException

Throws:

E4DBException

setFilter

void setFilter(E4DBColumnName fieldname,
               long[] filter)
               throws E4DBException

Creates a filter using the SQL IN statement. Example: filter = {1,2,3} results in "fieldname IN (1,2,3)"

Parameters:

fieldname - the name of the column

filter - an array of values

Throws:

E4DBException

setFilter

void setFilter(E4DBColumnName fieldname,
               java.lang.String[] filter)
               throws E4DBException

Creates a filter using the SQL IN statement. Example: filter = {"A","B"} results in "fieldname IN ('A','B')"

Parameters:

fieldname - the name of the column

filter - an array of values

Throws:

E4DBException

setFilter

void setFilter(E4DBColumnName fieldname,
               E4String[] filter)
               throws E4DBException

Creates a filter using the SQL IN statement. Example: filter = {"A","B"} results in "fieldname IN ('A','B')"

Parameters:

fieldname - the name of the column

filter - an array of values

Throws:

E4DBException

setFilter_NOT

void setFilter_NOT(E4DBColumnName fieldname,
                   long[] filter)
                   throws E4DBException

Creates a filter using the SQL NOT-IN statement. Example: filter = {1,2,3} results in "fieldname NOT IN (1,2,3)"

Parameters:

fieldname - the name of the column

filter - an array of values

Throws:

E4DBException

setFilter_NOT

void setFilter_NOT(E4DBColumnName fieldname,
                   java.lang.String[] filter)
                   throws E4DBException

Creates a filter using the SQL NOT-IN statement. Example: filter = {"A","B"} results in "fieldname NOT IN ('A','B')"

Parameters:

fieldname - the name of the column

filter - an array of values

Throws:

E4DBException

getWhere

java.lang.String getWhere()

Specified by:

getWhere in interface E4DBFilter_Intf