Grass Valley Xstudio Vertigo Suite v.4.10 - Manual (Page 235)

9-12 Xstudio User Manual
Linking objects to a data source
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.
7. 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 .
8. Enter the time interval in seconds that will separate data refreshes in the R EFRESH R ATE field.
Or,
Select the N
EVER R EFRESH check box. This deactivates the R EFRESH R ATE field.
9. The G ARBAGE C OLLECT field the time interval at which the system will purge outdated
instances of data variables.
10. Enter the maximum number of rows to be returned by the query in the M AX R OWS field.
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.
11. 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 Xstudio log file. Note that the Stale Interval value
must either be left blank (default) or be a value greater than the Refresh Rate value.
12. Click OK.
This closes the S NAPSHOT S ETTINGS dialog box and brings you back to the D ATA
M ANAGER . The new snapshot is listed at left under its schema.
Figure 9-8. New snapshot listed under the schema in the Data Manager