Attach to Data

From the Object Properties window you can access the Attach to Data dialog, which is used to connect an object property to any active data source, as well as alerts, functions and variables. See “Attach to Alert Data”, “Attach to Function Data”, and “Attach to Variable Data” for more information. Depending on your version of RTView, there are several data sources available. For detailed information on the Attach to Data dialog for your data source, refer to the “RTView Data Sources” section of this documentation.

To bring up the Attach to Data dialog, right-click on a Property Name from the Object Properties window and select Attach to Data for your data source. Once a property has been attached to 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.

If an object property is attached to data, right-click on the Property Name and select Display Data to open a window that contains a table showing data available from that attachment. If the object property is attached to tabular data, then the number of columns and rows in the attached table will also be displayed.

Note: Only one Display Data window can be opened for each individual data attachment. Select Show Column Types to display the data type of each column. By default, old data is replaced by new data on each update. To insert new rows to display incoming data, select Insert New Rows. Select the Scroll Columns check box to set the width of all columns to fit the visible area.

Substitutions

The “Substitutions” feature allows you to build open-ended displays in which data attachments depend on values defined at the time the display is run. In this way, a single display can be reused to show data from a number of different sources. When data attachments are created in the Display Builder, generic values (i.e.: $sub1, $sub2, etc.) are used instead of the actual value of any field in the Attach To Data dialog. Later when the display is running, these generic values are defined. Substitution values can either be defined for all displays or for a single drill down display.

Row Filtering

In Attach to Data dialogs that feature a Filter check box, it is possible to indicate multiple columns for the filter and multiple values to compare against for each column. Multiple Filter Column names should be entered as a semicolon (;) delimited list. 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. For example:

Filter Column: col1;col2;col3

Filter Values: val1,val2;val3,val4;val5,val6

The resulting table would contain only those rows where the values of val1 OR val2 are in col1 AND the values of val3 OR val4 are in col2 AND the values of val5 OR val6 are in col3.

The following describes Attach to Data dialog commands: