T_E4S_COMPANY

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_COMPANY_Sel

java.lang.Object
  e4s.util.E4Object
      e4s.db.E4DBFilter
          e4s.db.E4DBFilterAnd
              e4s.db.E4DBSelect
                  e4s.db.freefield.E4DBSelectFreefields
                      e4s.db.systabledef.T_E4S_COMPANY_Sel

All Implemented Interfaces:: E4DBFilter_Intf, E4DBFilterAnd_Intf, E4DBSelect_Intf, E4DBSelectFreefields_Intf

public class T_E4S_COMPANY_Sel
extends E4DBSelectFreefields
implements E4DBSelectFreefields_Intf
extends E4DBSelectFreefields
implements E4DBSelectFreefields_Intf

SQL select for T_E4S_COMPANY: Hold Information about companies, users are related to companies. created: 20041222 105625, modified: 20071108 105117. $LastChangedRevision: 5290 $ $LastChangedDate: 2009-12-09 18:45:55 +0100 (Mi, 09 Dez 2009) $

Column	Datatype		Remark
ADDRESS01	STRING(60)		Address Line #1
ADDRESS02	STRING(60)		Address Line #2
BELONGS_TO	`E4CompanyId` INTEGER	3	Company belongs to another company (can be null or empty)
CITY	STRING(60)		City
COMPANY_ID	`E4CompanyId` INTEGER	1	Primary key, company - ID
COUNTRYCODE	CountryCode		Countrycode
DATMOD	DATE		Date modified
DATNEW	DATE		Date created
EMAIL	STRING(60)		Corporate eMail
GIS_LATITUDE	FLOAT		GIS Latitude
GIS_LONGITUDE	FLOAT		GIS Longitude
GROUP_ID	`E4CompanyGroup` STRING(16)		Belongs to Group
LOGIN_NAME	STRING(16)	2	Name for login
NAME	STRING(60)		Company Name
PHONE01	STRING(60)		Phone #1
PHONE02	STRING(60)		Phone #2
REM	STRING(255)		Remark
UID	STRING(14)		VAT Number
VALID_UNTIL	DATE		Valid until
WWW	STRING(60)		WWW Address
ZIPCODE	STRING(10)		ZIP Code

Index 1: COMPANY_ID unique Index 2: LOGIN_NAME unique Index 3: BELONGS

See Also:: T_E4S_COMPANY_Mod, T_E4S_COMPANY_Obj, T_E4S_COMPANY_Vec, V_E4S_USERS_Sel

Nested Class Summary
`static class`	`T_E4S_COMPANY_Sel.T_E4S_COMPANY_And` Filter to be used as AND condition.
`static class`	`T_E4S_COMPANY_Sel.T_E4S_COMPANY_Or` Filter to be used as OR condition.

Field Summary
`static E4DBColumnInfo`	`CI_ADDRESS01`
`static E4DBColumnInfo`	`CI_ADDRESS02`
`static E4DBColumnInfo`	`CI_BELONGS_TO`
`static E4DBColumnInfo`	`CI_CITY`
`static E4DBColumnInfo`	`CI_COMPANY_ID`
`static E4DBColumnInfo`	`CI_COUNTRYCODE`
`static E4DBColumnInfo`	`CI_DATMOD`
`static E4DBColumnInfo`	`CI_DATNEW`
`static E4DBColumnInfo`	`CI_EMAIL`
`static E4DBColumnInfo`	`CI_GIS_LATITUDE`
`static E4DBColumnInfo`	`CI_GIS_LONGITUDE`
`static E4DBColumnInfo`	`CI_GROUP_ID`
`static E4DBColumnInfo`	`CI_LOGIN_NAME`
`static E4DBColumnInfo`	`CI_NAME`
`static E4DBColumnInfo`	`CI_PHONE01`
`static E4DBColumnInfo`	`CI_PHONE02`
`static E4DBColumnInfo`	`CI_REM`
`static E4DBColumnInfo`	`CI_UID`
`static E4DBColumnInfo`	`CI_VALID_UNTIL`
`static E4DBColumnInfo`	`CI_WWW`
`static E4DBColumnInfo`	`CI_ZIPCODE`
`static E4DBColumnName`	`COL_ADDRESS01` STRING(60) Address Line #1
`static E4DBColumnName`	`COL_ADDRESS02` STRING(60) Address Line #2
`static E4DBColumnName`	`COL_BELONGS_TO` E4CompanyId defined as e4s.util.E4Long Numeric, incremental ID for companies Company belongs to another company (can be null or empty) Member of index: BELONGS.
`static E4DBColumnName`	`COL_CITY` STRING(60) City
`static E4DBColumnName`	`COL_COMPANY_ID` E4CompanyId defined as e4s.util.E4Long Numeric, incremental ID for companies Primary key, company - ID Autoincremental value Member of index: COMPANY_ID.
`static E4DBColumnName`	`COL_COUNTRYCODE` CountryCode Countrycode
`static E4DBColumnName`	`COL_DATMOD` DATE Date modified
`static E4DBColumnName`	`COL_DATNEW` DATE Date created
`static E4DBColumnName`	`COL_EMAIL` STRING(60) Corporate eMail
`static E4DBColumnName`	`COL_GIS_LATITUDE` FLOAT GIS Latitude
`static E4DBColumnName`	`COL_GIS_LONGITUDE` FLOAT GIS Longitude
`static E4DBColumnName`	`COL_GROUP_ID` E4CompanyGroup defined as e4s.util.E4String(16) Company Group Belongs to Group
`static E4DBColumnName`	`COL_LOGIN_NAME` STRING(16) Name for login Member of index: LOGIN_NAME.
`static E4DBColumnName`	`COL_NAME` STRING(60) Company Name
`static E4DBColumnName`	`COL_PHONE01` STRING(60) Phone #1
`static E4DBColumnName`	`COL_PHONE02` STRING(60) Phone #2
`static E4DBColumnName`	`COL_REM` STRING(255) Remark
`static E4DBColumnName`	`COL_UID` STRING(14) VAT Number
`static E4DBColumnName`	`COL_VALID_UNTIL` DATE Valid until
`static E4DBColumnName`	`COL_WWW` STRING(60) WWW Address
`static E4DBColumnName`	`COL_ZIPCODE` STRING(10) ZIP Code
`static E4DBColumnInfo[]`	`COLUMNS` Definition of database columns as array
`static E4DBIndexInfo`	`IDX_BELONGS` Definition of index IDX_BELONGS.
`static E4DBIndexInfo`	`IDX_COMPANY_ID` Definition of index IDX_COMPANY_ID.
`static E4DBIndexInfo`	`IDX_LOGIN_NAME` Definition of index IDX_LOGIN_NAME.
`static E4DBIndexInfo[]`	`INDEXES` Definition of table indexes.
`static boolean`	`IS_CLIENT_DISTINCTIVE` This table enables client distinction.
`static boolean`	`IS_FREEDEF_POSSIBLE` This table enables freedefined database fields.
`static int`	`SVN_REVISION` SVN Revision Code.
`static E4DBTableName`	`TABLENAME` Name of the database table.

Fields inherited from class e4s.db.freefield.E4DBSelectFreefields
`XML_EXPORT_FREEFIELD_NONE, XML_EXPORT_FREEFIELD_ROW, XML_EXPORT_FREEFIELD_TABLE`

