Copying with dynamic ranges
Dynamic ranges may be compared to filters for source elements. If you create a dynamic range, the source elements that correspond to the filter of a dynamic range, are copied into the element list. If source elements are added that match the filter criteria, these will automatically be added to the list, when the list is accessed. Thus, you make sure that the element list always contains all elements matching the properties that you have specified, even if the source database has changed.
To create a dynamic range, click on the Dynamic ranges tab. The Dynamic Range dialog opens. Specify the name and the description of the dynamic range.
To select the filter criteria, click in the dialog. The Filter dialog opens. By combining the fields Column, Operator, and Value you specify the filter criteria:
| Field | Description |
|---|---|
| Column | Select the column of the source table, by which the values are to be filtered, for example, ID. |
| Operator | Select a comparison operator for this value, for example, > (the SQL convention applies to operators). |
| Value | Specify the value that will be checked by the comparison operator of the Operator field using the value of the field Column, for example, 1,000 (the SQL convention applies to wildcards). |
Example
Select the ID column from the drop-down list Column. Select the operator > (greater than) from the drop-down list Operator. Specify the value 1,000 into the Value field. As a result, all source elements with an ID greater than 1,000 are transferred into the element list.
To combine various filter criteria, define additional criteria in the Filter dialog. With the option buttons and you determine, whether those source elements are added exclusively that match all criteria (AND; restrict list), or whether source elements only have to match one of the two criteria (OR; expand list).
To save the dynamic range and to add the filtered elements, close the dialogs Filter and Dynamic Range with and click on the Dynamic Range tab.
Id LIKE %.