The Cache data source stores real-time data from data attachments in memory resident tables, which can themselves be used as data sources. See the Caches section for information on adding a cache.

From the Object Properties window you can access the Attach to Cache Data dialog to connect an object property to this in-memory data. Once a property has been attached to cache data, it receives continuous updates.

When an object property is attached to data, the Property Name and Value in the Object Properties window will be displayed in green. This indicates that editing this value from the Object Properties window is no longer possible. To remove the data attachment, and resume editing capability in the Object Properties window, right-click on the Property Name and select Detach from Data. You will recognize that an object property has been detached from the data source when the Property Name and Value are no longer green.
 

To bring up the Attach to Cache Data dialog, right-click on the Property Name from the Object Properties window and select Attach to Data>Cache. The Attach to Cache Data dialog provides four drop down menus that allow you to specify information regarding the cache data you want to display.

It is possible to indicate multiple columns for the filter and multiple values to compare against for each column. If the number of specified column names does not correspond to the number of values listed, then extra names and/or values are ignored. NOTE: Spaces around separators are not allowed.
 

Cache	Name of the cache to display. The drop down menu will contain the names of all active caches. See the Caches section for information on adding a cache.
Table	Select which type of table data to display: Current or History.
Column(s)	Select which column(s) to display from the selected Table.
Filter Rows	Checkbox to indicate whether or not to filter rows. Filters can only be used for tabular data.
Filter Column	Name of the column to use as a filter. Multiple column names should be entered as a semicolon (;) delimited list (i.e. col1;col2;col 3). If your column name contains a space or a semicolon, then the entire name must be enclosed in single quotes.
Filter Value	Value that the Filter Column must equal. Multiple filter values should be entered as a nested list, where values for a given column are separated by commas within a semicolon (;) delimited list (i.e. val1,val2;val3,val4;val5,val6). If your filter value contains a space or a semicolon, then the entire value must be enclosed in single quotes. When * is entered as a filter field value, data for all values in the specified filter column will be used to update the object property. When "*" is entered, only the literal comparative value will be used. These are only allowed for objects which display tabular data.
Update Once	Check box to only update listeners once.
Data Server	Select to read data through your configured Data Server and not directly from the Cache data source. Default - Select the default Data Server you configured in Application Options>Data Server. None - Bypass data being redirected through the specified data server(s) for this attachment and instead attach directly to the data source. Named Data Servers - Select a Named Data Server that you configured in Application Options>Data Server.

The Cache drop down menu lists all available caches. Drop down menus for Column(s) and Filter Column populate based on the selected Cache and Table. The Table, Column(s) and Filter Column drop down menus will only contain options if the selected Cache contains tabular information. If the item you require is not listed, type your selection into the field. For information on adding caches, see Application Options.

The following describes the significance of the Attach to Cache Data validation colors:
 

	Blue	Unknown	Entry does not match any known Cache.
	White	Valid state	Entry is valid.
	Red	Invalid state	Cache is valid, but Column(s) or Filter Column selected are not.

Substitutions
Substitutions allow you to build open-ended displays in which data attachments depend on values defined at the time the display is run. Generic names, such as $cache1 and $cache2, are used instead of values for specific cache names. Later when the display is running, these generic values are defined by the actual names of specific cache names. In this way, a single display can be reused to show data from a number of different sources. For more information on creating displays using substitution values, see Substitutions.

Select Table Columns
From the Attach to Cache Data dialog you can specify which table columns to display and in what order they will appear. In order to populate the listing of available columns, you must first select a valid Cache.

To bring up the Select Columns dialog, click on the ellipse button in the Column(s) field (or right-click in the Column(s) field and choose Select Columns). The dialog should contain a list of Available Columns that you can add to your table.

To add a column, select an item from the Available Columns list and click on the Add button. If the item you require is not listed, type your selection into the Enter Column Name field. Click the Remove button to delete an item previously added to the Selected Columns list. You can control the order of columns in a table by arranging the items in the Selected Columns list with the Move Up and Move Down buttons.

If no data is available for a table row within a selected column, the table cell will display one the following values: N/A, false, 0, or 0.0.
 

The following describes the Attach to Cache Data dialog commands:
 

Command	Description
OK	Applies values and closes the dialog.
Apply	Applies values without closing the dialog.
Reset	Resets all fields to last values applied.
Clear	Clears all fields. Detaches object from data source (once Apply or OK is selected).
Cancel	Closes the dialog with last values applied.