Fields inherited from class e4s.db.E4DBSelect
`COLUMN_NAME_COUNT, COLUMN_NAME_SUM, DB_DATEFORMAT, DB_DATEPICTURE, ms_isunicode, NULL`

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_COMPANY_Sel(E4ApplObj_Intf applobj)` Construct an object for selecting data from T_E4S_COMPANY using the default database connection, the table uses client distinction.
`T_E4S_COMPANY_Sel(E4DBConnection_Intf dbcon, E4ApplObj_Intf applobj)` Construct an object for selecting data from T_E4S_COMPANY using a database connection, the table uses client distinction.
`T_E4S_COMPANY_Sel(T_E4S_COMPANY_Sel dbtable, boolean copy_where)` Construct an object for selecting data from T_E4S_COMPANY using an existing T_E4S_COMPANY_Sel instance.

Method Summary
`static E4DBReference[]`	`_getReferenceDelete(E4DBColumnName cName)`
`static E4DBReference[]`	`_getReferenceLookup(E4DBColumnName cName)`
`static java.lang.String`	`_getSVNVersionString()` Return the version info patched by CVS.
`boolean`	`canHaveFreeDefinedFields()` Check, if this table might have freedefined fields.
`static void`	`checkConsistency()` Check table consistency (structure only) against database.
`static void`	`checkConsistency(boolean check_structure, boolean check_index)` Check table consistency against database.
`static E4Fieldset`	`createFIELDSET()`
`static E4Fieldset`	`createFIELDSET(E4ApplObj_Intf applobj)`
`E4Fieldset`	`createFIELDSET(FORM form)`
`E4ID`	`E4ID()`
`static T_E4S_COMPANY_Vec`	`find_BELONGS(E4ApplObj_Intf appobj, E4CompanyId qBELONGS_TO)` Get records associates with non-index 3 (BELONGS).
`static T_E4S_COMPANY_Vec`	`find_BELONGS(E4DBConnection_Intf con, E4ApplObj_Intf appobj, E4CompanyId qBELONGS_TO)` Get records associates with non-unique index 3 (BELONGS).
`static T_E4S_COMPANY_Obj`	`find_COMPANY_ID(E4ApplObj_Intf appobj, E4CompanyId qCOMPANY_ID)` Find a record associates with unique index 1 (COMPANY_ID).
`static T_E4S_COMPANY_Obj`	`find_COMPANY_ID(E4ApplObj_Intf appobj, E4CompanyId qCOMPANY_ID, boolean readfreefields)` Find a record associates with unique index 1 (COMPANY_ID) and read associated freefield values.
`static T_E4S_COMPANY_Obj`	`find_COMPANY_ID(E4DBConnection_Intf con, E4ApplObj_Intf appobj, E4CompanyId qCOMPANY_ID)` Find a record associates with index 1 (COMPANY_ID).
`static T_E4S_COMPANY_Obj`	`find_COMPANY_ID(E4DBConnection_Intf con, E4ApplObj_Intf appobj, E4CompanyId qCOMPANY_ID, boolean readfreefields)` Find a record associates with index 1 (COMPANY_ID) and read associated freefield values.
`static T_E4S_COMPANY_Obj`	`find_LOGIN_NAME(E4ApplObj_Intf appobj, java.lang.String qLOGIN_NAME)` Find a record associates with unique index 2 (LOGIN_NAME).
`static T_E4S_COMPANY_Obj`	`find_LOGIN_NAME(E4ApplObj_Intf appobj, java.lang.String qLOGIN_NAME, boolean readfreefields)` Find a record associates with unique index 2 (LOGIN_NAME) and read associated freefield values.
`static T_E4S_COMPANY_Obj`	`find_LOGIN_NAME(E4DBConnection_Intf con, E4ApplObj_Intf appobj, java.lang.String qLOGIN_NAME)` Find a record associates with index 2 (LOGIN_NAME).
`static T_E4S_COMPANY_Obj`	`find_LOGIN_NAME(E4DBConnection_Intf con, E4ApplObj_Intf appobj, java.lang.String qLOGIN_NAME, boolean readfreefields)` Find a record associates with index 2 (LOGIN_NAME) and read associated freefield values.
`java.lang.String`	`get_ADDRESS01()` Get value for column ADDRESS01.
`java.lang.String`	`get_ADDRESS02()` Get value for column ADDRESS02.
`E4CompanyId`	`get_BELONGS_TO()` Get value for column BELONGS_TO.
`java.lang.String`	`get_CITY()` Get value for column CITY.
`E4Client`	`get_CLIENT()` Get value for client.
`E4CompanyId`	`get_COMPANY_ID()` Get value for column COMPANY_ID.
`CountryCode`	`get_COUNTRYCODE()` Get value for column COUNTRYCODE.
`java.util.Date`	`get_DATMOD()` Get value for column DATMOD.
`java.util.Date`	`get_DATNEW()` Get value for column DATNEW.
`java.lang.String`	`get_EMAIL()` Get value for column EMAIL.
`E4Fieldset`	`get_FIELDSET()`
`E4Fieldset`	`get_FIELDSET(FORM form)`
`float`	`get_GIS_LATITUDE()` Get value for column GIS_LATITUDE.
`float`	`get_GIS_LONGITUDE()` Get value for column GIS_LONGITUDE.
`E4CompanyGroup`	`get_GROUP_ID()` Get value for column GROUP_ID.
`java.lang.String`	`get_LOGIN_NAME()` Get value for column LOGIN_NAME.
`java.lang.String`	`get_NAME()` Get value for column NAME.
`java.lang.String`	`get_PHONE01()` Get value for column PHONE01.
`java.lang.String`	`get_PHONE02()` Get value for column PHONE02.
`java.lang.String`	`get_REM()` Get value for column REM.
`java.lang.String`	`get_UID()` Get value for column UID.
`java.util.Date`	`get_VALID_UNTIL()` Get value for column VALID_UNTIL.
`java.lang.String`	`get_WWW()` Get value for column WWW.
`java.lang.String`	`get_ZIPCODE()` Get value for column ZIPCODE.
`T_E4S_COMPANY_Obj`	`get()` Get the data object for T_E4S_COMPANY without reading freedefined values.
`T_E4S_COMPANY_Obj`	`get(boolean readfreefields)` Get the data object for T_E4S_COMPANY with optionally reading freedefined values.
`void`	`get(E4Fieldset fieldset)`
`E4DBColumnInfo[]`	`getColInfo()` Get information about the columns defined for this database table.
`E4DBIndexInfo`	`getFirstPrimaryIndex()` Get the fields defined for the first unique index `IDX_COMPANY_ID`.
`java.lang.String`	`getFreeval(E4DBFreeFieldName fieldname)` Get a value for the free-field specified.
`static T_E4S_FREEFIELD_DEF_Obj[]`	`getFreevalDefinitions(E4ApplObj_Intf applobj)` Get the definitions of the free fields.
`E4DBIndexInfo[]`	`getIdxInfo()` Get information about the indexes defined for this database table.
`java.lang.Class`	`getModifyClass()` Get the defined and generated class for the modifications, this means INSERT, UPDATE and DELETE, related to this table T_E4S_COMPANY.
`java.lang.Class`	`getObjectClass()` Get the defined and generated class for the data-object related to this table.
`E4PersistantVector`	`getQuery()` `E4DBSelect.executeQuery()` and store elements of type T_E4S_COMPANY_Obj in a Vector.
`E4PersistantVector`	`getQuery(boolean includefreefields)` `E4DBSelect.executeQuery()` and store elements of type T_E4S_COMPANY_Obj in a Vector.
`E4DBReference[]`	`getReferenceDelete(E4DBColumnName cName)` Return null.
`E4DBReference[]`	`getReferenceLookup(E4DBColumnName cName)` Return null.
`E4DBTypeUsage[]`	`getUsage(E4DBColumnName colname)` For the case, that the specified column is a e4s defined type (e.g.
`boolean`	`hasClientDistinctive()` Get the state if data of this table will be distincted by `E4Client`.
`static boolean`	`isEmpty(E4DBConnection_Intf con, E4ApplObj_Intf applobj)` Check, if this table contains any data.
`E4DBModify_Intf`	`makeInstance_Modify(boolean copy_where)` Make an instance of the associated class for modification of database table entries.
`E4DBSelect_Intf`	`makeInstance(boolean copy_where)` Create a new instance for T_E4S_COMPANY_Sel
`boolean`	`next()` Fetch next record.
`T_E4S_COMPANY_Sel.T_E4S_COMPANY_Or`	`or()`
`void`	`sort_ADDRESS01_descending()` Sort descending by column ADDRESS01.
`void`	`sort_ADDRESS01()` Sort ascending by column ADDRESS01.
`void`	`sort_ADDRESS02_descending()` Sort descending by column ADDRESS02.
`void`	`sort_ADDRESS02()` Sort ascending by column ADDRESS02.
`void`	`sort_BELONGS_TO_descending()` Sort descending by column BELONGS_TO.
`void`	`sort_BELONGS_TO()` Sort ascending by column BELONGS_TO.
`void`	`sort_CITY_descending()` Sort descending by column CITY.
`void`	`sort_CITY()` Sort ascending by column CITY.
`void`	`sort_COMPANY_ID_descending()` Sort descending by column COMPANY_ID.
`void`	`sort_COMPANY_ID()` Sort ascending by column COMPANY_ID.
`void`	`sort_COUNTRYCODE_descending()` Sort descending by column COUNTRYCODE.
`void`	`sort_COUNTRYCODE()` Sort ascending by column COUNTRYCODE.
`void`	`sort_DATMOD_descending()` Sort descending by column DATMOD.
`void`	`sort_DATMOD()` Sort ascending by column DATMOD.
`void`	`sort_DATNEW_descending()` Sort descending by column DATNEW.
`void`	`sort_DATNEW()` Sort ascending by column DATNEW.
`void`	`sort_EMAIL_descending()` Sort descending by column EMAIL.
`void`	`sort_EMAIL()` Sort ascending by column EMAIL.
`void`	`sort_GIS_LATITUDE_descending()` Sort descending by column GIS_LATITUDE.
`void`	`sort_GIS_LATITUDE()` Sort ascending by column GIS_LATITUDE.
`void`	`sort_GIS_LONGITUDE_descending()` Sort descending by column GIS_LONGITUDE.
`void`	`sort_GIS_LONGITUDE()` Sort ascending by column GIS_LONGITUDE.
`void`	`sort_GROUP_ID_descending()` Sort descending by column GROUP_ID.
`void`	`sort_GROUP_ID()` Sort ascending by column GROUP_ID.
`void`	`sort_LOGIN_NAME_descending()` Sort descending by column LOGIN_NAME.
`void`	`sort_LOGIN_NAME()` Sort ascending by column LOGIN_NAME.
`void`	`sort_NAME_descending()` Sort descending by column NAME.
`void`	`sort_NAME()` Sort ascending by column NAME.
`void`	`sort_PHONE01_descending()` Sort descending by column PHONE01.
`void`	`sort_PHONE01()` Sort ascending by column PHONE01.
`void`	`sort_PHONE02_descending()` Sort descending by column PHONE02.
`void`	`sort_PHONE02()` Sort ascending by column PHONE02.
`void`	`sort_REM_descending()` Sort descending by column REM.
`void`	`sort_REM()` Sort ascending by column REM.
`void`	`sort_UID_descending()` Sort descending by column UID.
`void`	`sort_UID()` Sort ascending by column UID.
`void`	`sort_VALID_UNTIL_descending()` Sort descending by column VALID_UNTIL.
`void`	`sort_VALID_UNTIL()` Sort ascending by column VALID_UNTIL.
`void`	`sort_WWW_descending()` Sort descending by column WWW.
`void`	`sort_WWW()` Sort ascending by column WWW.
`void`	`sort_ZIPCODE_descending()` Sort descending by column ZIPCODE.
`void`	`sort_ZIPCODE()` Sort ascending by column ZIPCODE.
`static int`	`toCsv(E4ApplObj_Intf appobj, java.lang.String path)` Export data from database table to CSV file (MS-Excel input format).
`static int`	`toCsv(E4ApplObj_Intf appobj, java.lang.String path, boolean freefields)` Export data from database table to CSV file (MS-Excel input format).
`int`	`toCsv(E4PrintStream out)` Export data from database table to CSV file (MS-Excel compatible input format).
`int`	`toCsv(E4PrintStream out, boolean include_freefields)` Export data from database table to CSV file (MS-Excel compatible input format).
`static int`	`toSql(E4ApplObj_Intf appobj, java.lang.String path, int include_freefields)` Export data from database table to XML file.
`int`	`toSql(E4PrintStream out)` Export data from database table to SQL file.
`int`	`toSql(E4PrintStream out, int include_freefields)` Export data from database table to SQL script file.
`static int`	`toXml(E4ApplObj_Intf appobj, java.lang.String path, int include_freefields)` Export data from database table to XML file.
`static int`	`toXml(E4ApplObj_Intf appobj, java.lang.String path, int include_freefields, E4DBColumnName distinctCol)` Export data from database table to XML file.
`static int`	`toXml(E4ApplObj_Intf appobj, java.lang.String path, int include_freefields, E4StatusInformation_Intf status)` Export data from database table to XML file.
`static int`	`toXml(E4ApplObj_Intf appobj, java.lang.String path, int include_freefields, E4StatusInformation_Intf status, E4DBColumnName distinctCol)` Export data from database table to XML file.
`int`	`toXml(E4PrintStream out, int include_freefields)` Export data from database table to XML file.
`int`	`toXml(E4PrintStream out, int include_freefields, E4StatusInformation_Intf status)` Export data from database table to XML file.
`void`	`where_ADDRESS01_in(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_ADDRESS01_in(java.lang.String[] filter)` Define a IN-filter (AND-ed WHERE) for column ADDRESS01.
`void`	`where_ADDRESS01_isEmpty()` Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column ADDRESS01.
`void`	`where_ADDRESS01_isNotEmpty()` Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column ADDRESS01.
`void`	`where_ADDRESS01_isNotNull()` Define a is-NOT-null filter (AND-ed WHERE) for column ADDRESS01.
`void`	`where_ADDRESS01_isNull()` Define a is-null filter (AND-ed WHERE) for column ADDRESS01.
`void`	`where_ADDRESS01_not_in(java.lang.String[] filter)` Define a NOT-IN-filter (AND-ed WHERE) for column ADDRESS01.
`void`	`where_ADDRESS01_notin(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_ADDRESS01(int operator, java.lang.String filter)` Define a filter (AND-ed WHERE with operator) for column ADDRESS01.
`void`	`where_ADDRESS01(java.lang.String filter)` Define a filter (AND-ed WHERE) for column ADDRESS01.
`void`	`where_ADDRESS02_in(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_ADDRESS02_in(java.lang.String[] filter)` Define a IN-filter (AND-ed WHERE) for column ADDRESS02.
`void`	`where_ADDRESS02_isEmpty()` Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column ADDRESS02.
`void`	`where_ADDRESS02_isNotEmpty()` Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column ADDRESS02.
`void`	`where_ADDRESS02_isNotNull()` Define a is-NOT-null filter (AND-ed WHERE) for column ADDRESS02.
`void`	`where_ADDRESS02_isNull()` Define a is-null filter (AND-ed WHERE) for column ADDRESS02.
`void`	`where_ADDRESS02_not_in(java.lang.String[] filter)` Define a NOT-IN-filter (AND-ed WHERE) for column ADDRESS02.
`void`	`where_ADDRESS02_notin(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_ADDRESS02(int operator, java.lang.String filter)` Define a filter (AND-ed WHERE with operator) for column ADDRESS02.
`void`	`where_ADDRESS02(java.lang.String filter)` Define a filter (AND-ed WHERE) for column ADDRESS02.
`void`	`where_BELONGS_TO_in(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_BELONGS_TO_notin(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_BELONGS_TO(E4CompanyId filter)` Define a filter (AND-ed WHERE) for column BELONGS_TO.
`void`	`where_BELONGS_TO(int operator, E4CompanyId filter)` Define a filter (AND-ed WHERE with operator) for column BELONGS_TO.
`void`	`where_CITY_in(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_CITY_in(java.lang.String[] filter)` Define a IN-filter (AND-ed WHERE) for column CITY.
`void`	`where_CITY_isEmpty()` Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column CITY.
`void`	`where_CITY_isNotEmpty()` Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column CITY.
`void`	`where_CITY_isNotNull()` Define a is-NOT-null filter (AND-ed WHERE) for column CITY.
`void`	`where_CITY_isNull()` Define a is-null filter (AND-ed WHERE) for column CITY.
`void`	`where_CITY_not_in(java.lang.String[] filter)` Define a NOT-IN-filter (AND-ed WHERE) for column CITY.
`void`	`where_CITY_notin(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_CITY(int operator, java.lang.String filter)` Define a filter (AND-ed WHERE with operator) for column CITY.
`void`	`where_CITY(java.lang.String filter)` Define a filter (AND-ed WHERE) for column CITY.
`void`	`where_COMPANY_ID_in(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_COMPANY_ID_notin(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_COMPANY_ID(E4CompanyId filter)` Define a filter (AND-ed WHERE) for column COMPANY_ID.
`void`	`where_COMPANY_ID(int operator, E4CompanyId filter)` Define a filter (AND-ed WHERE with operator) for column COMPANY_ID.
`void`	`where_COUNTRYCODE_in(CountryCode[] filter)` Define a IN-filter (AND-ed WHERE) for column COUNTRYCODE.
`void`	`where_COUNTRYCODE_in(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_COUNTRYCODE_isEmpty()` Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column COUNTRYCODE.
`void`	`where_COUNTRYCODE_isNotEmpty()` Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column COUNTRYCODE.
`void`	`where_COUNTRYCODE_isNotNull()` Define a is-NOT-null filter (AND-ed WHERE) for column COUNTRYCODE.
`void`	`where_COUNTRYCODE_isNull()` Define a is-null filter (AND-ed WHERE) for column COUNTRYCODE.
`void`	`where_COUNTRYCODE_like(java.lang.String filter)` Define a filter (AND-ed WHERE) for column COUNTRYCODE.
`void`	`where_COUNTRYCODE_not_in(CountryCode[] filter)` Define a NOT-IN-filter (AND-ed WHERE) for column COUNTRYCODE.
`void`	`where_COUNTRYCODE_notin(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_COUNTRYCODE(CountryCode filter)` Define a filter (AND-ed WHERE) for column COUNTRYCODE.
`void`	`where_COUNTRYCODE(int operator, CountryCode filter)` Define a filter (AND-ed WHERE with operator) for column COUNTRYCODE.
`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_EMAIL_in(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_EMAIL_in(java.lang.String[] filter)` Define a IN-filter (AND-ed WHERE) for column EMAIL.
`void`	`where_EMAIL_isEmpty()` Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column EMAIL.
`void`	`where_EMAIL_isNotEmpty()` Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column EMAIL.
`void`	`where_EMAIL_isNotNull()` Define a is-NOT-null filter (AND-ed WHERE) for column EMAIL.
`void`	`where_EMAIL_isNull()` Define a is-null filter (AND-ed WHERE) for column EMAIL.
`void`	`where_EMAIL_not_in(java.lang.String[] filter)` Define a NOT-IN-filter (AND-ed WHERE) for column EMAIL.
`void`	`where_EMAIL_notin(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_EMAIL(int operator, java.lang.String filter)` Define a filter (AND-ed WHERE with operator) for column EMAIL.
`void`	`where_EMAIL(java.lang.String filter)` Define a filter (AND-ed WHERE) for column EMAIL.
`void`	`where_GIS_LATITUDE(float filter)` Define a filter (AND-ed WHERE) for column GIS_LATITUDE.
`void`	`where_GIS_LATITUDE(int operator, float filter)` Define a filter (AND-ed WHERE with operator) for column GIS_LATITUDE.
`void`	`where_GIS_LONGITUDE(float filter)` Define a filter (AND-ed WHERE) for column GIS_LONGITUDE.
`void`	`where_GIS_LONGITUDE(int operator, float filter)` Define a filter (AND-ed WHERE with operator) for column GIS_LONGITUDE.
`void`	`where_GROUP_ID_in(E4CompanyGroup[] filter)` Define a IN-filter (AND-ed WHERE) for column GROUP_ID.
`void`	`where_GROUP_ID_in(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_GROUP_ID_isEmpty()` Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column GROUP_ID.
`void`	`where_GROUP_ID_isNotEmpty()` Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column GROUP_ID.
`void`	`where_GROUP_ID_isNotNull()` Define a is-NOT-null filter (AND-ed WHERE) for column GROUP_ID.
`void`	`where_GROUP_ID_isNull()` Define a is-null filter (AND-ed WHERE) for column GROUP_ID.
`void`	`where_GROUP_ID_like(java.lang.String filter)` Define a filter (AND-ed WHERE) for column GROUP_ID.
`void`	`where_GROUP_ID_not_in(E4CompanyGroup[] filter)` Define a NOT-IN-filter (AND-ed WHERE) for column GROUP_ID.
`void`	`where_GROUP_ID_notin(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_GROUP_ID(E4CompanyGroup filter)` Define a filter (AND-ed WHERE) for column GROUP_ID.
`void`	`where_GROUP_ID(int operator, E4CompanyGroup filter)` Define a filter (AND-ed WHERE with operator) for column GROUP_ID.
`void`	`where_LOGIN_NAME_in(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_LOGIN_NAME_in(java.lang.String[] filter)` Define a IN-filter (AND-ed WHERE) for column LOGIN_NAME.
`void`	`where_LOGIN_NAME_isEmpty()` Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column LOGIN_NAME.
`void`	`where_LOGIN_NAME_isNotEmpty()` Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column LOGIN_NAME.
`void`	`where_LOGIN_NAME_isNotNull()` Define a is-NOT-null filter (AND-ed WHERE) for column LOGIN_NAME.
`void`	`where_LOGIN_NAME_isNull()` Define a is-null filter (AND-ed WHERE) for column LOGIN_NAME.
`void`	`where_LOGIN_NAME_not_in(java.lang.String[] filter)` Define a NOT-IN-filter (AND-ed WHERE) for column LOGIN_NAME.
`void`	`where_LOGIN_NAME_notin(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_LOGIN_NAME(int operator, java.lang.String filter)` Define a filter (AND-ed WHERE with operator) for column LOGIN_NAME.
`void`	`where_LOGIN_NAME(java.lang.String filter)` Define a filter (AND-ed WHERE) for column LOGIN_NAME.
`void`	`where_NAME_in(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_NAME_in(java.lang.String[] filter)` Define a IN-filter (AND-ed WHERE) for column NAME.
`void`	`where_NAME_isEmpty()` Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column NAME.
`void`	`where_NAME_isNotEmpty()` Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column NAME.
`void`	`where_NAME_isNotNull()` Define a is-NOT-null filter (AND-ed WHERE) for column NAME.
`void`	`where_NAME_isNull()` Define a is-null filter (AND-ed WHERE) for column NAME.
`void`	`where_NAME_not_in(java.lang.String[] filter)` Define a NOT-IN-filter (AND-ed WHERE) for column NAME.
`void`	`where_NAME_notin(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_NAME(int operator, java.lang.String filter)` Define a filter (AND-ed WHERE with operator) for column NAME.
`void`	`where_NAME(java.lang.String filter)` Define a filter (AND-ed WHERE) for column NAME.
`void`	`where_PHONE01_in(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_PHONE01_in(java.lang.String[] filter)` Define a IN-filter (AND-ed WHERE) for column PHONE01.
`void`	`where_PHONE01_isEmpty()` Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column PHONE01.
`void`	`where_PHONE01_isNotEmpty()` Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column PHONE01.
`void`	`where_PHONE01_isNotNull()` Define a is-NOT-null filter (AND-ed WHERE) for column PHONE01.
`void`	`where_PHONE01_isNull()` Define a is-null filter (AND-ed WHERE) for column PHONE01.
`void`	`where_PHONE01_not_in(java.lang.String[] filter)` Define a NOT-IN-filter (AND-ed WHERE) for column PHONE01.
`void`	`where_PHONE01_notin(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_PHONE01(int operator, java.lang.String filter)` Define a filter (AND-ed WHERE with operator) for column PHONE01.
`void`	`where_PHONE01(java.lang.String filter)` Define a filter (AND-ed WHERE) for column PHONE01.
`void`	`where_PHONE02_in(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_PHONE02_in(java.lang.String[] filter)` Define a IN-filter (AND-ed WHERE) for column PHONE02.
`void`	`where_PHONE02_isEmpty()` Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column PHONE02.
`void`	`where_PHONE02_isNotEmpty()` Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column PHONE02.
`void`	`where_PHONE02_isNotNull()` Define a is-NOT-null filter (AND-ed WHERE) for column PHONE02.
`void`	`where_PHONE02_isNull()` Define a is-null filter (AND-ed WHERE) for column PHONE02.
`void`	`where_PHONE02_not_in(java.lang.String[] filter)` Define a NOT-IN-filter (AND-ed WHERE) for column PHONE02.
`void`	`where_PHONE02_notin(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_PHONE02(int operator, java.lang.String filter)` Define a filter (AND-ed WHERE with operator) for column PHONE02.
`void`	`where_PHONE02(java.lang.String filter)` Define a filter (AND-ed WHERE) for column PHONE02.
`void`	`where_REM_in(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_REM_in(java.lang.String[] filter)` Define a IN-filter (AND-ed WHERE) for column REM.
`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_not_in(java.lang.String[] filter)` Define a NOT-IN-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_UID_in(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_UID_in(java.lang.String[] filter)` Define a IN-filter (AND-ed WHERE) for column UID.
`void`	`where_UID_isEmpty()` Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column UID.
`void`	`where_UID_isNotEmpty()` Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column UID.
`void`	`where_UID_isNotNull()` Define a is-NOT-null filter (AND-ed WHERE) for column UID.
`void`	`where_UID_isNull()` Define a is-null filter (AND-ed WHERE) for column UID.
`void`	`where_UID_not_in(java.lang.String[] filter)` Define a NOT-IN-filter (AND-ed WHERE) for column UID.
`void`	`where_UID_notin(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_UID(int operator, java.lang.String filter)` Define a filter (AND-ed WHERE with operator) for column UID.
`void`	`where_UID(java.lang.String filter)` Define a filter (AND-ed WHERE) for column UID.
`void`	`where_VALID_UNTIL_in(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_VALID_UNTIL_isEmpty()` Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column VALID_UNTIL.
`void`	`where_VALID_UNTIL_isNotEmpty()` Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column VALID_UNTIL.
`void`	`where_VALID_UNTIL_isNotNull()` Define a is-NOT-null filter (AND-ed WHERE) for column VALID_UNTIL.
`void`	`where_VALID_UNTIL_isNull()` Define a is-null filter (AND-ed WHERE) for column VALID_UNTIL.
`void`	`where_VALID_UNTIL_notin(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_VALID_UNTIL(java.util.Date filter)` Define a filter (AND-ed WHERE) for column VALID_UNTIL.
`void`	`where_VALID_UNTIL(int operator, java.util.Date filter)` Define a filter (AND-ed WHERE with operator) for column VALID_UNTIL.
`void`	`where_WWW_in(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_WWW_in(java.lang.String[] filter)` Define a IN-filter (AND-ed WHERE) for column WWW.
`void`	`where_WWW_isEmpty()` Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column WWW.
`void`	`where_WWW_isNotEmpty()` Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column WWW.
`void`	`where_WWW_isNotNull()` Define a is-NOT-null filter (AND-ed WHERE) for column WWW.
`void`	`where_WWW_isNull()` Define a is-null filter (AND-ed WHERE) for column WWW.
`void`	`where_WWW_not_in(java.lang.String[] filter)` Define a NOT-IN-filter (AND-ed WHERE) for column WWW.
`void`	`where_WWW_notin(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_WWW(int operator, java.lang.String filter)` Define a filter (AND-ed WHERE with operator) for column WWW.
`void`	`where_WWW(java.lang.String filter)` Define a filter (AND-ed WHERE) for column WWW.
`void`	`where_ZIPCODE_in(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_ZIPCODE_in(java.lang.String[] filter)` Define a IN-filter (AND-ed WHERE) for column ZIPCODE.
`void`	`where_ZIPCODE_isEmpty()` Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column ZIPCODE.
`void`	`where_ZIPCODE_isNotEmpty()` Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column ZIPCODE.
`void`	`where_ZIPCODE_isNotNull()` Define a is-NOT-null filter (AND-ed WHERE) for column ZIPCODE.
`void`	`where_ZIPCODE_isNull()` Define a is-null filter (AND-ed WHERE) for column ZIPCODE.
`void`	`where_ZIPCODE_not_in(java.lang.String[] filter)` Define a NOT-IN-filter (AND-ed WHERE) for column ZIPCODE.
`void`	`where_ZIPCODE_notin(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_ZIPCODE(int operator, java.lang.String filter)` Define a filter (AND-ed WHERE with operator) for column ZIPCODE.
`void`	`where_ZIPCODE(java.lang.String filter)` Define a filter (AND-ed WHERE) for column ZIPCODE.

Methods inherited from class e4s.db.freefield.E4DBSelectFreefields
`copyFreevalDefinitions, copyFreevalDefinitions, data2csvHeaderFreefields, data2xmlHeaderFreefields, getFreeval_Bool, getFreeval_Date, getFreeval_Float, getFreeval_Long, getFreevalDefinitions, getFreevalDefinitions, getFreevalDefinitions, getFreevalDefinitions, getFreeValues, getFreeValues, getFreeValues, hasFreeField, hasFreeField, hasFreeField, toSqlFreefieldValues, toXmlFreefieldValues`

Methods inherited from class e4s.db.E4DBSelect
checkConsistencyIndex, checkConsistencyIndex, checkConsistencyTable, checkConsistencyTable, checkConsistencyTable, close, data2csv, data2csv, data2csv, data2csv, data2csv, data2csv, data2csv, data2csvHeader, data2csvHeader, disableLogging, enableLogging, enableUnicode, executeCount, executeCountQuery, executeCountQuery, executeCountQuery, executeDistinctQuery, executeDistinctQuery, executeMax, executeMaxDate, executeMaxString, executeMin, executeMinDate, executeMinString, executeQuery, executeQuery, executeQuery, executeSQL, executeSQL, executeSQL, executeSumQuery, executeSumQuery, executeSumQuery, finalize, getBoolean, getConnection, getDate, getDistinctData, getDouble, getE4Long, getE4String, getFloat, getInt, getLong, getMetaData, getResultSet, getStatement, getString, getTableName, isLogging, isTable, isUnicodeEnabled, isView, removeOwnTableColumn, reset, resetOrderBy, setConnection, setFilterQuery, setFilterQuery, setOrderBy, setOrderBy, setOrderExtended, supportsSorting, toDate, toString, toString

Methods inherited from class e4s.db.E4DBSelect

checkConsistencyIndex, checkConsistencyIndex, checkConsistencyTable, checkConsistencyTable, checkConsistencyTable, close, data2csv, data2csv, data2csv, data2csv, data2csv, data2csv, data2csv, data2csvHeader, data2csvHeader, disableLogging, enableLogging, enableUnicode, executeCount, executeCountQuery, executeCountQuery, executeCountQuery, executeDistinctQuery, executeDistinctQuery, executeMax, executeMaxDate, executeMaxString, executeMin, executeMinDate, executeMinString, executeQuery, executeQuery, executeQuery, executeSQL, executeSQL, executeSQL, executeSumQuery, executeSumQuery, executeSumQuery, finalize, getBoolean, getConnection, getDate, getDistinctData, getDouble, getE4Long, getE4String, getFloat, getInt, getLong, getMetaData, getResultSet, getStatement, getString, getTableName, isLogging, isTable, isUnicodeEnabled, isView, removeOwnTableColumn, reset, resetOrderBy, setConnection, setFilterQuery, setFilterQuery, setOrderBy, setOrderBy, setOrderExtended, supportsSorting, toDate, toString, toString

Methods inherited from class e4s.db.E4DBFilterAnd
`getWhere, isEmpty, isNotEmpty, isNotNull, isNull, OR, setFilter_NOT, setFilter_NOT, 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, setFilter`

Methods inherited from class e4s.db.E4DBFilterAnd

getWhere, isEmpty, isNotEmpty, isNotNull, isNull, OR, setFilter_NOT, setFilter_NOT, 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, setFilter

Methods inherited from class e4s.db.E4DBFilter
`Escape, Escape, 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, toString, wait, wait, wait`

Methods inherited from interface e4s.db.freefield.E4DBSelectFreefields_Intf
`getFreeval_Bool, getFreeval_Date, getFreeval_Float, getFreeval_Long, getFreevalDefinitions, getFreeValues, hasFreeField`

Methods inherited from interface e4s.db.E4DBSelect_Intf
`close, executeQuery, getApplObj, getBoolean, getConnection, getDate, getFloat, getLong, getMetaData, getString, getTableName, getWhere, isTable, isView, isWhereDefined, reset, resetOrderBy, resetWhere, setConnection, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setOrderBy, setWhere, supportsSorting, toString`

Methods inherited from interface e4s.db.E4DBFilter_Intf
`isWhereDefined, resetWhere`

Field Detail

TABLENAME

public static final E4DBTableName TABLENAME

Name of the database table.

SVN_REVISION

public static final int SVN_REVISION

SVN Revision Code.

IS_CLIENT_DISTINCTIVE

public static final boolean IS_CLIENT_DISTINCTIVE

This table enables client distinction.

See Also:: E4Client, hasClientDistinctive(), Constant Field Values

IS_FREEDEF_POSSIBLE

public static final boolean IS_FREEDEF_POSSIBLE

This table enables freedefined database fields.

See Also:: E4DBFreeFieldName, canHaveFreeDefinedFields(), Constant Field Values

COL_ADDRESS01

public static final E4DBColumnName COL_ADDRESS01

STRING(60) Address Line #1

CI_ADDRESS01

public static final E4DBColumnInfo CI_ADDRESS01

COL_ADDRESS02

public static final E4DBColumnName COL_ADDRESS02

STRING(60) Address Line #2

CI_ADDRESS02

public static final E4DBColumnInfo CI_ADDRESS02

COL_BELONGS_TO

public static final E4DBColumnName COL_BELONGS_TO

E4CompanyId defined as e4s.util.E4Long Numeric, incremental ID for companies Company belongs to another company (can be null or empty) Member of index: BELONGS.

See Also:: E4CompanyId, IDX_BELONGS

CI_BELONGS_TO

public static final E4DBColumnInfo CI_BELONGS_TO

COL_CITY

public static final E4DBColumnName COL_CITY

STRING(60) City

CI_CITY

public static final E4DBColumnInfo CI_CITY

COL_COMPANY_ID

public static final E4DBColumnName COL_COMPANY_ID

E4CompanyId defined as e4s.util.E4Long Numeric, incremental ID for companies Primary key, company - ID Autoincremental value Member of index: COMPANY_ID.

See Also:: E4CompanyId, IDX_COMPANY_ID

CI_COMPANY_ID

public static final E4DBColumnInfo CI_COMPANY_ID

COL_COUNTRYCODE

public static final E4DBColumnName COL_COUNTRYCODE

CountryCode Countrycode

CI_COUNTRYCODE

public static final E4DBColumnInfo CI_COUNTRYCODE

COL_DATMOD

public static final E4DBColumnName COL_DATMOD

DATE Date modified

CI_DATMOD

public static final E4DBColumnInfo CI_DATMOD

COL_DATNEW

public static final E4DBColumnName COL_DATNEW

DATE Date created

CI_DATNEW

public static final E4DBColumnInfo CI_DATNEW

COL_EMAIL

public static final E4DBColumnName COL_EMAIL

STRING(60) Corporate eMail

CI_EMAIL

public static final E4DBColumnInfo CI_EMAIL

COL_GIS_LATITUDE

public static final E4DBColumnName COL_GIS_LATITUDE

FLOAT GIS Latitude

CI_GIS_LATITUDE

public static final E4DBColumnInfo CI_GIS_LATITUDE

COL_GIS_LONGITUDE

public static final E4DBColumnName COL_GIS_LONGITUDE

FLOAT GIS Longitude

CI_GIS_LONGITUDE

public static final E4DBColumnInfo CI_GIS_LONGITUDE

COL_GROUP_ID

public static final E4DBColumnName COL_GROUP_ID

E4CompanyGroup defined as e4s.util.E4String(16) Company Group Belongs to Group

See Also:: E4CompanyGroup

CI_GROUP_ID

public static final E4DBColumnInfo CI_GROUP_ID

COL_LOGIN_NAME

public static final E4DBColumnName COL_LOGIN_NAME

STRING(16) Name for login Member of index: LOGIN_NAME.

See Also:: IDX_LOGIN_NAME

CI_LOGIN_NAME

public static final E4DBColumnInfo CI_LOGIN_NAME

COL_NAME

public static final E4DBColumnName COL_NAME

STRING(60) Company Name

CI_NAME

public static final E4DBColumnInfo CI_NAME

COL_PHONE01

public static final E4DBColumnName COL_PHONE01

STRING(60) Phone #1

CI_PHONE01

public static final E4DBColumnInfo CI_PHONE01

COL_PHONE02

public static final E4DBColumnName COL_PHONE02

STRING(60) Phone #2

CI_PHONE02

public static final E4DBColumnInfo CI_PHONE02

COL_REM

public static final E4DBColumnName COL_REM

STRING(255) Remark

CI_REM

public static final E4DBColumnInfo CI_REM

COL_UID

public static final E4DBColumnName COL_UID

STRING(14) VAT Number

CI_UID

public static final E4DBColumnInfo CI_UID

COL_VALID_UNTIL

public static final E4DBColumnName COL_VALID_UNTIL

DATE Valid until

CI_VALID_UNTIL

public static final E4DBColumnInfo CI_VALID_UNTIL

COL_WWW

public static final E4DBColumnName COL_WWW

STRING(60) WWW Address

CI_WWW

public static final E4DBColumnInfo CI_WWW

COL_ZIPCODE

public static final E4DBColumnName COL_ZIPCODE

STRING(10) ZIP Code

CI_ZIPCODE

public static final E4DBColumnInfo CI_ZIPCODE

COLUMNS

public static final E4DBColumnInfo[] COLUMNS

Definition of database columns as array

See Also:: INDEXES

IDX_COMPANY_ID

public static final E4DBIndexInfo IDX_COMPANY_ID

Definition of index IDX_COMPANY_ID.

See Also:: COL_COMPANY_ID

IDX_LOGIN_NAME

public static final E4DBIndexInfo IDX_LOGIN_NAME

Definition of index IDX_LOGIN_NAME.

See Also:: COL_LOGIN_NAME

IDX_BELONGS

public static final E4DBIndexInfo IDX_BELONGS

Definition of index IDX_BELONGS.

See Also:: COL_BELONGS_TO

INDEXES

public static final E4DBIndexInfo[] INDEXES

Definition of table indexes.

See Also:: COLUMNS

Constructor Detail

T_E4S_COMPANY_Sel

public T_E4S_COMPANY_Sel(E4DBConnection_Intf dbcon,
                         E4ApplObj_Intf applobj)

Construct an object for selecting data from T_E4S_COMPANY using a database connection, the table uses client distinction.

Parameters:: dbcon - a database connection; applobj - an application object, containing client and other information
See Also:: E4ModuleImplementation.getApplObj(), E4ServletImplementation_Intf.getApplObj()

T_E4S_COMPANY_Sel

public T_E4S_COMPANY_Sel(E4ApplObj_Intf applobj)
                  throws E4DBException

Construct an object for selecting data from T_E4S_COMPANY using the default database connection, the table uses client distinction.

Parameters:: applobj - an application object, containing client and other information
Throws:: E4DBException
See Also:: E4ModuleImplementation.getApplObj(), E4ServletImplementation_Intf.getApplObj()

T_E4S_COMPANY_Sel

public T_E4S_COMPANY_Sel(T_E4S_COMPANY_Sel dbtable,
                         boolean copy_where)
                  throws E4DBException

Construct an object for selecting data from T_E4S_COMPANY using an existing T_E4S_COMPANY_Sel instance.

Parameters:: dbtable - a previous created T_E4S_COMPANY_Sel; copy_where - if true, the WHERE statement from the table is also copied to the new created table.
Throws:: E4DBException

Method Detail

or

public T_E4S_COMPANY_Sel.T_E4S_COMPANY_Or or()

makeInstance

public E4DBSelect_Intf makeInstance(boolean copy_where)
                             throws E4DBException

Create a new instance for T_E4S_COMPANY_Sel

Specified by:: makeInstance in interface E4DBSelect_Intf

Parameters:: copy_where - if true, the WHERE statement from the table is also copied to the new created table.
Throws:: E4DBException

E4ID

public E4ID E4ID()

hasClientDistinctive

public boolean hasClientDistinctive()

Get the state if data of this table will be distincted by E4Client. This is the case, if the E4ApplObj_Intf object was involved during construction of the object.

Specified by:: hasClientDistinctive in interface E4DBSelect_Intf

Returns:: true (client distinction for this table is enabled)
See Also:: E4Client, IS_CLIENT_DISTINCTIVE

canHaveFreeDefinedFields

public boolean canHaveFreeDefinedFields()

Check, if this table might have freedefined fields.

Specified by:: canHaveFreeDefinedFields in interface E4DBSelect_Intf

Returns:: true (table enables freedefined database fields)
See Also:: IS_FREEDEF_POSSIBLE

getModifyClass

public java.lang.Class getModifyClass()

Get the defined and generated class for the modifications, this means INSERT, UPDATE and DELETE, related to this table T_E4S_COMPANY.

Specified by:: getModifyClass in interface E4DBSelect_Intf

Returns:: class for the modifications
See Also:: E4DBModify_Intf, E4DBModifyFreefields_Intf, T_E4S_COMPANY_Mod

makeInstance_Modify

public E4DBModify_Intf makeInstance_Modify(boolean copy_where)
                                    throws E4DBException

Make an instance of the associated class for modification of database table entries. If an application object is defined, it will also be handled to the new created instance, as well as the database connection.

Specified by:: makeInstance_Modify in interface E4DBSelect_Intf

Parameters:: copy_where - if true, the WHERE statement from the table is also copied to the new created table.
Throws:: E4DBException
See Also:: makeInstance(boolean)

getObjectClass

public java.lang.Class getObjectClass()

Get the defined and generated class for the data-object related to this table.

Specified by:: getObjectClass in interface E4DBSelect_Intf

Returns:: the data object class
See Also:: T_E4S_COMPANY_Obj

getColInfo

public E4DBColumnInfo[] getColInfo()

Get information about the columns defined for this database table.

Specified by:: getColInfo in interface E4DBSelect_Intf

Returns:: null if no columns are defined, an array of E4DBColumnType objects
See Also:: COLUMNS

getIdxInfo

public E4DBIndexInfo[] getIdxInfo()

Get information about the indexes defined for this database table.

Returns:: null if no index is defined, an array of E4DBIndexInfo objects
See Also:: INDEXES

getFirstPrimaryIndex

public E4DBIndexInfo getFirstPrimaryIndex()

Get the fields defined for the first unique index IDX_COMPANY_ID.

Specified by:: getFirstPrimaryIndex in interface E4DBSelect_Intf
Overrides:: getFirstPrimaryIndex in class E4DBSelect

Returns:: IDX_COMPANY_ID.

public boolean next()
             throws E4DBException

Fetch next record.

Specified by:: next in interface E4DBSelect_Intf
Overrides:: next in class E4DBSelect

Returns:: true, if a record is available
Throws:: E4DBException

get_CLIENT

public E4Client get_CLIENT()
                    throws E4DBException

Get value for client.

Returns:: the value for the client.
Throws:: E4DBException

get_ADDRESS01

public java.lang.String get_ADDRESS01()
                               throws E4DBException

Get value for column ADDRESS01. STRING(60) Address Line #1

Returns:: the database column value retrieved for field ADDRESS01
Throws:: E4DBException

get_ADDRESS02

public java.lang.String get_ADDRESS02()
                               throws E4DBException

Get value for column ADDRESS02. STRING(60) Address Line #2

Returns:: the database column value retrieved for field ADDRESS02
Throws:: E4DBException

get_BELONGS_TO

public E4CompanyId get_BELONGS_TO()
                           throws E4DBException

Get value for column BELONGS_TO. E4CompanyId defined as e4s.util.E4Long Numeric, incremental ID for companies Company belongs to another company (can be null or empty)

Returns:: the database column value retrieved for field BELONGS_TO
Throws:: E4DBException
See Also:: E4CompanyId

get_CITY

public java.lang.String get_CITY()
                          throws E4DBException

Get value for column CITY. STRING(60) City

Returns:: the database column value retrieved for field CITY
Throws:: E4DBException

get_COMPANY_ID

public E4CompanyId get_COMPANY_ID()
                           throws E4DBException

Get value for column COMPANY_ID. E4CompanyId defined as e4s.util.E4Long Numeric, incremental ID for companies Primary key, company - ID Autoincremental value

Returns:: the database column value retrieved for field COMPANY_ID
Throws:: E4DBException
See Also:: E4CompanyId

get_COUNTRYCODE

public CountryCode get_COUNTRYCODE()
                            throws E4DBException

Get value for column COUNTRYCODE. CountryCode Countrycode

Returns:: the database column value retrieved for field COUNTRYCODE
Throws:: E4DBException

get_DATMOD

public java.util.Date get_DATMOD()
                          throws E4DBException

Get value for column DATMOD. DATE Date modified

Returns:: the database column value retrieved for field DATMOD
Throws:: E4DBException

get_DATNEW

public java.util.Date get_DATNEW()
                          throws E4DBException

Get value for column DATNEW. DATE Date created

Returns:: the database column value retrieved for field DATNEW
Throws:: E4DBException

get_EMAIL

public java.lang.String get_EMAIL()
                           throws E4DBException

Get value for column EMAIL. STRING(60) Corporate eMail

Returns:: the database column value retrieved for field EMAIL
Throws:: E4DBException

get_GIS_LATITUDE

public float get_GIS_LATITUDE()
                       throws E4DBException

Get value for column GIS_LATITUDE. FLOAT GIS Latitude

Returns:: the database column value retrieved for field GIS_LATITUDE
Throws:: E4DBException

get_GIS_LONGITUDE

public float get_GIS_LONGITUDE()
                        throws E4DBException

Get value for column GIS_LONGITUDE. FLOAT GIS Longitude

Returns:: the database column value retrieved for field GIS_LONGITUDE
Throws:: E4DBException

get_GROUP_ID

public E4CompanyGroup get_GROUP_ID()
                            throws E4DBException

Get value for column GROUP_ID. E4CompanyGroup defined as e4s.util.E4String(16) Company Group Belongs to Group

Returns:: the database column value retrieved for field GROUP_ID
Throws:: E4DBException
See Also:: E4CompanyGroup

get_LOGIN_NAME

public java.lang.String get_LOGIN_NAME()
                                throws E4DBException

Get value for column LOGIN_NAME. STRING(16) Name for login

Returns:: the database column value retrieved for field LOGIN_NAME
Throws:: E4DBException

get_NAME

public java.lang.String get_NAME()
                          throws E4DBException

Get value for column NAME. STRING(60) Company Name

Returns:: the database column value retrieved for field NAME
Throws:: E4DBException

get_PHONE01

public java.lang.String get_PHONE01()
                             throws E4DBException

Get value for column PHONE01. STRING(60) Phone #1

Returns:: the database column value retrieved for field PHONE01
Throws:: E4DBException

get_PHONE02

public java.lang.String get_PHONE02()
                             throws E4DBException

Get value for column PHONE02. STRING(60) Phone #2

Returns:: the database column value retrieved for field PHONE02
Throws:: E4DBException

get_REM

public java.lang.String get_REM()
                         throws E4DBException

Get value for column REM. STRING(255) Remark

Returns:: the database column value retrieved for field REM
Throws:: E4DBException

get_UID

public java.lang.String get_UID()
                         throws E4DBException

Get value for column UID. STRING(14) VAT Number

Returns:: the database column value retrieved for field UID
Throws:: E4DBException

get_VALID_UNTIL

public java.util.Date get_VALID_UNTIL()
                               throws E4DBException

Get value for column VALID_UNTIL. DATE Valid until

Returns:: the database column value retrieved for field VALID_UNTIL
Throws:: E4DBException

get_WWW

public java.lang.String get_WWW()
                         throws E4DBException

Get value for column WWW. STRING(60) WWW Address

Returns:: the database column value retrieved for field WWW
Throws:: E4DBException

get_ZIPCODE

public java.lang.String get_ZIPCODE()
                             throws E4DBException

Get value for column ZIPCODE. STRING(10) ZIP Code

Returns:: the database column value retrieved for field ZIPCODE
Throws:: E4DBException

get

public T_E4S_COMPANY_Obj get(boolean readfreefields)
                      throws E4DBException

Get the data object for T_E4S_COMPANY with optionally reading freedefined values.

Parameters:: readfreefields - also include the freefields.
Returns:: the data object.
Throws:: E4DBException
See Also:: get(), E4DBObjectFreefields.get(e4s.db.freefield.E4DBFreeFieldName)

get

public T_E4S_COMPANY_Obj get()
                      throws E4DBException

Get the data object for T_E4S_COMPANY without reading freedefined values.

Parameters:: readfreefields - also include the freefields.
Returns:: the data object.
Throws:: E4DBException
See Also:: get(boolean)

getQuery

public E4PersistantVector getQuery()
                            throws E4DBException

E4DBSelect.executeQuery() and store elements of type T_E4S_COMPANY_Obj in a Vector. Perform a E4DBSelect.close() afterwards.

Throws:: E4DBException

getQuery

public E4PersistantVector getQuery(boolean includefreefields)
                            throws E4DBException

E4DBSelect.executeQuery() and store elements of type T_E4S_COMPANY_Obj in a Vector. Perform a E4DBSelect.close() afterwards.

Parameters:: includefreefields - if true, freefields are also read
Throws:: E4DBException

sort_ADDRESS01

public void sort_ADDRESS01()

Sort ascending by column ADDRESS01. STRING(60) Address Line #1

sort_ADDRESS01_descending

public void sort_ADDRESS01_descending()

Sort descending by column ADDRESS01. STRING(60) Address Line #1

sort_ADDRESS02

public void sort_ADDRESS02()

Sort ascending by column ADDRESS02. STRING(60) Address Line #2

sort_ADDRESS02_descending

public void sort_ADDRESS02_descending()

Sort descending by column ADDRESS02. STRING(60) Address Line #2

sort_BELONGS_TO

public void sort_BELONGS_TO()

Sort ascending by column BELONGS_TO. E4CompanyId defined as e4s.util.E4Long Numeric, incremental ID for companies Company belongs to another company (can be null or empty)

See Also:: E4CompanyId

sort_BELONGS_TO_descending

public void sort_BELONGS_TO_descending()

Sort descending by column BELONGS_TO. E4CompanyId defined as e4s.util.E4Long Numeric, incremental ID for companies Company belongs to another company (can be null or empty)

See Also:: E4CompanyId

sort_CITY

public void sort_CITY()

Sort ascending by column CITY. STRING(60) City

sort_CITY_descending

public void sort_CITY_descending()

Sort descending by column CITY. STRING(60) City

sort_COMPANY_ID

public void sort_COMPANY_ID()

Sort ascending by column COMPANY_ID. E4CompanyId defined as e4s.util.E4Long Numeric, incremental ID for companies Primary key, company - ID Autoincremental value

See Also:: E4CompanyId

sort_COMPANY_ID_descending

public void sort_COMPANY_ID_descending()

Sort descending by column COMPANY_ID. E4CompanyId defined as e4s.util.E4Long Numeric, incremental ID for companies Primary key, company - ID Autoincremental value

See Also:: E4CompanyId

sort_COUNTRYCODE

public void sort_COUNTRYCODE()

Sort ascending by column COUNTRYCODE. CountryCode Countrycode

sort_COUNTRYCODE_descending

public void sort_COUNTRYCODE_descending()

Sort descending by column COUNTRYCODE. CountryCode Countrycode

sort_DATMOD

public void sort_DATMOD()

Sort ascending by column DATMOD. DATE Date modified

sort_DATMOD_descending

public void sort_DATMOD_descending()

Sort descending by column DATMOD. DATE Date modified

sort_DATNEW

public void sort_DATNEW()

Sort ascending by column DATNEW. DATE Date created

sort_DATNEW_descending

public void sort_DATNEW_descending()

Sort descending by column DATNEW. DATE Date created

sort_EMAIL

public void sort_EMAIL()

Sort ascending by column EMAIL. STRING(60) Corporate eMail

sort_EMAIL_descending

public void sort_EMAIL_descending()

Sort descending by column EMAIL. STRING(60) Corporate eMail

sort_GIS_LATITUDE

public void sort_GIS_LATITUDE()

Sort ascending by column GIS_LATITUDE. FLOAT GIS Latitude

sort_GIS_LATITUDE_descending

public void sort_GIS_LATITUDE_descending()

Sort descending by column GIS_LATITUDE. FLOAT GIS Latitude

sort_GIS_LONGITUDE

public void sort_GIS_LONGITUDE()

Sort ascending by column GIS_LONGITUDE. FLOAT GIS Longitude

sort_GIS_LONGITUDE_descending

public void sort_GIS_LONGITUDE_descending()

Sort descending by column GIS_LONGITUDE. FLOAT GIS Longitude

sort_GROUP_ID

public void sort_GROUP_ID()

Sort ascending by column GROUP_ID. E4CompanyGroup defined as e4s.util.E4String(16) Company Group Belongs to Group

See Also:: E4CompanyGroup

sort_GROUP_ID_descending

public void sort_GROUP_ID_descending()

Sort descending by column GROUP_ID. E4CompanyGroup defined as e4s.util.E4String(16) Company Group Belongs to Group

See Also:: E4CompanyGroup

sort_LOGIN_NAME

public void sort_LOGIN_NAME()

Sort ascending by column LOGIN_NAME. STRING(16) Name for login

sort_LOGIN_NAME_descending

public void sort_LOGIN_NAME_descending()

Sort descending by column LOGIN_NAME. STRING(16) Name for login

sort_NAME

public void sort_NAME()

Sort ascending by column NAME. STRING(60) Company Name

sort_NAME_descending

public void sort_NAME_descending()

Sort descending by column NAME. STRING(60) Company Name

sort_PHONE01

public void sort_PHONE01()

Sort ascending by column PHONE01. STRING(60) Phone #1

sort_PHONE01_descending

public void sort_PHONE01_descending()

Sort descending by column PHONE01. STRING(60) Phone #1

sort_PHONE02

public void sort_PHONE02()

Sort ascending by column PHONE02. STRING(60) Phone #2

sort_PHONE02_descending

public void sort_PHONE02_descending()

Sort descending by column PHONE02. STRING(60) Phone #2

sort_REM

public void sort_REM()

Sort ascending by column REM. STRING(255) Remark

sort_REM_descending

public void sort_REM_descending()

Sort descending by column REM. STRING(255) Remark

sort_UID

public void sort_UID()

Sort ascending by column UID. STRING(14) VAT Number

sort_UID_descending

public void sort_UID_descending()

Sort descending by column UID. STRING(14) VAT Number

sort_VALID_UNTIL

public void sort_VALID_UNTIL()

Sort ascending by column VALID_UNTIL. DATE Valid until

sort_VALID_UNTIL_descending

public void sort_VALID_UNTIL_descending()

Sort descending by column VALID_UNTIL. DATE Valid until

sort_WWW

public void sort_WWW()

Sort ascending by column WWW. STRING(60) WWW Address

sort_WWW_descending

public void sort_WWW_descending()

Sort descending by column WWW. STRING(60) WWW Address

sort_ZIPCODE

public void sort_ZIPCODE()

Sort ascending by column ZIPCODE. STRING(10) ZIP Code

sort_ZIPCODE_descending

public void sort_ZIPCODE_descending()

Sort descending by column ZIPCODE. STRING(10) ZIP Code

where_ADDRESS01

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

Define a filter (AND-ed WHERE) for column ADDRESS01. STRING(60) Address Line #1

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

where_ADDRESS01

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

Define a filter (AND-ed WHERE with operator) for column ADDRESS01. STRING(60) Address Line #1

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

where_ADDRESS01_in

public void where_ADDRESS01_in(java.lang.String[] filter)
                        throws E4DBException

Define a IN-filter (AND-ed WHERE) for column ADDRESS01. STRING(60) Address Line #1

Throws:: E4DBException

where_ADDRESS01_not_in

public void where_ADDRESS01_not_in(java.lang.String[] filter)
                            throws E4DBException

Define a NOT-IN-filter (AND-ed WHERE) for column ADDRESS01. STRING(60) Address Line #1

Throws:: E4DBException

where_ADDRESS01_isNull

public void where_ADDRESS01_isNull()
                            throws E4DBException

Define a is-null filter (AND-ed WHERE) for column ADDRESS01. STRING(60) Address Line #1

Throws:: E4DBException

where_ADDRESS01_isNotNull

public void where_ADDRESS01_isNotNull()
                               throws E4DBException

Define a is-NOT-null filter (AND-ed WHERE) for column ADDRESS01. STRING(60) Address Line #1

Throws:: E4DBException

where_ADDRESS01_in

public void where_ADDRESS01_in(E4DBSelectDistinct filter)
                        throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) ADDRESS01. STRING(60) Address Line #1

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

where_ADDRESS01_notin

public void where_ADDRESS01_notin(E4DBSelectDistinct filter)
                           throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) ADDRESS01. STRING(60) Address Line #1

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

where_ADDRESS01_isEmpty

public void where_ADDRESS01_isEmpty()
                             throws E4DBException

Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column ADDRESS01. STRING(60) Address Line #1

Throws:: E4DBException

where_ADDRESS01_isNotEmpty

public void where_ADDRESS01_isNotEmpty()
                                throws E4DBException

Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column ADDRESS01. STRING(60) Address Line #1

Throws:: E4DBException

where_ADDRESS02

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

Define a filter (AND-ed WHERE) for column ADDRESS02. STRING(60) Address Line #2

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

where_ADDRESS02

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

Define a filter (AND-ed WHERE with operator) for column ADDRESS02. STRING(60) Address Line #2

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

where_ADDRESS02_in

public void where_ADDRESS02_in(java.lang.String[] filter)
                        throws E4DBException

Define a IN-filter (AND-ed WHERE) for column ADDRESS02. STRING(60) Address Line #2

Throws:: E4DBException

where_ADDRESS02_not_in

public void where_ADDRESS02_not_in(java.lang.String[] filter)
                            throws E4DBException

Define a NOT-IN-filter (AND-ed WHERE) for column ADDRESS02. STRING(60) Address Line #2

Throws:: E4DBException

where_ADDRESS02_isNull

public void where_ADDRESS02_isNull()
                            throws E4DBException

Define a is-null filter (AND-ed WHERE) for column ADDRESS02. STRING(60) Address Line #2

Throws:: E4DBException

where_ADDRESS02_isNotNull

public void where_ADDRESS02_isNotNull()
                               throws E4DBException

Define a is-NOT-null filter (AND-ed WHERE) for column ADDRESS02. STRING(60) Address Line #2

Throws:: E4DBException

where_ADDRESS02_in

public void where_ADDRESS02_in(E4DBSelectDistinct filter)
                        throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) ADDRESS02. STRING(60) Address Line #2

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

where_ADDRESS02_notin

public void where_ADDRESS02_notin(E4DBSelectDistinct filter)
                           throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) ADDRESS02. STRING(60) Address Line #2

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

where_ADDRESS02_isEmpty

public void where_ADDRESS02_isEmpty()
                             throws E4DBException

Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column ADDRESS02. STRING(60) Address Line #2

Throws:: E4DBException

where_ADDRESS02_isNotEmpty

public void where_ADDRESS02_isNotEmpty()
                                throws E4DBException

Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column ADDRESS02. STRING(60) Address Line #2

Throws:: E4DBException

where_BELONGS_TO

public void where_BELONGS_TO(E4CompanyId filter)
                      throws E4DBException

Define a filter (AND-ed WHERE) for column BELONGS_TO. E4CompanyId defined as e4s.util.E4Long Numeric, incremental ID for companies Company belongs to another company (can be null or empty)

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

where_BELONGS_TO

public void where_BELONGS_TO(int operator,
                             E4CompanyId filter)
                      throws E4DBException

Define a filter (AND-ed WHERE with operator) for column BELONGS_TO. E4CompanyId defined as e4s.util.E4Long Numeric, incremental ID for companies Company belongs to another company (can be null or empty)

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

where_BELONGS_TO_in

public void where_BELONGS_TO_in(E4DBSelectDistinct filter)
                         throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) BELONGS_TO. E4CompanyId defined as e4s.util.E4Long Numeric, incremental ID for companies Company belongs to another company (can be null or empty)

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

where_BELONGS_TO_notin

public void where_BELONGS_TO_notin(E4DBSelectDistinct filter)
                            throws E4DBException

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

where_CITY

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

Define a filter (AND-ed WHERE) for column CITY. STRING(60) City

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

where_CITY

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

Define a filter (AND-ed WHERE with operator) for column CITY. STRING(60) City

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

where_CITY_in

public void where_CITY_in(java.lang.String[] filter)
                   throws E4DBException

Define a IN-filter (AND-ed WHERE) for column CITY. STRING(60) City

Throws:: E4DBException

where_CITY_not_in

public void where_CITY_not_in(java.lang.String[] filter)
                       throws E4DBException

Define a NOT-IN-filter (AND-ed WHERE) for column CITY. STRING(60) City

Throws:: E4DBException

where_CITY_isNull

public void where_CITY_isNull()
                       throws E4DBException

Define a is-null filter (AND-ed WHERE) for column CITY. STRING(60) City

Throws:: E4DBException

where_CITY_isNotNull

public void where_CITY_isNotNull()
                          throws E4DBException

Define a is-NOT-null filter (AND-ed WHERE) for column CITY. STRING(60) City

Throws:: E4DBException

where_CITY_in

public void where_CITY_in(E4DBSelectDistinct filter)
                   throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) CITY. STRING(60) City

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

where_CITY_notin

public void where_CITY_notin(E4DBSelectDistinct filter)
                      throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) CITY. STRING(60) City

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

where_CITY_isEmpty

public void where_CITY_isEmpty()
                        throws E4DBException

Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column CITY. STRING(60) City

Throws:: E4DBException

where_CITY_isNotEmpty

public void where_CITY_isNotEmpty()
                           throws E4DBException

Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column CITY. STRING(60) City

Throws:: E4DBException

where_COMPANY_ID

public void where_COMPANY_ID(E4CompanyId filter)
                      throws E4DBException

Define a filter (AND-ed WHERE) for column COMPANY_ID. E4CompanyId defined as e4s.util.E4Long Numeric, incremental ID for companies Primary key, company - ID Autoincremental value

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

where_COMPANY_ID

public void where_COMPANY_ID(int operator,
                             E4CompanyId filter)
                      throws E4DBException

Define a filter (AND-ed WHERE with operator) for column COMPANY_ID. E4CompanyId defined as e4s.util.E4Long Numeric, incremental ID for companies Primary key, company - ID Autoincremental value

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

where_COMPANY_ID_in

public void where_COMPANY_ID_in(E4DBSelectDistinct filter)
                         throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) COMPANY_ID. E4CompanyId defined as e4s.util.E4Long Numeric, incremental ID for companies Primary key, company - ID Autoincremental value

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

where_COMPANY_ID_notin

public void where_COMPANY_ID_notin(E4DBSelectDistinct filter)
                            throws E4DBException

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

where_COUNTRYCODE

public void where_COUNTRYCODE(CountryCode filter)
                       throws E4DBException

Define a filter (AND-ed WHERE) for column COUNTRYCODE. CountryCode Countrycode

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

where_COUNTRYCODE

public void where_COUNTRYCODE(int operator,
                              CountryCode filter)
                       throws E4DBException

Define a filter (AND-ed WHERE with operator) for column COUNTRYCODE. CountryCode Countrycode

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

where_COUNTRYCODE_like

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

Define a filter (AND-ed WHERE) for column COUNTRYCODE. CountryCode Countrycode

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

where_COUNTRYCODE_in

public void where_COUNTRYCODE_in(CountryCode[] filter)
                          throws E4DBException

Define a IN-filter (AND-ed WHERE) for column COUNTRYCODE. CountryCode Countrycode

Throws:: E4DBException

where_COUNTRYCODE_not_in

public void where_COUNTRYCODE_not_in(CountryCode[] filter)
                              throws E4DBException

Define a NOT-IN-filter (AND-ed WHERE) for column COUNTRYCODE. CountryCode Countrycode

Throws:: E4DBException

where_COUNTRYCODE_isNull

public void where_COUNTRYCODE_isNull()
                              throws E4DBException

Define a is-null filter (AND-ed WHERE) for column COUNTRYCODE. CountryCode Countrycode

Throws:: E4DBException

where_COUNTRYCODE_isNotNull

public void where_COUNTRYCODE_isNotNull()
                                 throws E4DBException

Define a is-NOT-null filter (AND-ed WHERE) for column COUNTRYCODE. CountryCode Countrycode

Throws:: E4DBException

where_COUNTRYCODE_in

public void where_COUNTRYCODE_in(E4DBSelectDistinct filter)
                          throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) COUNTRYCODE. CountryCode Countrycode

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

where_COUNTRYCODE_notin

public void where_COUNTRYCODE_notin(E4DBSelectDistinct filter)
                             throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) COUNTRYCODE. CountryCode Countrycode

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

where_COUNTRYCODE_isEmpty

public void where_COUNTRYCODE_isEmpty()
                               throws E4DBException

Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column COUNTRYCODE. CountryCode Countrycode

Throws:: E4DBException

where_COUNTRYCODE_isNotEmpty

public void where_COUNTRYCODE_isNotEmpty()
                                  throws E4DBException

Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column COUNTRYCODE. CountryCode Countrycode

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_EMAIL

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

Define a filter (AND-ed WHERE) for column EMAIL. STRING(60) Corporate eMail

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

where_EMAIL

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

Define a filter (AND-ed WHERE with operator) for column EMAIL. STRING(60) Corporate eMail

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

where_EMAIL_in

public void where_EMAIL_in(java.lang.String[] filter)
                    throws E4DBException

Define a IN-filter (AND-ed WHERE) for column EMAIL. STRING(60) Corporate eMail

Throws:: E4DBException

where_EMAIL_not_in

public void where_EMAIL_not_in(java.lang.String[] filter)
                        throws E4DBException

Define a NOT-IN-filter (AND-ed WHERE) for column EMAIL. STRING(60) Corporate eMail

Throws:: E4DBException

where_EMAIL_isNull

public void where_EMAIL_isNull()
                        throws E4DBException

Define a is-null filter (AND-ed WHERE) for column EMAIL. STRING(60) Corporate eMail

Throws:: E4DBException

where_EMAIL_isNotNull

public void where_EMAIL_isNotNull()
                           throws E4DBException

Define a is-NOT-null filter (AND-ed WHERE) for column EMAIL. STRING(60) Corporate eMail

Throws:: E4DBException

where_EMAIL_in

public void where_EMAIL_in(E4DBSelectDistinct filter)
                    throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) EMAIL. STRING(60) Corporate eMail

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

where_EMAIL_notin

public void where_EMAIL_notin(E4DBSelectDistinct filter)
                       throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) EMAIL. STRING(60) Corporate eMail

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

where_EMAIL_isEmpty

public void where_EMAIL_isEmpty()
                         throws E4DBException

Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column EMAIL. STRING(60) Corporate eMail

Throws:: E4DBException

where_EMAIL_isNotEmpty

public void where_EMAIL_isNotEmpty()
                            throws E4DBException

Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column EMAIL. STRING(60) Corporate eMail

Throws:: E4DBException

where_GIS_LATITUDE

public void where_GIS_LATITUDE(float filter)
                        throws E4DBException

Define a filter (AND-ed WHERE) for column GIS_LATITUDE. FLOAT GIS Latitude

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

where_GIS_LATITUDE

public void where_GIS_LATITUDE(int operator,
                               float filter)
                        throws E4DBException

Define a filter (AND-ed WHERE with operator) for column GIS_LATITUDE. FLOAT GIS Latitude

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

where_GIS_LONGITUDE

public void where_GIS_LONGITUDE(float filter)
                         throws E4DBException

Define a filter (AND-ed WHERE) for column GIS_LONGITUDE. FLOAT GIS Longitude

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

where_GIS_LONGITUDE

public void where_GIS_LONGITUDE(int operator,
                                float filter)
                         throws E4DBException

Define a filter (AND-ed WHERE with operator) for column GIS_LONGITUDE. FLOAT GIS Longitude

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

where_GROUP_ID

public void where_GROUP_ID(E4CompanyGroup filter)
                    throws E4DBException

Define a filter (AND-ed WHERE) for column GROUP_ID. E4CompanyGroup defined as e4s.util.E4String(16) Company Group Belongs to Group

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

where_GROUP_ID

public void where_GROUP_ID(int operator,
                           E4CompanyGroup filter)
                    throws E4DBException

Define a filter (AND-ed WHERE with operator) for column GROUP_ID. E4CompanyGroup defined as e4s.util.E4String(16) Company Group Belongs to Group

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

where_GROUP_ID_like

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

Define a filter (AND-ed WHERE) for column GROUP_ID. E4CompanyGroup defined as e4s.util.E4String(16) Company Group Belongs to Group

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

where_GROUP_ID_in

public void where_GROUP_ID_in(E4CompanyGroup[] filter)
                       throws E4DBException

Define a IN-filter (AND-ed WHERE) for column GROUP_ID. E4CompanyGroup defined as e4s.util.E4String(16) Company Group Belongs to Group

Throws:: E4DBException
See Also:: E4CompanyGroup

where_GROUP_ID_not_in

public void where_GROUP_ID_not_in(E4CompanyGroup[] filter)
                           throws E4DBException

Define a NOT-IN-filter (AND-ed WHERE) for column GROUP_ID. E4CompanyGroup defined as e4s.util.E4String(16) Company Group Belongs to Group

Throws:: E4DBException
See Also:: E4CompanyGroup

where_GROUP_ID_isNull

public void where_GROUP_ID_isNull()
                           throws E4DBException

Define a is-null filter (AND-ed WHERE) for column GROUP_ID. E4CompanyGroup defined as e4s.util.E4String(16) Company Group Belongs to Group

Throws:: E4DBException
See Also:: E4CompanyGroup

where_GROUP_ID_isNotNull

public void where_GROUP_ID_isNotNull()
                              throws E4DBException

Define a is-NOT-null filter (AND-ed WHERE) for column GROUP_ID. E4CompanyGroup defined as e4s.util.E4String(16) Company Group Belongs to Group

Throws:: E4DBException
See Also:: E4CompanyGroup

where_GROUP_ID_in

public void where_GROUP_ID_in(E4DBSelectDistinct filter)
                       throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) GROUP_ID. E4CompanyGroup defined as e4s.util.E4String(16) Company Group Belongs to Group

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

where_GROUP_ID_notin

public void where_GROUP_ID_notin(E4DBSelectDistinct filter)
                          throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) GROUP_ID. E4CompanyGroup defined as e4s.util.E4String(16) Company Group Belongs to Group

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

where_GROUP_ID_isEmpty

public void where_GROUP_ID_isEmpty()
                            throws E4DBException

Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column GROUP_ID. E4CompanyGroup defined as e4s.util.E4String(16) Company Group Belongs to Group

Throws:: E4DBException
See Also:: E4CompanyGroup

where_GROUP_ID_isNotEmpty

public void where_GROUP_ID_isNotEmpty()
                               throws E4DBException

Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column GROUP_ID. E4CompanyGroup defined as e4s.util.E4String(16) Company Group Belongs to Group

Throws:: E4DBException
See Also:: E4CompanyGroup

where_LOGIN_NAME

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

Define a filter (AND-ed WHERE) for column LOGIN_NAME. STRING(16) Name for login

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

where_LOGIN_NAME

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

Define a filter (AND-ed WHERE with operator) for column LOGIN_NAME. STRING(16) Name for login

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

where_LOGIN_NAME_in

public void where_LOGIN_NAME_in(java.lang.String[] filter)
                         throws E4DBException

Define a IN-filter (AND-ed WHERE) for column LOGIN_NAME. STRING(16) Name for login

Throws:: E4DBException

where_LOGIN_NAME_not_in

public void where_LOGIN_NAME_not_in(java.lang.String[] filter)
                             throws E4DBException

Define a NOT-IN-filter (AND-ed WHERE) for column LOGIN_NAME. STRING(16) Name for login

Throws:: E4DBException

where_LOGIN_NAME_isNull

public void where_LOGIN_NAME_isNull()
                             throws E4DBException

Define a is-null filter (AND-ed WHERE) for column LOGIN_NAME. STRING(16) Name for login

Throws:: E4DBException

where_LOGIN_NAME_isNotNull

public void where_LOGIN_NAME_isNotNull()
                                throws E4DBException

Define a is-NOT-null filter (AND-ed WHERE) for column LOGIN_NAME. STRING(16) Name for login

Throws:: E4DBException

where_LOGIN_NAME_in

public void where_LOGIN_NAME_in(E4DBSelectDistinct filter)
                         throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) LOGIN_NAME. STRING(16) Name for login

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

where_LOGIN_NAME_notin

public void where_LOGIN_NAME_notin(E4DBSelectDistinct filter)
                            throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) LOGIN_NAME. STRING(16) Name for login

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

where_LOGIN_NAME_isEmpty

public void where_LOGIN_NAME_isEmpty()
                              throws E4DBException

Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column LOGIN_NAME. STRING(16) Name for login

Throws:: E4DBException

where_LOGIN_NAME_isNotEmpty

public void where_LOGIN_NAME_isNotEmpty()
                                 throws E4DBException

Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column LOGIN_NAME. STRING(16) Name for login

Throws:: E4DBException

where_NAME

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

Define a filter (AND-ed WHERE) for column NAME. STRING(60) Company Name

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

where_NAME

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

Define a filter (AND-ed WHERE with operator) for column NAME. STRING(60) Company Name

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

where_NAME_in

public void where_NAME_in(java.lang.String[] filter)
                   throws E4DBException

Define a IN-filter (AND-ed WHERE) for column NAME. STRING(60) Company Name

Throws:: E4DBException

where_NAME_not_in

public void where_NAME_not_in(java.lang.String[] filter)
                       throws E4DBException

Define a NOT-IN-filter (AND-ed WHERE) for column NAME. STRING(60) Company Name

Throws:: E4DBException

where_NAME_isNull

public void where_NAME_isNull()
                       throws E4DBException

Define a is-null filter (AND-ed WHERE) for column NAME. STRING(60) Company Name

Throws:: E4DBException

where_NAME_isNotNull

public void where_NAME_isNotNull()
                          throws E4DBException

Define a is-NOT-null filter (AND-ed WHERE) for column NAME. STRING(60) Company Name

Throws:: E4DBException

where_NAME_in

public void where_NAME_in(E4DBSelectDistinct filter)
                   throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) NAME. STRING(60) Company Name

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

where_NAME_notin

public void where_NAME_notin(E4DBSelectDistinct filter)
                      throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) NAME. STRING(60) Company Name

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

where_NAME_isEmpty

public void where_NAME_isEmpty()
                        throws E4DBException

Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column NAME. STRING(60) Company Name

Throws:: E4DBException

where_NAME_isNotEmpty

public void where_NAME_isNotEmpty()
                           throws E4DBException

Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column NAME. STRING(60) Company Name

Throws:: E4DBException

where_PHONE01

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

Define a filter (AND-ed WHERE) for column PHONE01. STRING(60) Phone #1

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

where_PHONE01

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

Define a filter (AND-ed WHERE with operator) for column PHONE01. STRING(60) Phone #1

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

where_PHONE01_in

public void where_PHONE01_in(java.lang.String[] filter)
                      throws E4DBException

Define a IN-filter (AND-ed WHERE) for column PHONE01. STRING(60) Phone #1

Throws:: E4DBException

where_PHONE01_not_in

public void where_PHONE01_not_in(java.lang.String[] filter)
                          throws E4DBException

Define a NOT-IN-filter (AND-ed WHERE) for column PHONE01. STRING(60) Phone #1

Throws:: E4DBException

where_PHONE01_isNull

public void where_PHONE01_isNull()
                          throws E4DBException

Define a is-null filter (AND-ed WHERE) for column PHONE01. STRING(60) Phone #1

Throws:: E4DBException

where_PHONE01_isNotNull

public void where_PHONE01_isNotNull()
                             throws E4DBException

Define a is-NOT-null filter (AND-ed WHERE) for column PHONE01. STRING(60) Phone #1

Throws:: E4DBException

where_PHONE01_in

public void where_PHONE01_in(E4DBSelectDistinct filter)
                      throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) PHONE01. STRING(60) Phone #1

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

where_PHONE01_notin

public void where_PHONE01_notin(E4DBSelectDistinct filter)
                         throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) PHONE01. STRING(60) Phone #1

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

where_PHONE01_isEmpty

public void where_PHONE01_isEmpty()
                           throws E4DBException

Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column PHONE01. STRING(60) Phone #1

Throws:: E4DBException

where_PHONE01_isNotEmpty

public void where_PHONE01_isNotEmpty()
                              throws E4DBException

Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column PHONE01. STRING(60) Phone #1

Throws:: E4DBException

where_PHONE02

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

Define a filter (AND-ed WHERE) for column PHONE02. STRING(60) Phone #2

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

where_PHONE02

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

Define a filter (AND-ed WHERE with operator) for column PHONE02. STRING(60) Phone #2

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

where_PHONE02_in

public void where_PHONE02_in(java.lang.String[] filter)
                      throws E4DBException

Define a IN-filter (AND-ed WHERE) for column PHONE02. STRING(60) Phone #2

Throws:: E4DBException

where_PHONE02_not_in

public void where_PHONE02_not_in(java.lang.String[] filter)
                          throws E4DBException

Define a NOT-IN-filter (AND-ed WHERE) for column PHONE02. STRING(60) Phone #2

Throws:: E4DBException

where_PHONE02_isNull

public void where_PHONE02_isNull()
                          throws E4DBException

Define a is-null filter (AND-ed WHERE) for column PHONE02. STRING(60) Phone #2

Throws:: E4DBException

where_PHONE02_isNotNull

public void where_PHONE02_isNotNull()
                             throws E4DBException

Define a is-NOT-null filter (AND-ed WHERE) for column PHONE02. STRING(60) Phone #2

Throws:: E4DBException

where_PHONE02_in

public void where_PHONE02_in(E4DBSelectDistinct filter)
                      throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) PHONE02. STRING(60) Phone #2

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

where_PHONE02_notin

public void where_PHONE02_notin(E4DBSelectDistinct filter)
                         throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) PHONE02. STRING(60) Phone #2

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

where_PHONE02_isEmpty

public void where_PHONE02_isEmpty()
                           throws E4DBException

Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column PHONE02. STRING(60) Phone #2

Throws:: E4DBException

where_PHONE02_isNotEmpty

public void where_PHONE02_isNotEmpty()
                              throws E4DBException

Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column PHONE02. STRING(60) Phone #2

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_in

public void where_REM_in(java.lang.String[] filter)
                  throws E4DBException

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

Throws:: E4DBException

where_REM_not_in

public void where_REM_not_in(java.lang.String[] filter)
                      throws E4DBException

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

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_UID

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

Define a filter (AND-ed WHERE) for column UID. STRING(14) VAT Number

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

where_UID

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

Define a filter (AND-ed WHERE with operator) for column UID. STRING(14) VAT Number

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

where_UID_in

public void where_UID_in(java.lang.String[] filter)
                  throws E4DBException

Define a IN-filter (AND-ed WHERE) for column UID. STRING(14) VAT Number

Throws:: E4DBException

where_UID_not_in

public void where_UID_not_in(java.lang.String[] filter)
                      throws E4DBException

Define a NOT-IN-filter (AND-ed WHERE) for column UID. STRING(14) VAT Number

Throws:: E4DBException

where_UID_isNull

public void where_UID_isNull()
                      throws E4DBException

Define a is-null filter (AND-ed WHERE) for column UID. STRING(14) VAT Number

Throws:: E4DBException

where_UID_isNotNull

public void where_UID_isNotNull()
                         throws E4DBException

Define a is-NOT-null filter (AND-ed WHERE) for column UID. STRING(14) VAT Number

Throws:: E4DBException

where_UID_in

public void where_UID_in(E4DBSelectDistinct filter)
                  throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) UID. STRING(14) VAT Number

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

where_UID_notin

public void where_UID_notin(E4DBSelectDistinct filter)
                     throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) UID. STRING(14) VAT Number

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

where_UID_isEmpty

public void where_UID_isEmpty()
                       throws E4DBException

Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column UID. STRING(14) VAT Number

Throws:: E4DBException

where_UID_isNotEmpty

public void where_UID_isNotEmpty()
                          throws E4DBException

Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column UID. STRING(14) VAT Number

Throws:: E4DBException

where_VALID_UNTIL

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

Define a filter (AND-ed WHERE) for column VALID_UNTIL. DATE Valid until

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

where_VALID_UNTIL

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

Define a filter (AND-ed WHERE with operator) for column VALID_UNTIL. DATE Valid until

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

where_VALID_UNTIL_isNull

public void where_VALID_UNTIL_isNull()
                              throws E4DBException

Define a is-null filter (AND-ed WHERE) for column VALID_UNTIL. DATE Valid until

Throws:: E4DBException

where_VALID_UNTIL_isNotNull

public void where_VALID_UNTIL_isNotNull()
                                 throws E4DBException

Define a is-NOT-null filter (AND-ed WHERE) for column VALID_UNTIL. DATE Valid until

Throws:: E4DBException

where_VALID_UNTIL_in

public void where_VALID_UNTIL_in(E4DBSelectDistinct filter)
                          throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) VALID_UNTIL. DATE Valid until

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

