Sorting Options: Select/Omit

When you create sorting options, you can choose whether a certain field value should be selected or omitted when the sorting order is displayed.

This document describes the rules, valid combinations, and invalid combinations for the ‘Select/Omit’ field on the (CRS021/F) panel.

Outcome

Combinations for the Select/Omit and Operator fields are described.

Sorting options are stored in the CSYSOR table.

Sorting Options: Select/Omit allows you to display records faster when you make selections than when no selections are made. Also, it allows easier search options for relevant information.

Description

Valid alternatives for Select/Omit

The valid alternatives for the Select/Omit field are:

Valid alternatives for operator

The alternatives are:

Rules when S (Select) is used

If you use only Select (S), then selected records and their selected values will be displayed. No other records and values will be displayed.

Note: Only operator EQ is used in these examples.

Rules when O (Omit) is used

If you use only Omit (O), then omitted records and their omitted values will not be displayed. All other records and values will be displayed.

It is strongly recommended not to use O = Omit.

Note: Only operator EQ is used in these examples.

Rules when Select and Omit are used

Basic rules

Note: Only operator EQ is used in these examples.
Related topics