Package org.openbravo.model.ad.utility

Class DataSetTable

java.lang.Object

org.openbravo.base.structure.BaseOBObject

org.openbravo.model.ad.utility.DataSetTable

All Implemented Interfaces:

Serializable, BaseOBObjectDef, OBNotSingleton, OBProvidable, ActiveEnabled, ClientEnabled, DynamicEnabled, Identifiable, OrganizationEnabled, Traceable

public class DataSetTable
extends BaseOBObject
implements Traceable, ClientEnabled, OrganizationEnabled, ActiveEnabled

Entity class for entity DataSetTable (stored in table AD_Dataset_Table).
Help: Tables of a Dataset.
NOTE: This class should not be instantiated directly. To instantiate this class the OBProvider should be used.

See Also:

Serialized Form

Field Summary

Fields

Modifier and Type	Field	Description
static String	ENTITY_NAME
static String	PROPERTY_ACTIVE	Property active stored in column IsActive in table AD_Dataset_Table
static String	PROPERTY_CLIENT	Property client stored in column AD_Client_ID in table AD_Dataset_Table
static String	PROPERTY_CREATEDBY	Property createdBy stored in column CreatedBy in table AD_Dataset_Table
static String	PROPERTY_CREATIONDATE	Property creationDate stored in column Created in table AD_Dataset_Table
static String	PROPERTY_DATASET	Property dataset stored in column AD_Dataset_ID in table AD_Dataset_Table Help: Indicates the dataset the element forms part of.
static String	PROPERTY_DATASETCOLUMNLIST	Property dataSetColumnList stored in table AD_Dataset_Table
static String	PROPERTY_EXCLUDEAUDITINFO	Property excludeAuditInfo stored in column excludeAuditInfo in table AD_Dataset_Table Help: Mark if the dataset table should exclude the audit info when comparing data
static String	PROPERTY_ID	Property id stored in column AD_Dataset_Table_ID in table AD_Dataset_Table Help: Indicates the dataset table the element forms part of.
static String	PROPERTY_INCLUDEALLCOLUMNS	Property includeAllColumns stored in column IncludeAllColumns in table AD_Dataset_Table Help: Include all columns from the table in the dataset
static String	PROPERTY_ISBUSINESSOBJECT	Property isBusinessObject stored in column IsBusinessObject in table AD_Dataset_Table Help: Include Business Object determines whether the whole object is going to be taken into account.
static String	PROPERTY_MODULE	Property module stored in column AD_Module_ID in table AD_Dataset_Table Help: Indicates the module the element forms part of.
static String	PROPERTY_ORGANIZATION	Property organization stored in column AD_Org_ID in table AD_Dataset_Table
static String	PROPERTY_SECONDARYWHERECLAUSE	Property secondarywhereclause stored in column Secondarywhereclause in table AD_Dataset_Table Help: This is a secondary SQL where clause used by dbsourcemanager to filter data inside a table. This secondary whereclause needs to be written in SQL, and only applies for the dataset AD. When export.database is executed, this whereclause will be applied for the data inside the table, and only the records complying with it will be exported. The rest of the records (the ones which do not comply with the whereclause) will be ignored both in export.database and update.database. The main purpose of this whereclause is to select which of the records in a particular table are part of sourcedata, and which ones are part of client data.
static String	PROPERTY_SQLWHERECLAUSE	Property sQLWhereClause stored in column WhereClause in table AD_Dataset_Table Help: The Where Clause indicates the HQL (Hibernate Query Language) or SQL WHERE clause used for filtering data. In releases until and including 2.50 MP11 this field only accepts a HQL where clause (without the where keyword). In later releases for the AD dataset a SQL clause should be used, other datasets should use the HQL format.
static String	PROPERTY_TABLE	Property table stored in column AD_Table_ID in table AD_Dataset_Table Help: The Table indicates the table in which a field or fields reside.
static String	PROPERTY_UPDATED	Property updated stored in column Updated in table AD_Dataset_Table
static String	PROPERTY_UPDATEDBY	Property updatedBy stored in column UpdatedBy in table AD_Dataset_Table
static String	TABLE_NAME

Fields inherited from class org.openbravo.base.structure.BaseOBObject

ID

Constructor Summary

Constructors