where_VALID_UNTIL_notin

public void where_VALID_UNTIL_notin(E4DBSelectDistinct filter)
                             throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) VALID_UNTIL. DATE Valid until

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

where_VALID_UNTIL_isEmpty

public void where_VALID_UNTIL_isEmpty()
                               throws E4DBException

Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column VALID_UNTIL. DATE Valid until

Throws:: E4DBException

where_VALID_UNTIL_isNotEmpty

public void where_VALID_UNTIL_isNotEmpty()
                                  throws E4DBException

Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column VALID_UNTIL. DATE Valid until

Throws:: E4DBException

where_WWW

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

Define a filter (AND-ed WHERE) for column WWW. STRING(60) WWW Address

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

where_WWW

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

Define a filter (AND-ed WHERE with operator) for column WWW. STRING(60) WWW Address

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

where_WWW_in

public void where_WWW_in(java.lang.String[] filter)
                  throws E4DBException

Define a IN-filter (AND-ed WHERE) for column WWW. STRING(60) WWW Address

Throws:: E4DBException

where_WWW_not_in

public void where_WWW_not_in(java.lang.String[] filter)
                      throws E4DBException

Define a NOT-IN-filter (AND-ed WHERE) for column WWW. STRING(60) WWW Address

Throws:: E4DBException

