T_E4S_COMPANY_USER

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_USER_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_USER_Sel

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

public class T_E4S_COMPANY_USER_Sel
extends E4DBSelectFreefields
implements E4DBSelectFreefields_Intf
extends E4DBSelectFreefields
implements E4DBSelectFreefields_Intf

SQL select for T_E4S_COMPANY_USER: Users related to companies, here you will find login information of users and personal settings such as date formats. created: 20041222 110445, modified: 20081113 152745. $LastChangedRevision: 5290 $ $LastChangedDate: 2009-12-09 18:45:55 +0100 (Mi, 09 Dez 2009) $

Column	Datatype		Remark
COMPANY_ID	`E4CompanyId` INTEGER	12	Related Company ID
DATEFORMAT	STRING(10)		Date-Format, e,g, dd.MM.yyyy
DATMOD	DATE		Date modified
DATNEW	DATE		Date created
DECIMALSIGN	`E4DecimalSign` STRING(1)		Decimal Sign
EMAIL	STRING(80)		User´s E-Mail address
FIRSTNAME	STRING(60)		Firstname
GENDER	`E4Gender` INTEGER		male, female
LASTNAME	STRING(60)		Lastname
LOGIN_NAME	`E4CompanyUserId` STRING(16)	1	UserId for login, unique identification
LOGIN_PASSWORD	STRING(32)		Password
MIDDLENAME	STRING(1)		Middlename
REM	STRING(255)		Free Remark
SATURATION	STRING(12)		Saturation (e.g. Dr.)
TIMEFORMAT	STRING(10)		Time-Format, e.g. HH:mm:ss
TIMEZONE	TimeZone		Relative Timezone to GMT
VALID_UNTIL	DATE		Valid until

Index 1: LOGIN unique Index 2: IDX2

See Also:: T_E4S_COMPANY_USER_Mod, T_E4S_COMPANY_USER_Obj, V_E4S_USERS_Sel

Nested Class Summary
`static class`	`T_E4S_COMPANY_USER_Sel.T_E4S_COMPANY_USER_And` Filter to be used as AND condition.
`static class`	`T_E4S_COMPANY_USER_Sel.T_E4S_COMPANY_USER_Or` Filter to be used as OR condition.