Constructor	Description
DataSetTable()

Method Summary

Modifier and Type	Method	Description
Client	getClient()	Client field
User	getCreatedBy()	Created by audit user
Date	getCreationDate()	Creation date of audit
DataSet	getDataset()
List<DataSetColumn>	getDataSetColumnList()	Help: Columns of a table from a Dataset.
String	getEntityName()
String	getId()
Module	getModule()
Organization	getOrganization()	Gets organization field
String	getSecondarywhereclause()
String	getSQLWhereClause()
Table	getTable()
Date	getUpdated()	Update date of audit
User	getUpdatedBy()	Update by audit user
Boolean	isActive()	Gets active field
Boolean	isBusinessObject()
Boolean	isExcludeAuditInfo()
Boolean	isIncludeAllColumns()
void	setActive(Boolean active)	Sets active field
void	setBusinessObject(Boolean isBusinessObject)
void	setClient(Client client)	Client field
void	setCreatedBy(User createdBy)	Created by audit user
void	setCreationDate(Date creationDate)	Creation date of audit
void	setDataset(DataSet dataset)
void	setDataSetColumnList(List<DataSetColumn> dataSetColumnList)	Help: Columns of a table from a Dataset.
void	setExcludeAuditInfo(Boolean excludeAuditInfo)
void	setId(String id)
void	setIncludeAllColumns(Boolean includeAllColumns)
void	setModule(Module module)
void	setOrganization(Organization organization)	Sets organization field
void	setSecondarywhereclause(String secondarywhereclause)
void	setSQLWhereClause(String sQLWhereClause)
void	setTable(Table table)
void	setUpdated(Date updated)	Update date of audit
void	setUpdatedBy(User updatedBy)	Update by audit user

Methods inherited from class org.openbravo.base.structure.BaseOBObject

checkDerivedReadable, get, get, get, getEntity, getIdentifier, getValue, isAllowRead, isNewOBObject, isOrgClientAccessCheckEnabled, isWriteAccessCheckEnabled, set, setAccessChecks, setAllowRead, setDefaultValue, setId, setNewOBObject, setValue, toString, validate

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Field Detail

TABLE_NAME

public static final String TABLE_NAME

See Also:

Constant Field Values

ENTITY_NAME

public static final String ENTITY_NAME

See Also:

Constant Field Values

PROPERTY_ID

public static final String PROPERTY_ID

Property id stored in column AD_Dataset_Table_ID in table AD_Dataset_Table
Help: Indicates the dataset table the element forms part of.

See Also:

Constant Field Values

PROPERTY_CLIENT

public static final String PROPERTY_CLIENT

Property client stored in column AD_Client_ID in table AD_Dataset_Table

See Also:

ClientEnabled, Constant Field Values

PROPERTY_ORGANIZATION

public static final String PROPERTY_ORGANIZATION

Property organization stored in column AD_Org_ID in table AD_Dataset_Table

See Also:

OrganizationEnabled, Constant Field Values

PROPERTY_ACTIVE

public static final String PROPERTY_ACTIVE

Property active stored in column IsActive in table AD_Dataset_Table

See Also:

ActiveEnabled, Constant Field Values

PROPERTY_CREATIONDATE

public static final String PROPERTY_CREATIONDATE

Property creationDate stored in column Created in table AD_Dataset_Table

See Also:

Traceable, Constant Field Values

PROPERTY_CREATEDBY

public static final String PROPERTY_CREATEDBY

Property createdBy stored in column CreatedBy in table AD_Dataset_Table

See Also:

Traceable, Constant Field Values

PROPERTY_UPDATED

public static final String PROPERTY_UPDATED

Property updated stored in column Updated in table AD_Dataset_Table

See Also:

Traceable, Constant Field Values

PROPERTY_UPDATEDBY

public static final String PROPERTY_UPDATEDBY

Property updatedBy stored in column UpdatedBy in table AD_Dataset_Table

See Also:

Traceable, Constant Field Values

PROPERTY_DATASET

public static final String PROPERTY_DATASET

Property dataset stored in column AD_Dataset_ID in table AD_Dataset_Table
Help: Indicates the dataset the element forms part of.

See Also:

Constant Field Values

PROPERTY_TABLE

public static final String PROPERTY_TABLE

