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.

Note: If you have started this session by zooming, you can only find and select a record.

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 an or 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