Screenshot:Datasource

From InfiniteERP Wiki
Jump to: navigation, search
Back button.png   Back to Screens_Reference


Datasource

A datasource is used to provide data to user interface components running on the client. The data can be read from the database or can be computed at runtime in memory. Data consists mostly of records with fields which are displayed on the client in forms and grids.

Datasources

A datasource provides data to a client side user interface component (like a form or grid). The datasource reads for example data from a database table but can also provide data which is computed in real time at runtime. A datasource typically supports the 4 crud operations: create, fetch, update and delete. The fields of the records returned by the datasource are defined as the datasource field.

  • Module : Module
  • Name : A non-unique identifier for a record/document often used as a search tool.
  • Description : A space to write additional related information.
  • Table : A dictionary table used for this tab that points to the database table.
  • HQL Where Clause : The HQL where clause used to filter and query for data.
  • Java class name : Class implementing the functionality in java
  • Template : The template used to generate the client-side representation.
  • Use As Table Data Origin : A flag indicating whether this datasource is used as a data origin in the Table window
  • Support Filtering Foreign Key Columns Using Their ID : If this flag is checked, when a foreign key is filtered by selecting a value from the filter drop down, the foreign key will be filtered using its id.
  • Active : A flag indicating whether this record is available for use or de-activated.
  • Organization : Organizational entity within client
  • Datasource : The datasource
  • Client : Client for this installation.

Datasource field

A datasource provides data from the database. Each data instance (record) in the data source has one or more fields. The technical property name and type are defined in the Openbravo Datasource Field tab.

  • Name : A non-unique identifier for a record/document often used as a search tool.
  • Description : A space to write additional related information.
  • Reference : The data type of this field.
  • Table : A dictionary table used for this tab that points to the database table.
  • Active : A flag indicating whether this record is available for use or de-activated.
  • Organization : Organizational entity within client
  • Datasource Field : The datasource field is part of the datasource definition.
  • Datasource : The datasource
  • Client : Client for this installation.
Back button.png   Back to Screens_Reference