Unique Key Dialog
The Unique Key dialog appears when you select in the value cell of the Unique Key property of of a refresh object in a library component in the Report Inspector, or select the Incremental Fetch button in the Display screen of the chart wizard. It helps you to specify a unique key to ensure there are no duplicated records in the library component or real time chart. See the dialog.
The following are details about options in the dialog:
Lists all the available data resources in the dataset used by the library component or real time chart.
Adds the selected fields to the Unique Key box.
Removes the selected fields from the Unique Key box.
Lists the fields you have added as the unique key, which is used to guarantee there are no two records with the same unique key value in the library component or real time chart.
Take a real time chart for example. When a real time chart is specified with a unique key, each time when the chart automatically updates itself, the data that has the same unique key values as the previously loaded data records will be filtered and only data with different unique key values will be added to the chart. For instance, if you add the fields Country and Product ID as the unique key of a real time chart, when a record with the product ID 1 in USA has already been loaded into the chart, no more records of this product ID in USA will be added to the real time chart because they have the same unique key value. The most common usage is with a time field so when a time is part of the unique key the data in the chart will be updated each time new records are added to the database with more recent times.
Applies the changes and closes the dialog.
Does not retain any changes and closes the dialog.
Displays the help document about this feature.