where_WWW_isNull

public void where_WWW_isNull()
                      throws E4DBException

Define a is-null filter (AND-ed WHERE) for column WWW. STRING(60) WWW Address

Throws:: E4DBException

where_WWW_isNotNull

public void where_WWW_isNotNull()
                         throws E4DBException

Define a is-NOT-null filter (AND-ed WHERE) for column WWW. STRING(60) WWW Address

Throws:: E4DBException

where_WWW_in

public void where_WWW_in(E4DBSelectDistinct filter)
                  throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) WWW. STRING(60) WWW Address

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

where_WWW_notin

public void where_WWW_notin(E4DBSelectDistinct filter)
                     throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) WWW. STRING(60) WWW Address

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

where_WWW_isEmpty

public void where_WWW_isEmpty()
                       throws E4DBException

Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column WWW. STRING(60) WWW Address

Throws:: E4DBException

where_WWW_isNotEmpty

public void where_WWW_isNotEmpty()
                          throws E4DBException

Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column WWW. STRING(60) WWW Address

Throws:: E4DBException

where_ZIPCODE

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

Define a filter (AND-ed WHERE) for column ZIPCODE. STRING(10) ZIP Code

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

where_ZIPCODE

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

Define a filter (AND-ed WHERE with operator) for column ZIPCODE. STRING(10) ZIP Code

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

