Selection Criteria

The Selection Criteria tab lists selection statements that you have saved and allows you to add new selection statements which allows you to a part group file change.

The fields on the Selection Criteria tab are:

Field Description
Field The field represented by the selection data. Depending on the operator code, the system will include or leave out records based on the field data.
File The file name where the column data is located.
Operator Indicates the selection operator code (e.g. equal to, greater than, less than or not equal to) which applies to the value entered.
Value The value that corresponds to the field selection.

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.

Select the Click here to add selection criteria link to add a new selection criteria.

Click on the Name of the query to edit an existing query.

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

Button Function
Run Update Runs the parts group file update following the parameters within the created query.
Load Saved Query Recalls a previously created query.
Save Query Saves the current query on the Selection Criteria tab.
Clear Select Clears/removes the selected query from the tab.
Close Closes the Selection Criteria tab and returns to the previous screen.

Revision: 2025.07