Ranges (daxch0112m000)
Use this session to limit the export procedure to a range of records. You can, for example, define ranges to export only Items belonging to a particular item group, or employees belonging to a specific department.
This session allows you to use relational and logical operators to create range-limitation logic expressions that control the export process. Only active records that match the condition are exported. This enables you to transfer a smaller file between systems.
The range is made active in the Table Relations (Export) (daxch0531m000) or Table Relations (Export) (daxch0131s000) session.
Restrictions per data type of the LN table field
Data type date
- The entered date field must be of the Default Date Format
- The plus or minus signs can be used to change the current date. For example, +2 adds two days to the current date.
- The character # can be used for the current date.
Data type string/multibyte
- The domain of the LN table field determines if a field is justified to the left, right or center or converted to upper or lower case.
Data type numeric
- Only numeric values can be entered
For the operators In or Not In, the value must be entered as follows:
- The set of values must be placed between parentheses.
- For data type string, each item in the set of values must be placed between double quotes.
Example
For a numeric field (1,2,5,7). For a string or multibyte string, then double quotes should be added ("a","b").
Field Information
- Exchange Scheme
-
Specifies the exchange scheme code.
- Batch
-
Specifies the batch code.
- Table
-
Specifies the code LN table that contains the data that will be exported into an ASCII file during an export procedure.
- Serial No.
-
The serial number that makes the range unique in the table relation. The serial number is only used as an identifier and it forces the correct sorting sequence.
Note: Use an interval, for example 10, 20, 30, so that you can add ranges later. - Table Field
-
The code of the LN table field on which the range-limitation logic expression is based.
- Operator
-
Specifies the relational operator that is used for creating an expression, for example, Equal, Not Equal, Greater, or Between.
Allowed values
- Between
-
Specify the two limits for the value to be checked. In fact this operator has the same effect as: field greater than or equal <value 1>, and field less than or equal <value 2>.
- Not Between
-
Specify the two limits for the value to be checked.
- Like
-
The value entered on the next field must match the syntax for regular expressions. For details, refer to the description of the
expr.compile
function in the Infor ES Programmers Guide (Infor Support Portal KB 22924522). - Not Like
-
The value entered on the next field must match the syntax for regular expressions. For details, refer to the description of the
expr.compile
function in the Infor ES Programmers Guide (Infor Support Portal KB 22924522). - In
-
The value entered on the next field indicates the values on which is checked. A set of values is defined. The elements are separated by a comma.
- Not In
-
The value entered on the next field indicates the values on which is checked. A set of values is defined. The elements are separated by a comma.
- Range Value (From)
-
Enter the value the operator applies to.
If the operator type is Between or Not Between, the specified value is the start value of a range.
- Range Value To
-
Specify the end value of the range.
Note: This field can only be specified if the operator is Between or Not Between. - And/or/end
-
The operator that is used to combine several relational expressions into one range condition.
If the range rules require more than one line to be expressed properly, then specify an
and
or anor
to join the multiple lines.The last line in an expression must end with
end of expression
.When a range expression exceeds one line, the sequence number is the only determination of which line is to be read next.
Allowed values
- and
- or
- end of expression
-
Indicates the end of the LN table field range that are exported