Range From - To (Magic xpa 4.x)
Set a Range expression.
Range expressions are one way to customize the task's data view. They can define a subset of records from the physical files selected for the data view.
You can specify two expression numbers in the Range property. The first expression represents the lower value and the second the upper value of the variable, which will be used to delimit the range of the records you want included in the task’s data view.
The expressions must evaluate to a value matching the variable's Attribute. If you need a logical condition to delimit the range, you can specify the condition in the Range Expression property in the Range Window, or in the DB SQL Where clause when working with SQL databases.
Be sure that all variables participating in expressions contain valid values when the task is activated. The variables can be variables selected in a parent task, arguments passed to the task, or any constant value.
At runtime in an Online task, the end user is not allowed to browse records outside the delimited Range, but can additionally restrict the range by selecting the default runtime menu option Range of Records from the Options menu (Ctrl+R).
Note:
-
Ranges should not include spaces. For example, 1 - 10 is not a valid range, but 1-10 is.
-
If you are using negative numbers in the range, use the backslash (\) before the number. For example: \-7-\2 is a range of -7 to -2.
-
The asterisk (*) or question mark (?) characters used in the main source's range or locate is used as a wildcard character. It represents a string of characters. The asterisk and question mark can only be used as the last character in a string.
-
To use the asterisk or question mark as a value in the range or locate, precede the asterisk or question mark with a backslash (\). Since version: 1.9h
Examples of range and locate syntax:
-
a* will do the range or locate on a* (where * is a wildcard character)
-
a\* will do the range or locate on a* (where * is a string)
-
a\\ will be a\
-
a\\* will do the range or locate on a\* (where * is a wildcard character)
-
a\b will remain a\b