About Selecting a Dataset
When you apply a dataset to an instance, you must first find it in the datatable. You can reduce the number of parameters visible and filter the parameters to limit the options available.
Displaying Parameters
Use the Define Visibility dialog box to define the parameters visible in the design. Visibility settings are stored with the design and apply to all datatables in the design. Different datatables have different parameters. Therefore, you must display important parameters even when they are not available in the current datatable. When a parameter is not available in the datatable, the cell in the Dataset Selector is empty.
Parameters that are not displayed are still in the dataset and are applied when you apply the dataset.
Filtering Parameters
To reduce the number of datasets displayed, you can filter the parameters in the datatable. To define a filter you can use any of the following options:
Click the arrow to the right of the box to choose from a list of the most common values.
Type a value in the box.
Use the widcard * at the start or end of a string.
Use relational operators such as <, <=, <>, =, ==, >=, and > to define a condition or filter.
Examples of legal filters:
Filter
Description
> 100
parameter value > 100
> 100, <=200
100 < parameter value <=200
>100 <=200
100 < parameter value <= 200
==St
first 2 characters of parameter value equal "St"
St*
first 2 characters of parameter value are "St"
*er
last 2 characters of parameter value are “er”
Examples of illegal filters:
Filter
Description
== 100
The == operator can be used only with string parameters.
100, <= 200, <> 150
A maximum of two conditions are permitted on a single parameter.