e4s.db
Interface E4DBFilterAnd_Intf

All Superinterfaces:

E4DBFilter_Intf

All Known Implementing Classes:

E4DBFilterAnd, E4DBModify, E4DBModifyCommon, E4DBModifyFreefields, E4DBSelect, E4DBSelectDict, E4DBSelectFreefields, E4DBSelectView, T_E4S_CLIENT_Mod, T_E4S_CLIENT_Sel, T_E4S_CLIENT_Sel.T_E4S_CLIENT_And, T_E4S_CLIENT_VAL_Mod, T_E4S_CLIENT_VAL_Sel, T_E4S_CLIENT_VAL_Sel.T_E4S_CLIENT_VAL_And, T_E4S_COMPANY_GROUP_Mod, T_E4S_COMPANY_GROUP_Sel, T_E4S_COMPANY_GROUP_Sel.T_E4S_COMPANY_GROUP_And, T_E4S_COMPANY_Mod, T_E4S_COMPANY_Sel, T_E4S_COMPANY_Sel.T_E4S_COMPANY_And, T_E4S_COMPANY_USER_Mod, T_E4S_COMPANY_USER_Sel, T_E4S_COMPANY_USER_Sel.T_E4S_COMPANY_USER_And, T_E4S_FREEFIELD_DEF_Mod, T_E4S_FREEFIELD_DEF_Sel, T_E4S_FREEFIELD_DEF_Sel.T_E4S_FREEFIELD_DEF_And, T_E4S_FREEFIELD_VAL_Mod, T_E4S_FREEFIELD_VAL_Sel, T_E4S_FREEFIELD_VAL_Sel.T_E4S_FREEFIELD_VAL_And, T_E4S_HINT_Mod, T_E4S_HINT_READ_Mod, T_E4S_HINT_READ_Sel, T_E4S_HINT_READ_Sel.T_E4S_HINT_READ_And, T_E4S_HINT_Sel, T_E4S_HINT_Sel.T_E4S_HINT_And, T_E4S_LOGIN_HISTORY_Mod, T_E4S_LOGIN_HISTORY_Sel, T_E4S_LOGIN_HISTORY_Sel.T_E4S_LOGIN_HISTORY_And, T_E4S_MAIL_SENT_Mod, T_E4S_MAIL_SENT_Sel, T_E4S_MAIL_SENT_Sel.T_E4S_MAIL_SENT_And, T_E4S_OVERVIEW_Mod, T_E4S_OVERVIEW_Sel, T_E4S_OVERVIEW_Sel.T_E4S_OVERVIEW_And, T_E4S_PERMISSION_COMPANY_Mod, T_E4S_PERMISSION_COMPANY_Sel, T_E4S_PERMISSION_COMPANY_Sel.T_E4S_PERMISSION_COMPANY_And, T_E4S_PERMISSION_GROUP_Mod, T_E4S_PERMISSION_GROUP_Sel, T_E4S_PERMISSION_GROUP_Sel.T_E4S_PERMISSION_GROUP_And, T_E4S_PERMISSION_USER_Mod, T_E4S_PERMISSION_USER_Sel, T_E4S_PERMISSION_USER_Sel.T_E4S_PERMISSION_USER_And, T_E4S_QUERY_CLIENTS_Mod, T_E4S_QUERY_CLIENTS_Sel, T_E4S_QUERY_CLIENTS_Sel.T_E4S_QUERY_CLIENTS_And, T_E4S_QUERY_Mod, T_E4S_QUERY_PARAMS_Mod, T_E4S_QUERY_PARAMS_Sel, T_E4S_QUERY_PARAMS_Sel.T_E4S_QUERY_PARAMS_And, T_E4S_QUERY_Sel, T_E4S_QUERY_Sel.T_E4S_QUERY_And, T_E4S_TRANS_APP_Mod, T_E4S_TRANS_APP_Sel, T_E4S_TRANS_APP_Sel.T_E4S_TRANS_APP_And, T_E4S_TRANS_DATA_Mod, T_E4S_TRANS_DATA_Sel, T_E4S_TRANS_DATA_Sel.T_E4S_TRANS_DATA_And, T_E4S_TRANS_SYS_Mod, T_E4S_TRANS_SYS_Sel, T_E4S_TRANS_SYS_Sel.T_E4S_TRANS_SYS_And, T_E4S_USER_VAL_Mod, T_E4S_USER_VAL_Sel, T_E4S_USER_VAL_Sel.T_E4S_USER_VAL_And, V_E4S_USERS_Sel

public interface E4DBFilterAnd_Intf
extends E4DBFilter_Intf

Method Summary

