Data View Tuning (Magic xpa 3.x)
The Range expression in the Range Window provides a more flexible way to define the record set in the task data view. When the Range expression is not a lower/upper value pair, it may contain non-contiguous ranges and set other complex conditions based on any of the logical record’s variables. The Task Range Order field allows you to set the actual sequence, ascending or descending, in which records will be displayed and processed. If both the Task Range property and Select Range lower/upper expressions are specified, the engine will use them all in an “AND” relation to determine the set of records for the data view. Other range fields are described below.
Field models have a Range field in the Field Model Properties sheet.
The Column list lets you enter a range value for a column entry for a data source.
The SQL Where Clause determines a range based on SQL syntax using Magic xpa variables.
How Magic xpa Prepares the Data View
Record Data View Instance
Data View Editor