where_ZIPCODE_in

public void where_ZIPCODE_in(java.lang.String[] filter)
                      throws E4DBException

Define a IN-filter (AND-ed WHERE) for column ZIPCODE. STRING(10) ZIP Code

Throws:: E4DBException

where_ZIPCODE_not_in

public void where_ZIPCODE_not_in(java.lang.String[] filter)
                          throws E4DBException

Define a NOT-IN-filter (AND-ed WHERE) for column ZIPCODE. STRING(10) ZIP Code

Throws:: E4DBException

where_ZIPCODE_isNull

public void where_ZIPCODE_isNull()
                          throws E4DBException

Define a is-null filter (AND-ed WHERE) for column ZIPCODE. STRING(10) ZIP Code

Throws:: E4DBException

where_ZIPCODE_isNotNull

public void where_ZIPCODE_isNotNull()
                             throws E4DBException

Define a is-NOT-null filter (AND-ed WHERE) for column ZIPCODE. STRING(10) ZIP Code

Throws:: E4DBException

where_ZIPCODE_in

public void where_ZIPCODE_in(E4DBSelectDistinct filter)
                      throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) ZIPCODE. STRING(10) ZIP Code

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

where_ZIPCODE_notin

public void where_ZIPCODE_notin(E4DBSelectDistinct filter)
                         throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) ZIPCODE. STRING(10) ZIP Code

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

