Range Expression (Magic xpa 3.x)
You can use the Range expression to fine-tune a task’s data view. The rows are initially included in a data view based on the Range From-To expressions specified in the Range window of the task. The Range Expression lets you to define the Range further, by entering complex and dynamic conditions. The Range expression is evaluated for every fetched record.
For example:
-
If the Range expression evaluates to True, the row is included in the data view.
-
If the Range expression evaluates to False, the row is skipped.
-
If a Range expression is not specified (i.e. its number is zero), it evaluates to True.
A Range expression is required when:
-
The criteria depend on values contained in variables not available at task initialization time.
-
The range criteria are not definable by the lower limit and higher limit expressions of the columns.
-
The range expression is not sent to the database. Magic xpa filters the records that were brought from the database.
You can define the following Range Expression properties:
Range Order
Locate Expression
Locate Order
Position - Range/Locate
Usage
SQL Where Clause
