Salesforce

Range Window (Magic xpa 3.x)

« Go Back

Information

 
Created ByKnowledge Migration User
Approval Process StatusPublished
Objective
Description

Range/Locate Window (Magic xpa 3.x)

You can access the Range/Locate window by selecting Range/Locate from the Task menu or pressing Ctrl+R.

This window lets you choose from three groups of ranges:

Range – You can define a single data view range by entering values in the From and To columns or select several ranges for a single field by specifying the same field in a new row. Every row is evaluated by an expression before the task opens.

SQL Where Clause – This window lets you specify a range for Magic xpa or DB SQL Where, view the Full Where Clause that is generated by Magic xpa, and write a range based on SQL syntax using Magic xpa variables.

Range Expressions – 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 From-To expressions specified in the task’s Range From-To window. The Range Expression lets you to define the Range further, by entering complex and dynamic conditions and is evaluated for every fetched record.

Note:

  1. A question mark (?) used in the main source's range or locate is used as a wildcard character. It represents any single character.

  2. The asterisk (*) character used in the main source's range or locate is used as a wildcard character. It represents a string of characters.

  3. 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

Reference
Attachment 
Attachment