where_ZIPCODE_isEmpty

public void where_ZIPCODE_isEmpty()
                           throws E4DBException

Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column ZIPCODE. STRING(10) ZIP Code

Throws:: E4DBException

where_ZIPCODE_isNotEmpty

public void where_ZIPCODE_isNotEmpty()
                              throws E4DBException

Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column ZIPCODE. STRING(10) ZIP Code

Throws:: E4DBException

_getReferenceDelete

public static E4DBReference[] _getReferenceDelete(E4DBColumnName cName)
                                           throws E4DBException

Throws:: E4DBException

getReferenceDelete

public E4DBReference[] getReferenceDelete(E4DBColumnName cName)
                                   throws E4DBException

Description copied from class: E4DBSelect

Return null.

Specified by:: getReferenceDelete in interface E4DBSelect_Intf
Overrides:: getReferenceDelete in class E4DBSelect

Parameters:: cName - the column which references needs to be deleted (the "master")
Returns:: null, if no referential delete is defined for that column, or a list of references (the "detail")
Throws:: E4DBException

_getReferenceLookup

public static E4DBReference[] _getReferenceLookup(E4DBColumnName cName)
                                           throws E4DBException

Throws:: E4DBException

getReferenceLookup

public E4DBReference[] getReferenceLookup(E4DBColumnName cName)
                                   throws E4DBException

