Grass Valley Xpanel Vertigo Suite v.4.8 - Manual (Page 112)

6-10 Xpanel User Manual
Adding a data source to an object
5. In the D ATA SOURCE drop-down list, select one of the data sources that is already
defined in the schema.
The Data Setting fields that are displayed depend on the type of data source selected.
If the Data source is an Excel Spreadsheet:
• Verify the E
XCEL FILE path (read-only) and specify the sheet name in the
S HEET NAME field.
If the Data source is a text file:
• Verify the T
EXT FILE path (read-only).
If the Data source is an RSS:
• Verify the URL path (read-only).
If the Data source is a database:
a.
Select one or more tables from the S ELECT TABLE ( S ) section (hold down the SHIFT
or CTRL key for multiple selections).
b. Select the columns to be returned from the query in the S ELECT R ETURN
C OLUMN ( S ). To change the titles of selected columns, click the E DIT C OLUMN
N AMES button. When the C OLUMN H EADERS dialog box displays, click in a column
name to make the text editable.
c. To have only specific records returned, use the S ET K EY area. To use stock
information as an example, you could display only stocks that have gone up or
down by $1.00 or more.
d. Each line in the Set Key area represents a filter on the available data and is expressed
as a condition on the value of a column. Select a column name and operator from the
drop-down list in their respective columns. The value can either be entered as a
constant or can be set to the value of another column by choosing a column name
from the drop down list in the V
ALUE column. Alternatively, it is possible to set a
DYNAMIC VALUE by choosing from the drop-down list.
e. To sort returned records, use the S ET S ORTING O RDER table. Click in the N AME column
to display a drop-down list that contains all column names of the selected tables in the
data source. Once the column has been selected, click in the O
RDER row to display
the drop-down list that contains your two choices: A SCENDING and D ESCENDING .
6. In the R EFRESH R ATE field, enter the time interval in seconds that will separate data refreshes,
or select the N EVER R EFRESH check box to deactivate the R EFRESH R ATE field.
7. In the G ARBAGE C OLLECT field, enter the time interval at which the system will purge
outdated instances of data variables.
8. In the M AX R OWS field, enter the maximum number of rows to be returned by the query.
This will ensure that the system’s performance will not be hampered by the retrieval of
unnecessarily large tables. If you would prefer that there be no limit on the number of
rows returned by the query, enter 0.
9. The value of the S TALE I NTERVAL field represents the frequency at which the system
checks to see if the data has been updated. If the data has not been updated with the
specified time, a warning is sent to the Xpanel log file. Note that the Stale Interval value
must either be left blank (default) or be a value greater than the Refresh Rate value.