Enterprise RTView® 
User Guide


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. Depending on your version of Enterprise RTView, there are several data sources available. For detailed information on the Attach to Data dialog for your data source, refer to the 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. 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 checkbox 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 checkbox, 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:
 
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.
 


 
Enterprise RTView contains components licensed under the Apache License Version 2.0.

 

Treemap Algorithms v1.0  is used without modifications and licensed by MPL Version 1.1. Copyright © 2001 University of Maryland, College Park, MD

 

Datejs is licensed under MIT. Copyright © Coolite Inc.

 

JCalendar 1.3.2 is licensed under LGPL. Copyright © Kai Toedter.

 

jQuery is licensed under MIT. Copyright © John Resig,

 
JMS, JMX and Java are trademarks or registered trademarks of Sun Microsystems, Inc. in the United States and other countries. They are mentioned in this document for identification purposes only. 

 
SL, SL-GMS, GMS, Enterprise RTView, SL Corporation, and the SL logo are trademarks or registered trademarks of Sherrill-Lubinski Corporation in the United States and other countries. Copyright © 1998-2009 Sherrill-Lubinski Corporation. All Rights Reserved.