Description copied from class: E4DBSelect

Return null.

Specified by:: getReferenceLookup in interface E4DBSelect_Intf
Overrides:: getReferenceLookup in class E4DBSelect

Parameters:: cName - the column which references needs to be deleted (the "master")
Returns:: null, if no referential lookup is defined for that column, or a list of references (the "detail")
Throws:: E4DBException

createFIELDSET

public E4Fieldset createFIELDSET(FORM form)

Specified by:: createFIELDSET in interface E4DBSelect_Intf

createFIELDSET

public static E4Fieldset createFIELDSET()

createFIELDSET

public static E4Fieldset createFIELDSET(E4ApplObj_Intf applobj)

get_FIELDSET

public E4Fieldset get_FIELDSET()
                        throws E4DBException

Throws:: E4DBException

get_FIELDSET

public E4Fieldset get_FIELDSET(FORM form)
                        throws E4DBException

Specified by:: get_FIELDSET in interface E4DBSelect_Intf

Throws:: E4DBException

get

public void get(E4Fieldset fieldset)
         throws E4DBException

Specified by:: get in interface E4DBSelect_Intf

Throws:: E4DBException

getUsage

public E4DBTypeUsage[] getUsage(E4DBColumnName colname)

For the case, that the specified column is a e4s defined type (e.g. E4Long, E4String) this function returns an array in which tables and columns this type is used, except the current table and the specified column.

