Selection Criteria

The Selection Criteria screen allows you to select the selection criteria for a report.

The following is a description of the fields that appear on the Selection Criteria screen:

Field Description
Group The field group code is used as an or logic function between groups (e.g. group A criteria or Group B criteria).
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.
Operator

Choose the operator to apply to the value entered in the Value field (e.g. equal to, greater than, less than, not equal to, contains, does not contain, range, and prompt at runtime are available).

Note:  The prompt at runtime operator option is only available through Data Miner.
Value

Enter up to 10 values or spaces in order to complete the query statement.

Note:  If you use the plus icon you are using an or operator.
Or Spaces

Select this option if you want the report to include blank values for the selected field. For example, if you want to produce a report listing any work order segments currently assigned to a blank technician, you would generate a report using the WOR file and select the following values:

Field: WRTECH, Operator: Equal To, Value: (No Entry), or Spaces: (Selected)

Note:  You cannot simply leave the Value field blank in order to include blank values on the report as the system will interpret a blank Value field as "*All", thereby including all possible options for the selected field.

The following is a list of available Operator options:

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.

Prompt at Runtime

Use this option to prompt the user for an operator and comparison value at run time. This allows dynamic selection criteria to be specified as opposed to static, hard coded values.

Note:  The prompt at runtime operator option is only available through Data Miner.

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 changes made on the Selection Criteria screen and exits the screen.
Close Closes the Selection Criteria screen without saving and returns to the previous screen.

Revision: 2025.07