Property table stored in column AD_Table_ID in table AD_Dataset_Table
Help: The Table indicates the table in which a field or fields reside.

See Also:

Constant Field Values

PROPERTY_INCLUDEALLCOLUMNS

public static final String PROPERTY_INCLUDEALLCOLUMNS

Property includeAllColumns stored in column IncludeAllColumns in table AD_Dataset_Table
Help: Include all columns from the table in the dataset

See Also:

Constant Field Values

PROPERTY_SQLWHERECLAUSE

public static final String PROPERTY_SQLWHERECLAUSE

Property sQLWhereClause stored in column WhereClause in table AD_Dataset_Table
Help: The Where Clause indicates the HQL (Hibernate Query Language) or SQL WHERE clause used for filtering data. In releases until and including 2.50 MP11 this field only accepts a HQL where clause (without the where keyword). In later releases for the AD dataset a SQL clause should be used, other datasets should use the HQL format.

See Also:

Constant Field Values

PROPERTY_EXCLUDEAUDITINFO

public static final String PROPERTY_EXCLUDEAUDITINFO

Property excludeAuditInfo stored in column excludeAuditInfo in table AD_Dataset_Table
Help: Mark if the dataset table should exclude the audit info when comparing data

See Also:

Constant Field Values

PROPERTY_ISBUSINESSOBJECT

public static final String PROPERTY_ISBUSINESSOBJECT

Property isBusinessObject stored in column IsBusinessObject in table AD_Dataset_Table
Help: Include Business Object determines whether the whole object is going to be taken into account.

See Also:

Constant Field Values

PROPERTY_MODULE

public static final String PROPERTY_MODULE

Property module stored in column AD_Module_ID in table AD_Dataset_Table
Help: Indicates the module the element forms part of.

See Also:

Constant Field Values

PROPERTY_SECONDARYWHERECLAUSE

public static final String PROPERTY_SECONDARYWHERECLAUSE

Property secondarywhereclause stored in column Secondarywhereclause in table AD_Dataset_Table
Help: This is a secondary SQL where clause used by dbsourcemanager to filter data inside a table. This secondary whereclause needs to be written in SQL, and only applies for the dataset AD. When export.database is executed, this whereclause will be applied for the data inside the table, and only the records complying with it will be exported. The rest of the records (the ones which do not comply with the whereclause) will be ignored both in export.database and update.database. The main purpose of this whereclause is to select which of the records in a particular table are part of sourcedata, and which ones are part of client data.

See Also:

Constant Field Values

PROPERTY_DATASETCOLUMNLIST

public static final String PROPERTY_DATASETCOLUMNLIST

Property dataSetColumnList stored in table AD_Dataset_Table

See Also:

Constant Field Values

Constructor Detail

DataSetTable

public DataSetTable()

Method Detail

getEntityName

public String getEntityName()

Specified by:

getEntityName in interface Identifiable

Specified by:

getEntityName in class BaseOBObject

getId

public String getId()

Specified by:

getId in interface BaseOBObjectDef

Specified by:

getId in interface Identifiable

Overrides:

getId in class BaseOBObject

See Also:

PROPERTY_ID

setId

public void setId(String id)

See Also:

PROPERTY_ID

getClient

public Client getClient()

Description copied from interface: ClientEnabled

Client field

Specified by:

getClient in interface ClientEnabled

Returns:

client

See Also:

PROPERTY_CLIENT

setClient

public void setClient(Client client)

Description copied from interface: ClientEnabled

Client field

Specified by:

setClient in interface ClientEnabled

See Also:

PROPERTY_CLIENT

getOrganization

public Organization getOrganization()

Description copied from interface: OrganizationEnabled

Gets organization field

Specified by:

getOrganization in interface OrganizationEnabled

Returns:

organization

See Also:

PROPERTY_ORGANIZATION

setOrganization

public void setOrganization(Organization organization)

Description copied from interface: OrganizationEnabled

Sets organization field

Specified by:

setOrganization in interface OrganizationEnabled

See Also:

PROPERTY_ORGANIZATION

isActive

public Boolean isActive()

Description copied from interface: ActiveEnabled

Gets active field

Specified by:

isActive in interface ActiveEnabled

Returns:

active

See Also:

