A data table definition defines a set of records that are stored on the Client. Each record contains a key field and a value field. The table is intended to contain fewer than 100 records that can be used in drop-down lists or for other purposes. A data table is defined at the application level and is available to all modules of the application. Its structure defines how its data is synchronized.
The intended purpose of a data table is to provide short lists of records that can be created quickly and with little overhead. A data table has no built-in search support; in fact, if searching is required, it can only be performed row-by-row (for example, no binary or other search algorithms can be employed).
As part of its definition, the data table contains the components to synchronize data. This includes determining if new data is needed for the table, as well as retrieving the records for the data table. A data table definition requires an existing system connection. The type of synchronization components a data table contains is based on the type of that system connection.
Though the synchronization components differ in form and structure related to the type of back-end system for which they are intended, they are required to always return two general categories of data to the Agentry Server. The first is a date and time value that indicates the time the data source was last modified in the back-end system. The second is the actual data for the data table’s records.
The date and time value is compared to a date and time value that is stored internally on the Agentry Client for each data table instance. This internal value is called the data table’s last update value, and indicates when the data table was downloaded to the Agentry Client. When the date and time retrieved from the back end is newer than the Agentry Client last update value for the data table, the records for the data table must be retrieved. The existing records on the Agentry Client are deleted and replaced with the new data. This is an all-or-none operation; individual records cannot be selectively replaced.
Data Table Attributes
- Name: The name of the data table. This value must be unique among all data tables that are defined for the application.
- Display Name: The default text that appears to the user on the Agentry Server for the data table.
- Connection: The system connection defined for the back-end system that contains the data source for the data table. This attribute is set when the table is created. It cannot be edited for an existing data table definition. The system connection must exist before the data table is defined.
- Reload: Whether to reload the records when a user change occurs on the Agentry Client. When true, all records in the data table are deleted and reloaded during the first transmit of the new user. Otherwise, the records remain on the Agentry Client during the user change. Set the Reload attribute to true when the data table contains records that are user-specific.