Selection Criteria

The Selection Criteria screen can be accessed from within the Data Miner system by creating a query, setting up the Prompted at Runtime operator on the Selection Criteria screen and selecting the Run Report button from on one of the Columns, Rows, or Sorttabs.

The Selection Criteria screen prompts you at runtime for valid operator values before running the created query.

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

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.
Description A description of the field.
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).
Value

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

Note:  

If you use the plus icon you are using an or operator.

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.

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

Button Function
Run Report

Prints the report, this option can be used at any time since no files are updated when running a report.

Note:  Error messages will prevent a user from running a query, if files and fields used within the query do not exist in the system and/or authorized users are not authorized to use files within the selected query.
Close Closes the Selection Criteria screen without running the query and returns to the previous screen.

Revision: 2025.07