PROPERTY_ACTIVE

setActive

public void setActive(Boolean active)

Description copied from interface: ActiveEnabled

Sets active field

Specified by:

setActive in interface ActiveEnabled

See Also:

PROPERTY_ACTIVE

getCreationDate

public Date getCreationDate()

Description copied from interface: Traceable

Creation date of audit

Specified by:

getCreationDate in interface Traceable

Returns:

Date of creation

See Also:

PROPERTY_CREATIONDATE

setCreationDate

public void setCreationDate(Date creationDate)

Description copied from interface: Traceable

Creation date of audit

Specified by:

setCreationDate in interface Traceable

See Also:

PROPERTY_CREATIONDATE

getCreatedBy

public User getCreatedBy()

Description copied from interface: Traceable

Created by audit user

Specified by:

getCreatedBy in interface Traceable

Returns:

User

See Also:

PROPERTY_CREATEDBY

setCreatedBy

public void setCreatedBy(User createdBy)

Description copied from interface: Traceable

Created by audit user

Specified by:

setCreatedBy in interface Traceable

See Also:

PROPERTY_CREATEDBY

getUpdated

public Date getUpdated()

Description copied from interface: Traceable

Update date of audit

Specified by:

getUpdated in interface Traceable

Returns:

Date of update

See Also:

PROPERTY_UPDATED

setUpdated

public void setUpdated(Date updated)

Description copied from interface: Traceable

Update date of audit

Specified by:

setUpdated in interface Traceable

See Also:

PROPERTY_UPDATED

getUpdatedBy

public User getUpdatedBy()

Description copied from interface: Traceable

Update by audit user

Specified by:

getUpdatedBy in interface Traceable

Returns:

User who updated

See Also:

PROPERTY_UPDATEDBY

setUpdatedBy

public void setUpdatedBy(User updatedBy)

Description copied from interface: Traceable

Update by audit user

Specified by:

setUpdatedBy in interface Traceable

See Also:

PROPERTY_UPDATEDBY

getDataset

public DataSet getDataset()

See Also:

PROPERTY_DATASET

setDataset

public void setDataset(DataSet dataset)

See Also:

PROPERTY_DATASET

getTable

public Table getTable()

See Also:

PROPERTY_TABLE

setTable

public void setTable(Table table)

See Also:

PROPERTY_TABLE

isIncludeAllColumns

public Boolean isIncludeAllColumns()

See Also:

PROPERTY_INCLUDEALLCOLUMNS

setIncludeAllColumns

public void setIncludeAllColumns(Boolean includeAllColumns)

See Also:

PROPERTY_INCLUDEALLCOLUMNS

getSQLWhereClause

public String getSQLWhereClause()

See Also:

PROPERTY_SQLWHERECLAUSE

setSQLWhereClause

public void setSQLWhereClause(String sQLWhereClause)

See Also:

PROPERTY_SQLWHERECLAUSE

isExcludeAuditInfo

public Boolean isExcludeAuditInfo()

See Also:

PROPERTY_EXCLUDEAUDITINFO

setExcludeAuditInfo

public void setExcludeAuditInfo(Boolean excludeAuditInfo)

See Also:

PROPERTY_EXCLUDEAUDITINFO

isBusinessObject

public Boolean isBusinessObject()

See Also:

PROPERTY_ISBUSINESSOBJECT

setBusinessObject

public void setBusinessObject(Boolean isBusinessObject)

See Also:

PROPERTY_ISBUSINESSOBJECT

getModule

public Module getModule()

See Also:

PROPERTY_MODULE

setModule

public void setModule(Module module)

See Also:

PROPERTY_MODULE

getSecondarywhereclause

public String getSecondarywhereclause()

See Also:

PROPERTY_SECONDARYWHERECLAUSE

setSecondarywhereclause

public void setSecondarywhereclause(String secondarywhereclause)

See Also:

PROPERTY_SECONDARYWHERECLAUSE

getDataSetColumnList

public List<DataSetColumn> getDataSetColumnList()

Help: Columns of a table from a Dataset.

See Also:

DataSetColumn

setDataSetColumnList

public void setDataSetColumnList(List<DataSetColumn> dataSetColumnList)

Help: Columns of a table from a Dataset.

See Also:

DataSetColumn