Specified by:: getUsage in interface E4DBSelect_Intf

Parameters:: colname - the column to be checked
See Also:: E4DBIntegrity

isEmpty

public static boolean isEmpty(E4DBConnection_Intf con,
                              E4ApplObj_Intf applobj)
                       throws E4DBException

Check, if this table contains any data.

Parameters:: con - the connection; applobj - the application object containing the Client to be checked
Throws:: E4DBException

find_COMPANY_ID

public static T_E4S_COMPANY_Obj find_COMPANY_ID(E4ApplObj_Intf appobj,
                                                E4CompanyId qCOMPANY_ID)
                                         throws E4DBException

Find a record associates with unique index 1 (COMPANY_ID).

Parameters:: appobj - the current application object containing client informations; qCOMPANY_ID - query Primary key, company - ID
Throws:: E4DBException

find_COMPANY_ID

public static T_E4S_COMPANY_Obj find_COMPANY_ID(E4ApplObj_Intf appobj,
                                                E4CompanyId qCOMPANY_ID,
                                                boolean readfreefields)
                                         throws E4DBException

Find a record associates with unique index 1 (COMPANY_ID) and read associated freefield values.

Parameters:: appobj - the current application object containing client informations; qCOMPANY_ID - query Primary key, company - ID; readfreefields - read also the freefield values if true
Throws:: E4DBException

find_COMPANY_ID

public static T_E4S_COMPANY_Obj find_COMPANY_ID(E4DBConnection_Intf con,
                                                E4ApplObj_Intf appobj,
                                                E4CompanyId qCOMPANY_ID)
                                         throws E4DBException

Find a record associates with index 1 (COMPANY_ID).

Parameters:: con - the database connection; appobj - the current application object containing client informations; qCOMPANY_ID - query Primary key, company - ID
Throws:: E4DBException

find_COMPANY_ID

public static T_E4S_COMPANY_Obj find_COMPANY_ID(E4DBConnection_Intf con,
                                                E4ApplObj_Intf appobj,
                                                E4CompanyId qCOMPANY_ID,
                                                boolean readfreefields)
                                         throws E4DBException

Find a record associates with index 1 (COMPANY_ID) and read associated freefield values.

Parameters:: con - the database connection; appobj - the current application object containing client informations; qCOMPANY_ID - query Primary key, company - ID; readfreefields - read also the freefield values if true
Throws:: E4DBException

find_LOGIN_NAME

public static T_E4S_COMPANY_Obj find_LOGIN_NAME(E4ApplObj_Intf appobj,
                                                java.lang.String qLOGIN_NAME)
                                         throws E4DBException

Find a record associates with unique index 2 (LOGIN_NAME).

Parameters:: appobj - the current application object containing client informations; qLOGIN_NAME - query Name for login
Throws:: E4DBException

find_LOGIN_NAME

public static T_E4S_COMPANY_Obj find_LOGIN_NAME(E4ApplObj_Intf appobj,
                                                java.lang.String qLOGIN_NAME,
                                                boolean readfreefields)
                                         throws E4DBException

Find a record associates with unique index 2 (LOGIN_NAME) and read associated freefield values.

Parameters:: appobj - the current application object containing client informations; qLOGIN_NAME - query Name for login; readfreefields - read also the freefield values if true
Throws:: E4DBException

find_LOGIN_NAME

public static T_E4S_COMPANY_Obj find_LOGIN_NAME(E4DBConnection_Intf con,
                                                E4ApplObj_Intf appobj,
                                                java.lang.String qLOGIN_NAME)
                                         throws E4DBException

Find a record associates with index 2 (LOGIN_NAME).

Parameters:: con - the database connection; appobj - the current application object containing client informations; qLOGIN_NAME - query Name for login
Throws:: E4DBException

find_LOGIN_NAME

public static T_E4S_COMPANY_Obj find_LOGIN_NAME(E4DBConnection_Intf con,
                                                E4ApplObj_Intf appobj,
                                                java.lang.String qLOGIN_NAME,
                                                boolean readfreefields)
                                         throws E4DBException

Find a record associates with index 2 (LOGIN_NAME) and read associated freefield values.

Parameters:: con - the database connection; appobj - the current application object containing client informations; qLOGIN_NAME - query Name for login; readfreefields - read also the freefield values if true
Throws:: E4DBException

find_BELONGS

public static T_E4S_COMPANY_Vec find_BELONGS(E4ApplObj_Intf appobj,
                                             E4CompanyId qBELONGS_TO)
                                      throws E4DBException

Get records associates with non-index 3 (BELONGS).

Parameters:: appobj - the current application object containing client informations; qBELONGS_TO - query Company belongs to another company (can be null or empty)
Throws:: E4DBException

find_BELONGS

public static T_E4S_COMPANY_Vec find_BELONGS(E4DBConnection_Intf con,
                                             E4ApplObj_Intf appobj,
                                             E4CompanyId qBELONGS_TO)
                                      throws E4DBException

Get records associates with non-unique index 3 (BELONGS).

Parameters:: con - the database connection; appobj - the current application object containing client informations; qBELONGS_TO - query Company belongs to another company (can be null or empty)
Throws:: E4DBException

toXml

public int toXml(E4PrintStream out,
                 int include_freefields)
          throws E4DBException

Export data from database table to XML file. Including freefield contents.

Parameters:: out - an opened output stream
Returns:: the number of records written
Throws:: E4DBException
See Also:: toCsv(e4s.util.E4PrintStream), #toXml(String)

toXml

public int toXml(E4PrintStream out,
                 int include_freefields,
                 E4StatusInformation_Intf status)
          throws E4DBException

Export data from database table to XML file. Including freefield contents.

Parameters:: out - an opened output stream; include_freefields - mode, how freefields shall be included; status - an optional status tracker interface
Returns:: the number of records written
Throws:: E4DBException
See Also:: toCsv(e4s.util.E4PrintStream), #toXml(String)

toXml

public static int toXml(E4ApplObj_Intf appobj,
                        java.lang.String path,
                        int include_freefields)
                 throws E4DBException,
                        java.io.IOException

Export data from database table to XML file.

Parameters:: appobj - the current application object containing client informations; path - the path for file export
Returns:: the number of records written
Throws:: E4DBException; java.io.IOException

toXml

public static int toXml(E4ApplObj_Intf appobj,
                        java.lang.String path,
                        int include_freefields,
                        E4DBColumnName distinctCol)
                 throws E4DBException,
                        java.io.IOException

Export data from database table to XML file.

Parameters:: appobj - the current application object containing client informations; path - the path for file export
Returns:: the number of records written
Throws:: E4DBException; java.io.IOException

toXml

public static int toXml(E4ApplObj_Intf appobj,
                        java.lang.String path,
                        int include_freefields,
                        E4StatusInformation_Intf status)
                 throws E4DBException,
                        java.io.IOException

Export data from database table to XML file.

Parameters:: appobj - the current application object containing client informations; path - the path for file export
Returns:: the number of records written
Throws:: E4DBException; java.io.IOException

toXml

public static int toXml(E4ApplObj_Intf appobj,
                        java.lang.String path,
                        int include_freefields,
                        E4StatusInformation_Intf status,
                        E4DBColumnName distinctCol)
                 throws E4DBException,
                        java.io.IOException

Export data from database table to XML file.

Parameters:: appobj - the current application object containing client informations; path - the path for file export
Returns:: the number of records written
Throws:: E4DBException; java.io.IOException

toCsv

public int toCsv(E4PrintStream out,
                 boolean include_freefields)
          throws E4DBException

Export data from database table to CSV file (MS-Excel compatible input format).

Parameters:: out - an opened output stream; include_freefields - true include freefield values in export.
Returns:: the number of records written
Throws:: E4DBException

toCsv

public int toCsv(E4PrintStream out)
          throws E4DBException

Export data from database table to CSV file (MS-Excel compatible input format).

Parameters:: out - an opened output stream; freefields - true include freefield values in export.
Returns:: the number of records written
Throws:: E4DBException

toCsv

public static int toCsv(E4ApplObj_Intf appobj,
                        java.lang.String path,
                        boolean freefields)
                 throws E4DBException,
                        java.io.IOException

Export data from database table to CSV file (MS-Excel input format).

Parameters:: appobj - the current application object containing client informations; path - the path for file export; freefields - true include freefield values in export.
Returns:: the number of records written
Throws:: E4DBException; java.io.IOException

toCsv

public static int toCsv(E4ApplObj_Intf appobj,
                        java.lang.String path)
                 throws E4DBException,
                        java.io.IOException

Export data from database table to CSV file (MS-Excel input format).

Parameters:: appobj - the current application object containing client informations; path - the path for file export
Returns:: the number of records written
Throws:: E4DBException; java.io.IOException

toSql

public int toSql(E4PrintStream out)
          throws E4DBException

Export data from database table to SQL file. Including freefield contents.

Parameters:: out - an opened output stream
Returns:: the number of records written
Throws:: E4DBException
See Also:: #toXml(e4s.util.E4PrintStream), toCsv(e4s.util.E4PrintStream), #toSql(String)

toSql

public int toSql(E4PrintStream out,
                 int include_freefields)
          throws E4DBException

Export data from database table to SQL script file. Including freefield contents.

Parameters:: out - an opened output stream
Returns:: the number of records written
Throws:: E4DBException
See Also:: #toXml(e4s.util.E4PrintStream), toCsv(e4s.util.E4PrintStream), #toSql(String)

toSql

public static int toSql(E4ApplObj_Intf appobj,
                        java.lang.String path,
                        int include_freefields)
                 throws E4DBException,
                        java.io.IOException

Export data from database table to XML file.

Parameters:: appobj - the current application object containing client informations; path - the path for file export
Returns:: the number of records written
Throws:: E4DBException; java.io.IOException

getFreevalDefinitions

public static T_E4S_FREEFIELD_DEF_Obj[] getFreevalDefinitions(E4ApplObj_Intf applobj)
                                                       throws E4DBException

Get the definitions of the free fields.

Parameters:: applobj - the application object
Returns:: the definitions for table T_E4S_COMPANY.
Throws:: E4DBException
See Also:: E4DBSelectFreefields.getFreevalDefinitions(e4s.application.E4ApplObj_Intf,e4s.db.E4DBTableName), E4DBSelectFreefields.getFreevalDefinitions()

getFreeval

public java.lang.String getFreeval(E4DBFreeFieldName fieldname)
                            throws E4DBException

Get a value for the free-field specified. Based on unique index COMPANY_ID

Specified by:: getFreeval in interface E4DBSelectFreefields_Intf
Specified by:: getFreeval in class E4DBSelectFreefields

Parameters:: fieldname - the name of the free field
Returns:: the value or null if not available.
Throws:: E4DBException
See Also:: E4DBSelectFreefields.getFreeval_Bool(e4s.db.freefield.E4DBFreeFieldName), E4DBSelectFreefields.getFreeval_Long(e4s.db.freefield.E4DBFreeFieldName), E4DBSelectFreefields.getFreeval_Float(e4s.db.freefield.E4DBFreeFieldName), E4DBSelectFreefields.getFreeval_Date(e4s.db.freefield.E4DBFreeFieldName)

checkConsistency

public static void checkConsistency()
                             throws E4DBException

Check table consistency (structure only) against database.

Throws:: E4DBException

checkConsistency

public static void checkConsistency(boolean check_structure,
                                    boolean check_index)
                             throws E4DBException

Check table consistency against database.

Parameters:: check_structure - check the table structure; check_index - check the index (can be time consuming on startup)
Throws:: E4DBException

_getSVNVersionString

public static java.lang.String _getSVNVersionString()

Return the version info patched by CVS.

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_COMPANY_Sel

TABLENAME

SVN_REVISION

IS_CLIENT_DISTINCTIVE

IS_FREEDEF_POSSIBLE

COL_ADDRESS01

CI_ADDRESS01

COL_ADDRESS02

CI_ADDRESS02

COL_BELONGS_TO

CI_BELONGS_TO

COL_CITY

CI_CITY

COL_COMPANY_ID

CI_COMPANY_ID

COL_COUNTRYCODE

CI_COUNTRYCODE

COL_DATMOD

CI_DATMOD

COL_DATNEW

CI_DATNEW

COL_EMAIL

CI_EMAIL

COL_GIS_LATITUDE

CI_GIS_LATITUDE

COL_GIS_LONGITUDE

CI_GIS_LONGITUDE

COL_GROUP_ID

CI_GROUP_ID

COL_LOGIN_NAME

CI_LOGIN_NAME

COL_NAME

CI_NAME

COL_PHONE01

CI_PHONE01

COL_PHONE02

CI_PHONE02

COL_REM

CI_REM

COL_UID

CI_UID

COL_VALID_UNTIL

CI_VALID_UNTIL

COL_WWW

CI_WWW

COL_ZIPCODE

CI_ZIPCODE

COLUMNS

IDX_COMPANY_ID

IDX_LOGIN_NAME

IDX_BELONGS

INDEXES

T_E4S_COMPANY_Sel

T_E4S_COMPANY_Sel

T_E4S_COMPANY_Sel

or

makeInstance

E4ID

hasClientDistinctive

canHaveFreeDefinedFields

getModifyClass

makeInstance_Modify

getObjectClass

getColInfo

getIdxInfo

getFirstPrimaryIndex

next

get_CLIENT

get_ADDRESS01

get_ADDRESS02

get_BELONGS_TO

get_CITY

get_COMPANY_ID

get_COUNTRYCODE

get_DATMOD

get_DATNEW

get_EMAIL

get_GIS_LATITUDE

get_GIS_LONGITUDE

get_GROUP_ID

e4s.db.systabledef
Class T_E4S_COMPANY_Sel