Field Summary
`static E4DBColumnInfo`	`CI_COMPANY_ID`
`static E4DBColumnInfo`	`CI_DATEFORMAT`
`static E4DBColumnInfo`	`CI_DATMOD`
`static E4DBColumnInfo`	`CI_DATNEW`
`static E4DBColumnInfo`	`CI_DECIMALSIGN`
`static E4DBColumnInfo`	`CI_EMAIL`
`static E4DBColumnInfo`	`CI_FIRSTNAME`
`static E4DBColumnInfo`	`CI_GENDER`
`static E4DBColumnInfo`	`CI_LASTNAME`
`static E4DBColumnInfo`	`CI_LOGIN_NAME`
`static E4DBColumnInfo`	`CI_LOGIN_PASSWORD`
`static E4DBColumnInfo`	`CI_MIDDLENAME`
`static E4DBColumnInfo`	`CI_REM`
`static E4DBColumnInfo`	`CI_SATURATION`
`static E4DBColumnInfo`	`CI_TIMEFORMAT`
`static E4DBColumnInfo`	`CI_TIMEZONE`
`static E4DBColumnInfo`	`CI_VALID_UNTIL`
`static E4DBColumnName`	`COL_COMPANY_ID` E4CompanyId defined as e4s.util.E4Long Numeric, incremental ID for companies Related Company ID Member of index: LOGIN,#2.
`static E4DBColumnName`	`COL_DATEFORMAT` STRING(10) Date-Format, e,g, dd.MM.yyyy
`static E4DBColumnName`	`COL_DATMOD` DATE Date modified
`static E4DBColumnName`	`COL_DATNEW` DATE Date created
`static E4DBColumnName`	`COL_DECIMALSIGN` E4DecimalSign defined as e4s.util.E4String(1) Definition for Decimal Sign, related to Client/User Decimal Sign
`static E4DBColumnName`	`COL_EMAIL` STRING(80) User´s E-Mail address
`static E4DBColumnName`	`COL_FIRSTNAME` STRING(60) Firstname
`static E4DBColumnName`	`COL_GENDER` E4Gender defined as e4s.util.E4Long male, female
`static E4DBColumnName`	`COL_LASTNAME` STRING(60) Lastname
`static E4DBColumnName`	`COL_LOGIN_NAME` E4CompanyUserId defined as e4s.util.E4String(16) User login name, unique identification for the user in the login process.
`static E4DBColumnName`	`COL_LOGIN_PASSWORD` STRING(32) Password
`static E4DBColumnName`	`COL_MIDDLENAME` STRING(1) Middlename
`static E4DBColumnName`	`COL_REM` STRING(255) Free Remark
`static E4DBColumnName`	`COL_SATURATION` STRING(12) Saturation (e.g.
`static E4DBColumnName`	`COL_TIMEFORMAT` STRING(10) Time-Format, e.g.
`static E4DBColumnName`	`COL_TIMEZONE` TimeZone Relative Timezone to GMT
`static E4DBColumnName`	`COL_VALID_UNTIL` DATE Valid until
`static E4DBColumnInfo[]`	`COLUMNS` Definition of database columns as array
`static E4DBIndexInfo`	`IDX_LOGIN` Definition of index IDX_LOGIN.
`static E4DBIndexInfo`	`IDX2` Definition of index IDX2.
`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_USER_Sel(E4ApplObj_Intf applobj)` Construct an object for selecting data from T_E4S_COMPANY_USER using the default database connection, the table uses client distinction.
`T_E4S_COMPANY_USER_Sel(E4DBConnection_Intf dbcon, E4ApplObj_Intf applobj)` Construct an object for selecting data from T_E4S_COMPANY_USER using a database connection, the table uses client distinction.
`T_E4S_COMPANY_USER_Sel(T_E4S_COMPANY_USER_Sel dbtable, boolean copy_where)` Construct an object for selecting data from T_E4S_COMPANY_USER using an existing T_E4S_COMPANY_USER_Sel instance.

Method Summary
`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_USER_Obj`	`find_LOGIN(E4ApplObj_Intf applobj)`
`static T_E4S_COMPANY_USER_Obj`	`find_LOGIN(E4ApplObj_Intf appobj, E4CompanyId qCOMPANY_ID, E4CompanyUserId qLOGIN_NAME)` Find a record associates with unique index 1 (LOGIN).
`static T_E4S_COMPANY_USER_Obj`	`find_LOGIN(E4ApplObj_Intf appobj, E4CompanyId qCOMPANY_ID, E4CompanyUserId qLOGIN_NAME, boolean readfreefields)` Find a record associates with unique index 1 (LOGIN) and read associated freefield values.
`static T_E4S_COMPANY_USER_Obj`	`find_LOGIN(E4ApplObj_Intf applobj, E4User user)`
`static T_E4S_COMPANY_USER_Obj`	`find_LOGIN(E4DBConnection_Intf con, E4ApplObj_Intf appobj, E4CompanyId qCOMPANY_ID, E4CompanyUserId qLOGIN_NAME)` Find a record associates with index 1 (LOGIN).
`static T_E4S_COMPANY_USER_Obj`	`find_LOGIN(E4DBConnection_Intf con, E4ApplObj_Intf appobj, E4CompanyId qCOMPANY_ID, E4CompanyUserId qLOGIN_NAME, boolean readfreefields)` Find a record associates with index 1 (LOGIN) and read associated freefield values.
`E4Client`	`get_CLIENT()` Get value for client.
`E4CompanyId`	`get_COMPANY_ID()` Get value for column COMPANY_ID.
`java.lang.String`	`get_DATEFORMAT()` Get value for column DATEFORMAT.
`java.util.Date`	`get_DATMOD()` Get value for column DATMOD.
`java.util.Date`	`get_DATNEW()` Get value for column DATNEW.
`E4DecimalSign`	`get_DECIMALSIGN()` Get value for column DECIMALSIGN.
`java.lang.String`	`get_EMAIL()` Get value for column EMAIL.
`E4Fieldset`	`get_FIELDSET()`
`E4Fieldset`	`get_FIELDSET(FORM form)`
`java.lang.String`	`get_FIRSTNAME()` Get value for column FIRSTNAME.
`E4Gender`	`get_GENDER()` Get value for column GENDER.
`java.lang.String`	`get_LASTNAME()` Get value for column LASTNAME.
`E4CompanyUserId`	`get_LOGIN_NAME()` Get value for column LOGIN_NAME.
`java.lang.String`	`get_LOGIN_PASSWORD()` Get value for column LOGIN_PASSWORD.
`java.lang.String`	`get_MIDDLENAME()` Get value for column MIDDLENAME.
`java.lang.String`	`get_REM()` Get value for column REM.
`java.lang.String`	`get_SATURATION()` Get value for column SATURATION.
`java.lang.String`	`get_TIMEFORMAT()` Get value for column TIMEFORMAT.
`TimeZone`	`get_TIMEZONE()` Get value for column TIMEZONE.
`java.util.Date`	`get_VALID_UNTIL()` Get value for column VALID_UNTIL.
`T_E4S_COMPANY_USER_Obj`	`get()` Get the data object for T_E4S_COMPANY_USER without reading freedefined values.
`T_E4S_COMPANY_USER_Obj`	`get(boolean readfreefields)` Get the data object for T_E4S_COMPANY_USER 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_LOGIN`.
`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_USER.
`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_USER_Obj in a Vector.
`E4PersistantVector`	`getQuery(boolean includefreefields)` `E4DBSelect.executeQuery()` and store elements of type T_E4S_COMPANY_USER_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_USER_Sel
`boolean`	`next()` Fetch next record.
`T_E4S_COMPANY_USER_Sel.T_E4S_COMPANY_USER_Or`	`or()`
`void`	`sort_COMPANY_ID_descending()` Sort descending by column COMPANY_ID.
`void`	`sort_COMPANY_ID()` Sort ascending by column COMPANY_ID.
`void`	`sort_DATEFORMAT_descending()` Sort descending by column DATEFORMAT.
`void`	`sort_DATEFORMAT()` Sort ascending by column DATEFORMAT.
`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_DECIMALSIGN_descending()` Sort descending by column DECIMALSIGN.
`void`	`sort_DECIMALSIGN()` Sort ascending by column DECIMALSIGN.
`void`	`sort_EMAIL_descending()` Sort descending by column EMAIL.
`void`	`sort_EMAIL()` Sort ascending by column EMAIL.
`void`	`sort_FIRSTNAME_descending()` Sort descending by column FIRSTNAME.
`void`	`sort_FIRSTNAME()` Sort ascending by column FIRSTNAME.
`void`	`sort_GENDER_descending()` Sort descending by column GENDER.
`void`	`sort_GENDER()` Sort ascending by column GENDER.
`void`	`sort_LASTNAME_descending()` Sort descending by column LASTNAME.
`void`	`sort_LASTNAME()` Sort ascending by column LASTNAME.
`void`	`sort_LOGIN_NAME_descending()` Sort descending by column LOGIN_NAME.
`void`	`sort_LOGIN_NAME()` Sort ascending by column LOGIN_NAME.
`void`	`sort_LOGIN_PASSWORD_descending()` Sort descending by column LOGIN_PASSWORD.
`void`	`sort_LOGIN_PASSWORD()` Sort ascending by column LOGIN_PASSWORD.
`void`	`sort_MIDDLENAME_descending()` Sort descending by column MIDDLENAME.
`void`	`sort_MIDDLENAME()` Sort ascending by column MIDDLENAME.
`void`	`sort_REM_descending()` Sort descending by column REM.
`void`	`sort_REM()` Sort ascending by column REM.
`void`	`sort_SATURATION_descending()` Sort descending by column SATURATION.
`void`	`sort_SATURATION()` Sort ascending by column SATURATION.
`void`	`sort_TIMEFORMAT_descending()` Sort descending by column TIMEFORMAT.
`void`	`sort_TIMEFORMAT()` Sort ascending by column TIMEFORMAT.
`void`	`sort_TIMEZONE_descending()` Sort descending by column TIMEZONE.
`void`	`sort_TIMEZONE()` Sort ascending by column TIMEZONE.
`void`	`sort_VALID_UNTIL_descending()` Sort descending by column VALID_UNTIL.
`void`	`sort_VALID_UNTIL()` Sort ascending by column VALID_UNTIL.
`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_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_DATEFORMAT_in(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_DATEFORMAT_in(java.lang.String[] filter)` Define a IN-filter (AND-ed WHERE) for column DATEFORMAT.
`void`	`where_DATEFORMAT_isEmpty()` Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column DATEFORMAT.
`void`	`where_DATEFORMAT_isNotEmpty()` Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column DATEFORMAT.
`void`	`where_DATEFORMAT_isNotNull()` Define a is-NOT-null filter (AND-ed WHERE) for column DATEFORMAT.
`void`	`where_DATEFORMAT_isNull()` Define a is-null filter (AND-ed WHERE) for column DATEFORMAT.
`void`	`where_DATEFORMAT_not_in(java.lang.String[] filter)` Define a NOT-IN-filter (AND-ed WHERE) for column DATEFORMAT.
`void`	`where_DATEFORMAT_notin(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_DATEFORMAT(int operator, java.lang.String filter)` Define a filter (AND-ed WHERE with operator) for column DATEFORMAT.
`void`	`where_DATEFORMAT(java.lang.String filter)` Define a filter (AND-ed WHERE) for column DATEFORMAT.
`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_DECIMALSIGN_in(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_DECIMALSIGN_in(E4DecimalSign[] filter)` Define a IN-filter (AND-ed WHERE) for column DECIMALSIGN.
`void`	`where_DECIMALSIGN_isEmpty()` Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column DECIMALSIGN.
`void`	`where_DECIMALSIGN_isNotEmpty()` Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column DECIMALSIGN.
`void`	`where_DECIMALSIGN_isNotNull()` Define a is-NOT-null filter (AND-ed WHERE) for column DECIMALSIGN.
`void`	`where_DECIMALSIGN_isNull()` Define a is-null filter (AND-ed WHERE) for column DECIMALSIGN.
`void`	`where_DECIMALSIGN_like(java.lang.String filter)` Define a filter (AND-ed WHERE) for column DECIMALSIGN.
`void`	`where_DECIMALSIGN_not_in(E4DecimalSign[] filter)` Define a NOT-IN-filter (AND-ed WHERE) for column DECIMALSIGN.
`void`	`where_DECIMALSIGN_notin(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_DECIMALSIGN(E4DecimalSign filter)` Define a filter (AND-ed WHERE) for column DECIMALSIGN.
`void`	`where_DECIMALSIGN(int operator, E4DecimalSign filter)` Define a filter (AND-ed WHERE with operator) for column DECIMALSIGN.
`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_FIRSTNAME_in(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_FIRSTNAME_in(java.lang.String[] filter)` Define a IN-filter (AND-ed WHERE) for column FIRSTNAME.
`void`	`where_FIRSTNAME_isEmpty()` Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column FIRSTNAME.
`void`	`where_FIRSTNAME_isNotEmpty()` Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column FIRSTNAME.
`void`	`where_FIRSTNAME_isNotNull()` Define a is-NOT-null filter (AND-ed WHERE) for column FIRSTNAME.
`void`	`where_FIRSTNAME_isNull()` Define a is-null filter (AND-ed WHERE) for column FIRSTNAME.
`void`	`where_FIRSTNAME_not_in(java.lang.String[] filter)` Define a NOT-IN-filter (AND-ed WHERE) for column FIRSTNAME.
`void`	`where_FIRSTNAME_notin(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_FIRSTNAME(int operator, java.lang.String filter)` Define a filter (AND-ed WHERE with operator) for column FIRSTNAME.
`void`	`where_FIRSTNAME(java.lang.String filter)` Define a filter (AND-ed WHERE) for column FIRSTNAME.
`void`	`where_GENDER_in(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_GENDER_notin(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_GENDER(E4Gender filter)` Define a filter (AND-ed WHERE) for column GENDER.
`void`	`where_GENDER(int operator, E4Gender filter)` Define a filter (AND-ed WHERE with operator) for column GENDER.
`void`	`where_LASTNAME_in(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_LASTNAME_in(java.lang.String[] filter)` Define a IN-filter (AND-ed WHERE) for column LASTNAME.
`void`	`where_LASTNAME_isEmpty()` Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column LASTNAME.
`void`	`where_LASTNAME_isNotEmpty()` Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column LASTNAME.
`void`	`where_LASTNAME_isNotNull()` Define a is-NOT-null filter (AND-ed WHERE) for column LASTNAME.
`void`	`where_LASTNAME_isNull()` Define a is-null filter (AND-ed WHERE) for column LASTNAME.
`void`	`where_LASTNAME_not_in(java.lang.String[] filter)` Define a NOT-IN-filter (AND-ed WHERE) for column LASTNAME.
`void`	`where_LASTNAME_notin(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_LASTNAME(int operator, java.lang.String filter)` Define a filter (AND-ed WHERE with operator) for column LASTNAME.
`void`	`where_LASTNAME(java.lang.String filter)` Define a filter (AND-ed WHERE) for column LASTNAME.
`void`	`where_LOGIN_NAME_in(E4CompanyUserId[] filter)` Define a IN-filter (AND-ed WHERE) for column LOGIN_NAME.
`void`	`where_LOGIN_NAME_in(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`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_like(java.lang.String filter)` Define a filter (AND-ed WHERE) for column LOGIN_NAME.
`void`	`where_LOGIN_NAME_not_in(E4CompanyUserId[] 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(E4CompanyUserId filter)` Define a filter (AND-ed WHERE) for column LOGIN_NAME.
`void`	`where_LOGIN_NAME(int operator, E4CompanyUserId filter)` Define a filter (AND-ed WHERE with operator) for column LOGIN_NAME.
`void`	`where_LOGIN_PASSWORD_in(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_LOGIN_PASSWORD_in(java.lang.String[] filter)` Define a IN-filter (AND-ed WHERE) for column LOGIN_PASSWORD.
`void`	`where_LOGIN_PASSWORD_isEmpty()` Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column LOGIN_PASSWORD.
`void`	`where_LOGIN_PASSWORD_isNotEmpty()` Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column LOGIN_PASSWORD.
`void`	`where_LOGIN_PASSWORD_isNotNull()` Define a is-NOT-null filter (AND-ed WHERE) for column LOGIN_PASSWORD.
`void`	`where_LOGIN_PASSWORD_isNull()` Define a is-null filter (AND-ed WHERE) for column LOGIN_PASSWORD.
`void`	`where_LOGIN_PASSWORD_not_in(java.lang.String[] filter)` Define a NOT-IN-filter (AND-ed WHERE) for column LOGIN_PASSWORD.
`void`	`where_LOGIN_PASSWORD_notin(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_LOGIN_PASSWORD(int operator, java.lang.String filter)` Define a filter (AND-ed WHERE with operator) for column LOGIN_PASSWORD.
`void`	`where_LOGIN_PASSWORD(java.lang.String filter)` Define a filter (AND-ed WHERE) for column LOGIN_PASSWORD.
`void`	`where_MIDDLENAME_in(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_MIDDLENAME_in(java.lang.String[] filter)` Define a IN-filter (AND-ed WHERE) for column MIDDLENAME.
`void`	`where_MIDDLENAME_isEmpty()` Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column MIDDLENAME.
`void`	`where_MIDDLENAME_isNotEmpty()` Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column MIDDLENAME.
`void`	`where_MIDDLENAME_isNotNull()` Define a is-NOT-null filter (AND-ed WHERE) for column MIDDLENAME.
`void`	`where_MIDDLENAME_isNull()` Define a is-null filter (AND-ed WHERE) for column MIDDLENAME.
`void`	`where_MIDDLENAME_not_in(java.lang.String[] filter)` Define a NOT-IN-filter (AND-ed WHERE) for column MIDDLENAME.
`void`	`where_MIDDLENAME_notin(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_MIDDLENAME(int operator, java.lang.String filter)` Define a filter (AND-ed WHERE with operator) for column MIDDLENAME.
`void`	`where_MIDDLENAME(java.lang.String filter)` Define a filter (AND-ed WHERE) for column MIDDLENAME.
`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_SATURATION_in(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_SATURATION_in(java.lang.String[] filter)` Define a IN-filter (AND-ed WHERE) for column SATURATION.
`void`	`where_SATURATION_isEmpty()` Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column SATURATION.
`void`	`where_SATURATION_isNotEmpty()` Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column SATURATION.
`void`	`where_SATURATION_isNotNull()` Define a is-NOT-null filter (AND-ed WHERE) for column SATURATION.
`void`	`where_SATURATION_isNull()` Define a is-null filter (AND-ed WHERE) for column SATURATION.
`void`	`where_SATURATION_not_in(java.lang.String[] filter)` Define a NOT-IN-filter (AND-ed WHERE) for column SATURATION.
`void`	`where_SATURATION_notin(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_SATURATION(int operator, java.lang.String filter)` Define a filter (AND-ed WHERE with operator) for column SATURATION.
`void`	`where_SATURATION(java.lang.String filter)` Define a filter (AND-ed WHERE) for column SATURATION.
`void`	`where_TIMEFORMAT_in(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_TIMEFORMAT_in(java.lang.String[] filter)` Define a IN-filter (AND-ed WHERE) for column TIMEFORMAT.
`void`	`where_TIMEFORMAT_isEmpty()` Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column TIMEFORMAT.
`void`	`where_TIMEFORMAT_isNotEmpty()` Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column TIMEFORMAT.
`void`	`where_TIMEFORMAT_isNotNull()` Define a is-NOT-null filter (AND-ed WHERE) for column TIMEFORMAT.
`void`	`where_TIMEFORMAT_isNull()` Define a is-null filter (AND-ed WHERE) for column TIMEFORMAT.
`void`	`where_TIMEFORMAT_not_in(java.lang.String[] filter)` Define a NOT-IN-filter (AND-ed WHERE) for column TIMEFORMAT.
`void`	`where_TIMEFORMAT_notin(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_TIMEFORMAT(int operator, java.lang.String filter)` Define a filter (AND-ed WHERE with operator) for column TIMEFORMAT.
`void`	`where_TIMEFORMAT(java.lang.String filter)` Define a filter (AND-ed WHERE) for column TIMEFORMAT.
`void`	`where_TIMEZONE_in(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_TIMEZONE_notin(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_TIMEZONE(int operator, TimeZone filter)` Define a filter (AND-ed WHERE with operator) for column TIMEZONE.
`void`	`where_TIMEZONE(TimeZone filter)` Define a filter (AND-ed WHERE) for column TIMEZONE.
`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.

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_COMPANY_ID

public static final E4DBColumnName COL_COMPANY_ID

E4CompanyId defined as e4s.util.E4Long Numeric, incremental ID for companies Related Company ID Member of index: LOGIN,#2.

See Also:: E4CompanyId, IDX_LOGIN, IDX2

CI_COMPANY_ID

public static final E4DBColumnInfo CI_COMPANY_ID

COL_DATEFORMAT

public static final E4DBColumnName COL_DATEFORMAT

STRING(10) Date-Format, e,g, dd.MM.yyyy

CI_DATEFORMAT

public static final E4DBColumnInfo CI_DATEFORMAT

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_DECIMALSIGN

public static final E4DBColumnName COL_DECIMALSIGN

E4DecimalSign defined as e4s.util.E4String(1) Definition for Decimal Sign, related to Client/User Decimal Sign

See Also:: E4DecimalSign

CI_DECIMALSIGN

public static final E4DBColumnInfo CI_DECIMALSIGN

COL_EMAIL

public static final E4DBColumnName COL_EMAIL

STRING(80) User´s E-Mail address

CI_EMAIL

public static final E4DBColumnInfo CI_EMAIL

COL_FIRSTNAME

public static final E4DBColumnName COL_FIRSTNAME

STRING(60) Firstname

CI_FIRSTNAME

public static final E4DBColumnInfo CI_FIRSTNAME

COL_GENDER

public static final E4DBColumnName COL_GENDER

E4Gender defined as e4s.util.E4Long male, female

See Also:: E4Gender

CI_GENDER

public static final E4DBColumnInfo CI_GENDER

COL_LASTNAME

public static final E4DBColumnName COL_LASTNAME

STRING(60) Lastname

CI_LASTNAME

public static final E4DBColumnInfo CI_LASTNAME

COL_LOGIN_NAME

public static final E4DBColumnName COL_LOGIN_NAME

E4CompanyUserId defined as e4s.util.E4String(16) User login name, unique identification for the user in the login process. UserId for login, unique identification Member of index: LOGIN.

See Also:: E4CompanyUserId, IDX_LOGIN

CI_LOGIN_NAME

public static final E4DBColumnInfo CI_LOGIN_NAME

COL_LOGIN_PASSWORD

public static final E4DBColumnName COL_LOGIN_PASSWORD

STRING(32) Password

CI_LOGIN_PASSWORD

public static final E4DBColumnInfo CI_LOGIN_PASSWORD

COL_MIDDLENAME

public static final E4DBColumnName COL_MIDDLENAME

STRING(1) Middlename

CI_MIDDLENAME

public static final E4DBColumnInfo CI_MIDDLENAME

COL_REM

public static final E4DBColumnName COL_REM

STRING(255) Free Remark

CI_REM

public static final E4DBColumnInfo CI_REM

COL_SATURATION

public static final E4DBColumnName COL_SATURATION

STRING(12) Saturation (e.g. Dr.)

CI_SATURATION

public static final E4DBColumnInfo CI_SATURATION

COL_TIMEFORMAT

public static final E4DBColumnName COL_TIMEFORMAT

STRING(10) Time-Format, e.g. HH:mm:ss

CI_TIMEFORMAT

public static final E4DBColumnInfo CI_TIMEFORMAT

COL_TIMEZONE

public static final E4DBColumnName COL_TIMEZONE

TimeZone Relative Timezone to GMT

CI_TIMEZONE

public static final E4DBColumnInfo CI_TIMEZONE

COL_VALID_UNTIL

public static final E4DBColumnName COL_VALID_UNTIL

DATE Valid until

CI_VALID_UNTIL

public static final E4DBColumnInfo CI_VALID_UNTIL

COLUMNS

public static final E4DBColumnInfo[] COLUMNS

Definition of database columns as array

See Also:: INDEXES

IDX_LOGIN

public static final E4DBIndexInfo IDX_LOGIN

Definition of index IDX_LOGIN.

See Also:: COL_LOGIN_NAME, COL_LOGIN_NAME, COL_COMPANY_ID

IDX2

public static final E4DBIndexInfo IDX2

Definition of index IDX2.

See Also:: COL_COMPANY_ID

INDEXES

public static final E4DBIndexInfo[] INDEXES

Definition of table indexes.

See Also:: COLUMNS

Constructor Detail

T_E4S_COMPANY_USER_Sel

public T_E4S_COMPANY_USER_Sel(E4DBConnection_Intf dbcon,
                              E4ApplObj_Intf applobj)

Construct an object for selecting data from T_E4S_COMPANY_USER 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_USER_Sel

public T_E4S_COMPANY_USER_Sel(E4ApplObj_Intf applobj)
                       throws E4DBException

Construct an object for selecting data from T_E4S_COMPANY_USER 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_USER_Sel

public T_E4S_COMPANY_USER_Sel(T_E4S_COMPANY_USER_Sel dbtable,
                              boolean copy_where)
                       throws E4DBException

Construct an object for selecting data from T_E4S_COMPANY_USER using an existing T_E4S_COMPANY_USER_Sel instance.

Parameters:: dbtable - a previous created T_E4S_COMPANY_USER_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_USER_Sel.T_E4S_COMPANY_USER_Or or()

makeInstance

public E4DBSelect_Intf makeInstance(boolean copy_where)
                             throws E4DBException

Create a new instance for T_E4S_COMPANY_USER_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_USER.

Specified by:: getModifyClass in interface E4DBSelect_Intf

Returns:: class for the modifications
See Also:: E4DBModify_Intf, E4DBModifyFreefields_Intf, T_E4S_COMPANY_USER_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_USER_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_LOGIN.

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

Returns:: IDX_LOGIN.

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_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 Related Company ID

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

get_DATEFORMAT

public java.lang.String get_DATEFORMAT()
                                throws E4DBException

Get value for column DATEFORMAT. STRING(10) Date-Format, e,g, dd.MM.yyyy

Returns:: the database column value retrieved for field DATEFORMAT
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_DECIMALSIGN

public E4DecimalSign get_DECIMALSIGN()
                              throws E4DBException

Get value for column DECIMALSIGN. E4DecimalSign defined as e4s.util.E4String(1) Definition for Decimal Sign, related to Client/User Decimal Sign

Returns:: the database column value retrieved for field DECIMALSIGN
Throws:: E4DBException
See Also:: E4DecimalSign

get_EMAIL

public java.lang.String get_EMAIL()
                           throws E4DBException

Get value for column EMAIL. STRING(80) User´s E-Mail address

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

get_FIRSTNAME

public java.lang.String get_FIRSTNAME()
                               throws E4DBException

Get value for column FIRSTNAME. STRING(60) Firstname

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

get_GENDER

public E4Gender get_GENDER()
                    throws E4DBException

Get value for column GENDER. E4Gender defined as e4s.util.E4Long male, female

Returns:: the database column value retrieved for field GENDER
Throws:: E4DBException
See Also:: E4Gender

get_LASTNAME

public java.lang.String get_LASTNAME()
                              throws E4DBException

Get value for column LASTNAME. STRING(60) Lastname

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

get_LOGIN_NAME

public E4CompanyUserId get_LOGIN_NAME()
                               throws E4DBException

Get value for column LOGIN_NAME. E4CompanyUserId defined as e4s.util.E4String(16) User login name, unique identification for the user in the login process. UserId for login, unique identification

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

get_LOGIN_PASSWORD

public java.lang.String get_LOGIN_PASSWORD()
                                    throws E4DBException

Get value for column LOGIN_PASSWORD. STRING(32) Password

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

get_MIDDLENAME

public java.lang.String get_MIDDLENAME()
                                throws E4DBException

Get value for column MIDDLENAME. STRING(1) Middlename

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

get_REM

public java.lang.String get_REM()
                         throws E4DBException

Get value for column REM. STRING(255) Free Remark

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

get_SATURATION

public java.lang.String get_SATURATION()
                                throws E4DBException

Get value for column SATURATION. STRING(12) Saturation (e.g. Dr.)

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

get_TIMEFORMAT

public java.lang.String get_TIMEFORMAT()
                                throws E4DBException

Get value for column TIMEFORMAT. STRING(10) Time-Format, e.g. HH:mm:ss

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

get_TIMEZONE

public TimeZone get_TIMEZONE()
                      throws E4DBException

Get value for column TIMEZONE. TimeZone Relative Timezone to GMT

Returns:: the database column value retrieved for field TIMEZONE
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

public T_E4S_COMPANY_USER_Obj get(boolean readfreefields)
                           throws E4DBException

Get the data object for T_E4S_COMPANY_USER 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_USER_Obj get()
                           throws E4DBException

Get the data object for T_E4S_COMPANY_USER 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_USER_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_USER_Obj in a Vector. Perform a E4DBSelect.close() afterwards.

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

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 Related Company ID

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 Related Company ID

See Also:: E4CompanyId

sort_DATEFORMAT

public void sort_DATEFORMAT()

Sort ascending by column DATEFORMAT. STRING(10) Date-Format, e,g, dd.MM.yyyy

sort_DATEFORMAT_descending

public void sort_DATEFORMAT_descending()

Sort descending by column DATEFORMAT. STRING(10) Date-Format, e,g, dd.MM.yyyy

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_DECIMALSIGN

public void sort_DECIMALSIGN()

Sort ascending by column DECIMALSIGN. E4DecimalSign defined as e4s.util.E4String(1) Definition for Decimal Sign, related to Client/User Decimal Sign

See Also:: E4DecimalSign

sort_DECIMALSIGN_descending

public void sort_DECIMALSIGN_descending()

Sort descending by column DECIMALSIGN. E4DecimalSign defined as e4s.util.E4String(1) Definition for Decimal Sign, related to Client/User Decimal Sign

See Also:: E4DecimalSign

sort_EMAIL

public void sort_EMAIL()

Sort ascending by column EMAIL. STRING(80) User´s E-Mail address

sort_EMAIL_descending

public void sort_EMAIL_descending()

Sort descending by column EMAIL. STRING(80) User´s E-Mail address

sort_FIRSTNAME

public void sort_FIRSTNAME()

Sort ascending by column FIRSTNAME. STRING(60) Firstname

sort_FIRSTNAME_descending

public void sort_FIRSTNAME_descending()

Sort descending by column FIRSTNAME. STRING(60) Firstname

sort_GENDER

public void sort_GENDER()

Sort ascending by column GENDER. E4Gender defined as e4s.util.E4Long male, female

See Also:: E4Gender

sort_GENDER_descending

public void sort_GENDER_descending()

Sort descending by column GENDER. E4Gender defined as e4s.util.E4Long male, female

See Also:: E4Gender

sort_LASTNAME

public void sort_LASTNAME()

Sort ascending by column LASTNAME. STRING(60) Lastname

sort_LASTNAME_descending

public void sort_LASTNAME_descending()

Sort descending by column LASTNAME. STRING(60) Lastname

sort_LOGIN_NAME

public void sort_LOGIN_NAME()

Sort ascending by column LOGIN_NAME. E4CompanyUserId defined as e4s.util.E4String(16) User login name, unique identification for the user in the login process. UserId for login, unique identification

See Also:: E4CompanyUserId

sort_LOGIN_NAME_descending

public void sort_LOGIN_NAME_descending()

Sort descending by column LOGIN_NAME. E4CompanyUserId defined as e4s.util.E4String(16) User login name, unique identification for the user in the login process. UserId for login, unique identification

See Also:: E4CompanyUserId

sort_LOGIN_PASSWORD

public void sort_LOGIN_PASSWORD()

Sort ascending by column LOGIN_PASSWORD. STRING(32) Password

sort_LOGIN_PASSWORD_descending

public void sort_LOGIN_PASSWORD_descending()

Sort descending by column LOGIN_PASSWORD. STRING(32) Password

sort_MIDDLENAME

public void sort_MIDDLENAME()

Sort ascending by column MIDDLENAME. STRING(1) Middlename

sort_MIDDLENAME_descending

public void sort_MIDDLENAME_descending()

Sort descending by column MIDDLENAME. STRING(1) Middlename

sort_REM

public void sort_REM()

Sort ascending by column REM. STRING(255) Free Remark

sort_REM_descending

public void sort_REM_descending()

Sort descending by column REM. STRING(255) Free Remark

sort_SATURATION

public void sort_SATURATION()

Sort ascending by column SATURATION. STRING(12) Saturation (e.g. Dr.)

sort_SATURATION_descending

public void sort_SATURATION_descending()

Sort descending by column SATURATION. STRING(12) Saturation (e.g. Dr.)

sort_TIMEFORMAT

public void sort_TIMEFORMAT()

Sort ascending by column TIMEFORMAT. STRING(10) Time-Format, e.g. HH:mm:ss

sort_TIMEFORMAT_descending

public void sort_TIMEFORMAT_descending()

Sort descending by column TIMEFORMAT. STRING(10) Time-Format, e.g. HH:mm:ss

sort_TIMEZONE

public void sort_TIMEZONE()

Sort ascending by column TIMEZONE. TimeZone Relative Timezone to GMT

sort_TIMEZONE_descending

public void sort_TIMEZONE_descending()

Sort descending by column TIMEZONE. TimeZone Relative Timezone to GMT

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

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 Related Company ID

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 Related Company ID

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 Related Company ID

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

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) COMPANY_ID. E4CompanyId defined as e4s.util.E4Long Numeric, incremental ID for companies Related Company ID

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

where_DATEFORMAT

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

Define a filter (AND-ed WHERE) for column DATEFORMAT. STRING(10) Date-Format, e,g, dd.MM.yyyy

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

where_DATEFORMAT

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

Define a filter (AND-ed WHERE with operator) for column DATEFORMAT. STRING(10) Date-Format, e,g, dd.MM.yyyy

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

where_DATEFORMAT_in

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

Define a IN-filter (AND-ed WHERE) for column DATEFORMAT. STRING(10) Date-Format, e,g, dd.MM.yyyy

Throws:: E4DBException

where_DATEFORMAT_not_in

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

Define a NOT-IN-filter (AND-ed WHERE) for column DATEFORMAT. STRING(10) Date-Format, e,g, dd.MM.yyyy

Throws:: E4DBException

where_DATEFORMAT_isNull

public void where_DATEFORMAT_isNull()
                             throws E4DBException

Define a is-null filter (AND-ed WHERE) for column DATEFORMAT. STRING(10) Date-Format, e,g, dd.MM.yyyy

Throws:: E4DBException

where_DATEFORMAT_isNotNull

public void where_DATEFORMAT_isNotNull()
                                throws E4DBException

Define a is-NOT-null filter (AND-ed WHERE) for column DATEFORMAT. STRING(10) Date-Format, e,g, dd.MM.yyyy

Throws:: E4DBException

where_DATEFORMAT_in

public void where_DATEFORMAT_in(E4DBSelectDistinct filter)
                         throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) DATEFORMAT. STRING(10) Date-Format, e,g, dd.MM.yyyy

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

where_DATEFORMAT_notin

public void where_DATEFORMAT_notin(E4DBSelectDistinct filter)
                            throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) DATEFORMAT. STRING(10) Date-Format, e,g, dd.MM.yyyy

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

where_DATEFORMAT_isEmpty

public void where_DATEFORMAT_isEmpty()
                              throws E4DBException

Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column DATEFORMAT. STRING(10) Date-Format, e,g, dd.MM.yyyy

Throws:: E4DBException

where_DATEFORMAT_isNotEmpty

public void where_DATEFORMAT_isNotEmpty()
                                 throws E4DBException

Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column DATEFORMAT. STRING(10) Date-Format, e,g, dd.MM.yyyy

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_DECIMALSIGN

public void where_DECIMALSIGN(E4DecimalSign filter)
                       throws E4DBException

Define a filter (AND-ed WHERE) for column DECIMALSIGN. E4DecimalSign defined as e4s.util.E4String(1) Definition for Decimal Sign, related to Client/User Decimal Sign

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

where_DECIMALSIGN

public void where_DECIMALSIGN(int operator,
                              E4DecimalSign filter)
                       throws E4DBException

Define a filter (AND-ed WHERE with operator) for column DECIMALSIGN. E4DecimalSign defined as e4s.util.E4String(1) Definition for Decimal Sign, related to Client/User Decimal Sign

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

where_DECIMALSIGN_like

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

Define a filter (AND-ed WHERE) for column DECIMALSIGN. E4DecimalSign defined as e4s.util.E4String(1) Definition for Decimal Sign, related to Client/User Decimal Sign

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

where_DECIMALSIGN_in

public void where_DECIMALSIGN_in(E4DecimalSign[] filter)
                          throws E4DBException

Define a IN-filter (AND-ed WHERE) for column DECIMALSIGN. E4DecimalSign defined as e4s.util.E4String(1) Definition for Decimal Sign, related to Client/User Decimal Sign

Throws:: E4DBException
See Also:: E4DecimalSign

where_DECIMALSIGN_not_in

public void where_DECIMALSIGN_not_in(E4DecimalSign[] filter)
                              throws E4DBException

Define a NOT-IN-filter (AND-ed WHERE) for column DECIMALSIGN. E4DecimalSign defined as e4s.util.E4String(1) Definition for Decimal Sign, related to Client/User Decimal Sign

Throws:: E4DBException
See Also:: E4DecimalSign

where_DECIMALSIGN_isNull

public void where_DECIMALSIGN_isNull()
                              throws E4DBException

Define a is-null filter (AND-ed WHERE) for column DECIMALSIGN. E4DecimalSign defined as e4s.util.E4String(1) Definition for Decimal Sign, related to Client/User Decimal Sign

Throws:: E4DBException
See Also:: E4DecimalSign

where_DECIMALSIGN_isNotNull

public void where_DECIMALSIGN_isNotNull()
                                 throws E4DBException

Define a is-NOT-null filter (AND-ed WHERE) for column DECIMALSIGN. E4DecimalSign defined as e4s.util.E4String(1) Definition for Decimal Sign, related to Client/User Decimal Sign

Throws:: E4DBException
See Also:: E4DecimalSign

where_DECIMALSIGN_in

public void where_DECIMALSIGN_in(E4DBSelectDistinct filter)
                          throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) DECIMALSIGN. E4DecimalSign defined as e4s.util.E4String(1) Definition for Decimal Sign, related to Client/User Decimal Sign

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

where_DECIMALSIGN_notin

public void where_DECIMALSIGN_notin(E4DBSelectDistinct filter)
                             throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) DECIMALSIGN. E4DecimalSign defined as e4s.util.E4String(1) Definition for Decimal Sign, related to Client/User Decimal Sign

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

where_DECIMALSIGN_isEmpty

public void where_DECIMALSIGN_isEmpty()
                               throws E4DBException

Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column DECIMALSIGN. E4DecimalSign defined as e4s.util.E4String(1) Definition for Decimal Sign, related to Client/User Decimal Sign

Throws:: E4DBException
See Also:: E4DecimalSign

where_DECIMALSIGN_isNotEmpty

public void where_DECIMALSIGN_isNotEmpty()
                                  throws E4DBException

Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column DECIMALSIGN. E4DecimalSign defined as e4s.util.E4String(1) Definition for Decimal Sign, related to Client/User Decimal Sign

Throws:: E4DBException
See Also:: E4DecimalSign

where_EMAIL

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

Define a filter (AND-ed WHERE) for column EMAIL. STRING(80) User´s E-Mail address

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(80) User´s E-Mail address

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(80) User´s E-Mail address

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(80) User´s E-Mail address

Throws:: E4DBException

where_EMAIL_isNull

public void where_EMAIL_isNull()
                        throws E4DBException

Define a is-null filter (AND-ed WHERE) for column EMAIL. STRING(80) User´s E-Mail address

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(80) User´s E-Mail address

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(80) User´s E-Mail address

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(80) User´s E-Mail address

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(80) User´s E-Mail address

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(80) User´s E-Mail address

Throws:: E4DBException

where_FIRSTNAME

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

Define a filter (AND-ed WHERE) for column FIRSTNAME. STRING(60) Firstname

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

where_FIRSTNAME

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

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

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

where_FIRSTNAME_in

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

Define a IN-filter (AND-ed WHERE) for column FIRSTNAME. STRING(60) Firstname

Throws:: E4DBException

where_FIRSTNAME_not_in

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

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

Throws:: E4DBException

where_FIRSTNAME_isNull

public void where_FIRSTNAME_isNull()
                            throws E4DBException

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

Throws:: E4DBException

where_FIRSTNAME_isNotNull

public void where_FIRSTNAME_isNotNull()
                               throws E4DBException

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

Throws:: E4DBException

where_FIRSTNAME_in

public void where_FIRSTNAME_in(E4DBSelectDistinct filter)
                        throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) FIRSTNAME. STRING(60) Firstname

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

where_FIRSTNAME_notin

public void where_FIRSTNAME_notin(E4DBSelectDistinct filter)
                           throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) FIRSTNAME. STRING(60) Firstname

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

where_FIRSTNAME_isEmpty

public void where_FIRSTNAME_isEmpty()
                             throws E4DBException

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

Throws:: E4DBException

where_FIRSTNAME_isNotEmpty

public void where_FIRSTNAME_isNotEmpty()
                                throws E4DBException

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

Throws:: E4DBException

where_GENDER

public void where_GENDER(E4Gender filter)
                  throws E4DBException

Define a filter (AND-ed WHERE) for column GENDER. E4Gender defined as e4s.util.E4Long male, female

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

where_GENDER

public void where_GENDER(int operator,
                         E4Gender filter)
                  throws E4DBException

Define a filter (AND-ed WHERE with operator) for column GENDER. E4Gender defined as e4s.util.E4Long male, female

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

where_GENDER_in

public void where_GENDER_in(E4DBSelectDistinct filter)
                     throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) GENDER. E4Gender defined as e4s.util.E4Long male, female

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

where_GENDER_notin

public void where_GENDER_notin(E4DBSelectDistinct filter)
                        throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) GENDER. E4Gender defined as e4s.util.E4Long male, female

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

where_LASTNAME

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

Define a filter (AND-ed WHERE) for column LASTNAME. STRING(60) Lastname

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

where_LASTNAME

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

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

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

where_LASTNAME_in

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

Define a IN-filter (AND-ed WHERE) for column LASTNAME. STRING(60) Lastname

Throws:: E4DBException

where_LASTNAME_not_in

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

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

Throws:: E4DBException

where_LASTNAME_isNull

public void where_LASTNAME_isNull()
                           throws E4DBException

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

Throws:: E4DBException

where_LASTNAME_isNotNull

public void where_LASTNAME_isNotNull()
                              throws E4DBException

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

Throws:: E4DBException

where_LASTNAME_in

public void where_LASTNAME_in(E4DBSelectDistinct filter)
                       throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) LASTNAME. STRING(60) Lastname

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

where_LASTNAME_notin

public void where_LASTNAME_notin(E4DBSelectDistinct filter)
                          throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) LASTNAME. STRING(60) Lastname

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

where_LASTNAME_isEmpty

public void where_LASTNAME_isEmpty()
                            throws E4DBException

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

Throws:: E4DBException

where_LASTNAME_isNotEmpty

public void where_LASTNAME_isNotEmpty()
                               throws E4DBException

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

Throws:: E4DBException

where_LOGIN_NAME

public void where_LOGIN_NAME(E4CompanyUserId filter)
                      throws E4DBException

Define a filter (AND-ed WHERE) for column LOGIN_NAME. E4CompanyUserId defined as e4s.util.E4String(16) User login name, unique identification for the user in the login process. UserId for login, unique identification

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

where_LOGIN_NAME

public void where_LOGIN_NAME(int operator,
                             E4CompanyUserId filter)
                      throws E4DBException

Define a filter (AND-ed WHERE with operator) for column LOGIN_NAME. E4CompanyUserId defined as e4s.util.E4String(16) User login name, unique identification for the user in the login process. UserId for login, unique identification

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

where_LOGIN_NAME_like

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

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

where_LOGIN_NAME_in

public void where_LOGIN_NAME_in(E4CompanyUserId[] filter)
                         throws E4DBException

Define a IN-filter (AND-ed WHERE) for column LOGIN_NAME. E4CompanyUserId defined as e4s.util.E4String(16) User login name, unique identification for the user in the login process. UserId for login, unique identification

Throws:: E4DBException
See Also:: E4CompanyUserId

where_LOGIN_NAME_not_in

public void where_LOGIN_NAME_not_in(E4CompanyUserId[] filter)
                             throws E4DBException

Define a NOT-IN-filter (AND-ed WHERE) for column LOGIN_NAME. E4CompanyUserId defined as e4s.util.E4String(16) User login name, unique identification for the user in the login process. UserId for login, unique identification

Throws:: E4DBException
See Also:: E4CompanyUserId

where_LOGIN_NAME_isNull

public void where_LOGIN_NAME_isNull()
                             throws E4DBException

Define a is-null filter (AND-ed WHERE) for column LOGIN_NAME. E4CompanyUserId defined as e4s.util.E4String(16) User login name, unique identification for the user in the login process. UserId for login, unique identification

Throws:: E4DBException
See Also:: E4CompanyUserId

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. E4CompanyUserId defined as e4s.util.E4String(16) User login name, unique identification for the user in the login process. UserId for login, unique identification

Throws:: E4DBException
See Also:: E4CompanyUserId

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. E4CompanyUserId defined as e4s.util.E4String(16) User login name, unique identification for the user in the login process. UserId for login, unique identification

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

where_LOGIN_NAME_notin

public void where_LOGIN_NAME_notin(E4DBSelectDistinct filter)
                            throws E4DBException

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

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. E4CompanyUserId defined as e4s.util.E4String(16) User login name, unique identification for the user in the login process. UserId for login, unique identification

Throws:: E4DBException
See Also:: E4CompanyUserId

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. E4CompanyUserId defined as e4s.util.E4String(16) User login name, unique identification for the user in the login process. UserId for login, unique identification

Throws:: E4DBException
See Also:: E4CompanyUserId

where_LOGIN_PASSWORD

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

Define a filter (AND-ed WHERE) for column LOGIN_PASSWORD. STRING(32) Password

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

where_LOGIN_PASSWORD

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

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

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

where_LOGIN_PASSWORD_in

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

Define a IN-filter (AND-ed WHERE) for column LOGIN_PASSWORD. STRING(32) Password

Throws:: E4DBException

where_LOGIN_PASSWORD_not_in

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

Define a NOT-IN-filter (AND-ed WHERE) for column LOGIN_PASSWORD. STRING(32) Password

Throws:: E4DBException

where_LOGIN_PASSWORD_isNull

public void where_LOGIN_PASSWORD_isNull()
                                 throws E4DBException

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

Throws:: E4DBException

where_LOGIN_PASSWORD_isNotNull

public void where_LOGIN_PASSWORD_isNotNull()
                                    throws E4DBException

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

Throws:: E4DBException

where_LOGIN_PASSWORD_in

public void where_LOGIN_PASSWORD_in(E4DBSelectDistinct filter)
                             throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) LOGIN_PASSWORD. STRING(32) Password

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

where_LOGIN_PASSWORD_notin

public void where_LOGIN_PASSWORD_notin(E4DBSelectDistinct filter)
                                throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) LOGIN_PASSWORD. STRING(32) Password

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

where_LOGIN_PASSWORD_isEmpty

public void where_LOGIN_PASSWORD_isEmpty()
                                  throws E4DBException

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

Throws:: E4DBException

where_LOGIN_PASSWORD_isNotEmpty

public void where_LOGIN_PASSWORD_isNotEmpty()
                                     throws E4DBException

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

Throws:: E4DBException

where_MIDDLENAME

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

Define a filter (AND-ed WHERE) for column MIDDLENAME. STRING(1) Middlename

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

where_MIDDLENAME

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

Define a filter (AND-ed WHERE with operator) for column MIDDLENAME. STRING(1) Middlename

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

where_MIDDLENAME_in

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

Define a IN-filter (AND-ed WHERE) for column MIDDLENAME. STRING(1) Middlename

Throws:: E4DBException

where_MIDDLENAME_not_in

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

Define a NOT-IN-filter (AND-ed WHERE) for column MIDDLENAME. STRING(1) Middlename

Throws:: E4DBException

where_MIDDLENAME_isNull

public void where_MIDDLENAME_isNull()
                             throws E4DBException

Define a is-null filter (AND-ed WHERE) for column MIDDLENAME. STRING(1) Middlename

Throws:: E4DBException

where_MIDDLENAME_isNotNull

public void where_MIDDLENAME_isNotNull()
                                throws E4DBException

Define a is-NOT-null filter (AND-ed WHERE) for column MIDDLENAME. STRING(1) Middlename

Throws:: E4DBException

where_MIDDLENAME_in

public void where_MIDDLENAME_in(E4DBSelectDistinct filter)
                         throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) MIDDLENAME. STRING(1) Middlename

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

where_MIDDLENAME_notin

public void where_MIDDLENAME_notin(E4DBSelectDistinct filter)
                            throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) MIDDLENAME. STRING(1) Middlename

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

where_MIDDLENAME_isEmpty

public void where_MIDDLENAME_isEmpty()
                              throws E4DBException

Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column MIDDLENAME. STRING(1) Middlename

Throws:: E4DBException

where_MIDDLENAME_isNotEmpty

public void where_MIDDLENAME_isNotEmpty()
                                 throws E4DBException

Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column MIDDLENAME. STRING(1) Middlename

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) Free 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) Free 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) Free 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) Free 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) Free 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) Free 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) Free 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) Free 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) Free 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) Free Remark

Throws:: E4DBException

where_SATURATION

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

Define a filter (AND-ed WHERE) for column SATURATION. STRING(12) Saturation (e.g. Dr.)

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

where_SATURATION

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

Define a filter (AND-ed WHERE with operator) for column SATURATION. STRING(12) Saturation (e.g. Dr.)

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

where_SATURATION_in

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

Define a IN-filter (AND-ed WHERE) for column SATURATION. STRING(12) Saturation (e.g. Dr.)

Throws:: E4DBException

where_SATURATION_not_in

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

Define a NOT-IN-filter (AND-ed WHERE) for column SATURATION. STRING(12) Saturation (e.g. Dr.)

Throws:: E4DBException

where_SATURATION_isNull

public void where_SATURATION_isNull()
                             throws E4DBException

Define a is-null filter (AND-ed WHERE) for column SATURATION. STRING(12) Saturation (e.g. Dr.)

Throws:: E4DBException

where_SATURATION_isNotNull

public void where_SATURATION_isNotNull()
                                throws E4DBException

Define a is-NOT-null filter (AND-ed WHERE) for column SATURATION. STRING(12) Saturation (e.g. Dr.)

Throws:: E4DBException

where_SATURATION_in

public void where_SATURATION_in(E4DBSelectDistinct filter)
                         throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) SATURATION. STRING(12) Saturation (e.g. Dr.)

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

where_SATURATION_notin

public void where_SATURATION_notin(E4DBSelectDistinct filter)
                            throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) SATURATION. STRING(12) Saturation (e.g. Dr.)

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

where_SATURATION_isEmpty

public void where_SATURATION_isEmpty()
                              throws E4DBException

Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column SATURATION. STRING(12) Saturation (e.g. Dr.)

Throws:: E4DBException

where_SATURATION_isNotEmpty

public void where_SATURATION_isNotEmpty()
                                 throws E4DBException

Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column SATURATION. STRING(12) Saturation (e.g. Dr.)

Throws:: E4DBException

where_TIMEFORMAT

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

Define a filter (AND-ed WHERE) for column TIMEFORMAT. STRING(10) Time-Format, e.g. HH:mm:ss

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

where_TIMEFORMAT

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

Define a filter (AND-ed WHERE with operator) for column TIMEFORMAT. STRING(10) Time-Format, e.g. HH:mm:ss

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

where_TIMEFORMAT_in

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

Define a IN-filter (AND-ed WHERE) for column TIMEFORMAT. STRING(10) Time-Format, e.g. HH:mm:ss

Throws:: E4DBException

where_TIMEFORMAT_not_in

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

Define a NOT-IN-filter (AND-ed WHERE) for column TIMEFORMAT. STRING(10) Time-Format, e.g. HH:mm:ss

Throws:: E4DBException

where_TIMEFORMAT_isNull

public void where_TIMEFORMAT_isNull()
                             throws E4DBException

Define a is-null filter (AND-ed WHERE) for column TIMEFORMAT. STRING(10) Time-Format, e.g. HH:mm:ss

Throws:: E4DBException

where_TIMEFORMAT_isNotNull

public void where_TIMEFORMAT_isNotNull()
                                throws E4DBException

Define a is-NOT-null filter (AND-ed WHERE) for column TIMEFORMAT. STRING(10) Time-Format, e.g. HH:mm:ss

Throws:: E4DBException

where_TIMEFORMAT_in

public void where_TIMEFORMAT_in(E4DBSelectDistinct filter)
                         throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) TIMEFORMAT. STRING(10) Time-Format, e.g. HH:mm:ss

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

where_TIMEFORMAT_notin

public void where_TIMEFORMAT_notin(E4DBSelectDistinct filter)
                            throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) TIMEFORMAT. STRING(10) Time-Format, e.g. HH:mm:ss

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

where_TIMEFORMAT_isEmpty

public void where_TIMEFORMAT_isEmpty()
                              throws E4DBException

Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column TIMEFORMAT. STRING(10) Time-Format, e.g. HH:mm:ss

Throws:: E4DBException

where_TIMEFORMAT_isNotEmpty

public void where_TIMEFORMAT_isNotEmpty()
                                 throws E4DBException

Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column TIMEFORMAT. STRING(10) Time-Format, e.g. HH:mm:ss

Throws:: E4DBException

where_TIMEZONE

public void where_TIMEZONE(TimeZone filter)
                    throws E4DBException

Define a filter (AND-ed WHERE) for column TIMEZONE. TimeZone Relative Timezone to GMT

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

where_TIMEZONE

public void where_TIMEZONE(int operator,
                           TimeZone filter)
                    throws E4DBException

Define a filter (AND-ed WHERE with operator) for column TIMEZONE. TimeZone Relative Timezone to GMT

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

where_TIMEZONE_in

public void where_TIMEZONE_in(E4DBSelectDistinct filter)
                       throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) TIMEZONE. TimeZone Relative Timezone to GMT

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

where_TIMEZONE_notin

public void where_TIMEZONE_notin(E4DBSelectDistinct filter)
                          throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) TIMEZONE. TimeZone Relative Timezone to GMT

Parameters:: filter - the value to be compared within the SQL statement
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

getReferenceDelete

public E4DBReference[] getReferenceDelete(E4DBColumnName cName)

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")

getReferenceLookup

public E4DBReference[] getReferenceLookup(E4DBColumnName cName)

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")

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_LOGIN

public static T_E4S_COMPANY_USER_Obj find_LOGIN(E4ApplObj_Intf appobj,
                                                E4CompanyId qCOMPANY_ID,
                                                E4CompanyUserId qLOGIN_NAME)
                                         throws E4DBException

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

Parameters:: appobj - the current application object containing client informations; qCOMPANY_ID - query Related Company ID; qLOGIN_NAME - query UserId for login, unique identification
Throws:: E4DBException

find_LOGIN

public static T_E4S_COMPANY_USER_Obj find_LOGIN(E4ApplObj_Intf appobj,
                                                E4CompanyId qCOMPANY_ID,
                                                E4CompanyUserId qLOGIN_NAME,
                                                boolean readfreefields)
                                         throws E4DBException

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

Parameters:: appobj - the current application object containing client informations; qCOMPANY_ID - query Related Company ID; qLOGIN_NAME - query UserId for login, unique identification; readfreefields - read also the freefield values if true
Throws:: E4DBException

find_LOGIN

public static T_E4S_COMPANY_USER_Obj find_LOGIN(E4DBConnection_Intf con,
                                                E4ApplObj_Intf appobj,
                                                E4CompanyId qCOMPANY_ID,
                                                E4CompanyUserId qLOGIN_NAME)
                                         throws E4DBException

Find a record associates with index 1 (LOGIN).

Parameters:: con - the database connection; appobj - the current application object containing client informations; qCOMPANY_ID - query Related Company ID; qLOGIN_NAME - query UserId for login, unique identification
Throws:: E4DBException

find_LOGIN

public static T_E4S_COMPANY_USER_Obj find_LOGIN(E4DBConnection_Intf con,
                                                E4ApplObj_Intf appobj,
                                                E4CompanyId qCOMPANY_ID,
                                                E4CompanyUserId qLOGIN_NAME,
                                                boolean readfreefields)
                                         throws E4DBException

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

Parameters:: con - the database connection; appobj - the current application object containing client informations; qCOMPANY_ID - query Related Company ID; qLOGIN_NAME - query UserId for login, unique identification; readfreefields - read also the freefield values if true
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_USER.
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 LOGIN

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.

find_LOGIN

public static T_E4S_COMPANY_USER_Obj find_LOGIN(E4ApplObj_Intf applobj,
                                                E4User user)
                                         throws E4DBException

Throws:: E4DBException

find_LOGIN

public static T_E4S_COMPANY_USER_Obj find_LOGIN(E4ApplObj_Intf applobj)
                                         throws E4DBException

Throws:: E4DBException

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_USER_Sel

TABLENAME

SVN_REVISION

IS_CLIENT_DISTINCTIVE

IS_FREEDEF_POSSIBLE

COL_COMPANY_ID

CI_COMPANY_ID

COL_DATEFORMAT

CI_DATEFORMAT

COL_DATMOD

CI_DATMOD

COL_DATNEW

CI_DATNEW

COL_DECIMALSIGN

CI_DECIMALSIGN

COL_EMAIL

CI_EMAIL

COL_FIRSTNAME

CI_FIRSTNAME

COL_GENDER

CI_GENDER

COL_LASTNAME

CI_LASTNAME

COL_LOGIN_NAME

CI_LOGIN_NAME

COL_LOGIN_PASSWORD

CI_LOGIN_PASSWORD

COL_MIDDLENAME

CI_MIDDLENAME

COL_REM

CI_REM

COL_SATURATION

CI_SATURATION

COL_TIMEFORMAT

CI_TIMEFORMAT

COL_TIMEZONE

CI_TIMEZONE

COL_VALID_UNTIL

CI_VALID_UNTIL

COLUMNS

IDX_LOGIN

IDX2

INDEXES

T_E4S_COMPANY_USER_Sel

T_E4S_COMPANY_USER_Sel

T_E4S_COMPANY_USER_Sel

or

makeInstance

E4ID

hasClientDistinctive

canHaveFreeDefinedFields

getModifyClass

makeInstance_Modify

getObjectClass

getColInfo

getIdxInfo

getFirstPrimaryIndex

next

get_CLIENT

get_COMPANY_ID

get_DATEFORMAT

get_DATMOD

get_DATNEW

get_DECIMALSIGN

get_EMAIL

get_FIRSTNAME

get_GENDER

get_LASTNAME

get_LOGIN_NAME

get_LOGIN_PASSWORD

get_MIDDLENAME

get_REM

get_SATURATION

get_TIMEFORMAT

get_TIMEZONE

get_VALID_UNTIL

get

get

getQuery

getQuery

e4s.db.systabledef
Class T_E4S_COMPANY_USER_Sel