Selection Criteria

The Selection Criteria screen allows you to add a query to the Selection tab.

To open the Selection Criteria screen, click the Click here to add selection criteria link on the Selection Criteria tab.

The fields on the Selection Criteria screen are:

Field Description
Group

The field group code is used as a logic function between groups (Group A criteria or Group B criteria).

The Group field appears depending on what system the Selection Criteria tab is accessed from.
Field

Select the field represented by the selection data. Depending on the operator, the system will include or leave out records based on the field data. The value selected in the field data column is the comparison data used.

The field values used on a selection screen must correspond to the field values used in the master file that the selection screen selects from. Every selection screen has different fields, sort types, and the number of selection columns, but all screens operate in exactly the same manner.

Operator

An operator code which applies to the value entered. See the The available Operator options are: table.

Some selection fields do not allow all operators. If an invalid operator is used, an error message is displayed indicating that the operator selected is not valid for the field.

Value

A value that corresponds to the field selection. Use the More icon beside the value field to enter more than one value for this field.

From/To

When Range has been selected as the Operator, the From and To fields appear so that you may enter a starting boundary (From) and ending boundary (To) for the range.


The From value must be less than the To value of the range or else the search will fail. The order of the characters (lowest to highest) is special characters, lowercase alphabet characters, uppercase alphabet characters, number characters.

The available Operator options are:

Operator Description
Equal to

Selects customers with Field values that are equal to the value entered in the Value field.

For example, if in customer group file maintenance Salesperson (CUSMN) = 12 then customers with a salesperson ID = 12 will be selected.
Not Equal to

Selects customers with Field values not equal to the value entered in the Value field.

For example, if in customer group file maintenance Province/State (CUPRV) = 06 then customers with a province/state = 06 will NOT be selected.

Greater Than

Selects customers with Field values greater than the value entered in the Value field.

For example, if in customer group file maintenance Size (CUSIZ) = 100 then customers with a size > 100 will be selected.

Less Than

Selects customers with Field values less than the value entered in the Value field

For example, if in customer group file maintenance Size (CUSIZ) = 75 then customers with a size < 75 will be selected.

Contains

Selects customers with a Field value that contains the Value field in the Field.

For example, if in customer group file maintenance Business Class contains A then customers whose business class contains the letter A will be selected.

Does Not Contain

Selects customers with a Field value that does not contain the Value field in the Field.

For example, if in customer group file maintenance Business Class does not contain X then customers whose business class does not contain the letter X will be selected.
Range

Selects data with values within the range entered in the From and To fields.

For example, if in customer group file maintenance, Customer Number (CUCUS) range from 00110 to 00120, indicates that customers with customer numbers between the range of 00110 to 00120 will be selected.

The range must be specified from lowest to highest.

Dates must be entered in the format YYYYMMDD.

Use these buttons to complete your work on the Selection Criteria screen:

Button Function
Save Saves changes made on the Selection Criteria screen.
Save/Exit Saves your selection criteria and closes the screen.
Close Closes the Selection Criteria screen without saving and returns to the Selection Criteria tab.

Revision: 2025.07