java.lang.String	getWhere()
void	isEmpty(E4DBColumnName fieldname) Set a filter using E4DBFilterOr on a column that can either be empty or null
void	isNotEmpty(E4DBColumnName fieldname) Set a filter on a column that may not be null and not be empty
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
E4DBFilterOr_Intf	OR() Create an OR-where element, linked to this AND-es where.
void	setFilter_NOT(E4DBColumnName fieldname, E4Long[] filter) Creates a filter using the SQL NOT IN statement.
void	setFilter_NOT(E4DBColumnName fieldname, E4String[] filter) Creates a filter using the SQL NOT IN statement.
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, java.util.Calendar filter)
void	setFilter(E4DBColumnName fieldname, java.util.Date filter)
void	setFilter(E4DBColumnName fieldname, double filter)
void	setFilter(E4DBColumnName fieldname, E4Long filter)
void	setFilter(E4DBColumnName fieldname, E4Long[] filter) Creates a filter using the SQL IN statement.
void	setFilter(E4DBColumnName fieldname, E4String filter)
void	setFilter(E4DBColumnName fieldname, E4String[] filter) Creates a filter using the SQL NOT 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, double 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) Add an AND-ed filter to the where condition.
void	setFilter(E4DBColumnName fieldname, int comp_operator, java.lang.String filter, boolean quote) Add an AND-ed filter to the where condition.
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

OR

E4DBFilterOr_Intf OR()

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

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

Returns:

the created and added OR-filter element.

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)

isNotEmpty

void isNotEmpty(E4DBColumnName fieldname)
                throws E4DBException

Set a filter on a column that may not be null and not be empty. [..x IS NOT NULL AND x != ''..].

Parameters:

fieldname - the column to filter

Throws:

E4DBException

See Also:

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

isEmpty

void isEmpty(E4DBColumnName fieldname)
             throws E4DBException

Set a filter using E4DBFilterOr on a column that can 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)

isNotNull

void isNotNull(E4DBColumnName fieldname)
               throws E4DBException

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

Parameters:

fieldname - the column to filter

Throws:

E4DBException

See Also:

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

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,
               E4Long[] 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_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 IN (1,2,3)"

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 NOT IN statement. Example: filter = {"A","B","C"} results in "fieldname IN ('A','B','C')"

Parameters:

fieldname - the name of the column

filter - an array of values

Throws:

E4DBException

setFilter_NOT

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

Creates a filter using the SQL NOT 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_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

setFilter_NOT

void setFilter_NOT(E4DBColumnName fieldname,
                   E4String[] 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

setFilter

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

Throws:

E4DBException

setFilter

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

Add an AND-ed filter to the where condition.

Parameters:

fieldname - the fieldname

comp_operator - the comparsion operator (see E4DBFilter.COMP_EQUALS and others)

filter - the expression to be evaluated, add quotes before and after

Throws:

E4DBException

See Also:

setFilter(e4s.db.E4DBColumnName, long[])

setFilter

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

Add an AND-ed filter to the where condition.

Parameters:

fieldname - the fieldname

comp_operator - the comparsion operator (see E4DBFilter.COMP_EQUALS and others)

filter - the expression to be evaluated

quote - true: add quotes to the expression when SQL statement is created, false expect quotes are set correctly within filter

Throws:

E4DBException

See Also:

setFilter(e4s.db.E4DBColumnName, long[])

setFilter

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

Throws:

E4DBException

setFilter

void setFilter(E4DBColumnName fieldname,
               long filter)
               throws E4DBException

Throws:

E4DBException

setFilter

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

Throws:

E4DBException

setFilter

void setFilter(E4DBColumnName fieldname,
               double filter)
               throws E4DBException

Throws:

E4DBException

setFilter

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

Throws:

E4DBException

setFilter

void setFilter(E4DBColumnName fieldname,
               float filter)
               throws E4DBException

Throws:

E4DBException

setFilter

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

Throws:

E4DBException

setFilter

void setFilter(E4DBColumnName fieldname,
               boolean 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,
               int comp_operator,
               java.util.Date filter)
               throws E4DBException

Throws:

E4DBException

setFilter

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

Throws:

E4DBException

setFilter

void setFilter(E4DBColumnName fieldname,
               java.util.Calendar filter)
               throws E4DBException

Throws:

E4DBException

setFilter

void setFilter(E4DBColumnName fieldname,
               E4String filter)
               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,
               E4Long 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,
               E4DBColumnName compareTo)
               throws E4DBException

Throws:

E4DBException

getWhere

java.lang.String getWhere()

Specified by:

getWhere in interface E4DBFilter_Intf