Selection Criteria

The Selection Criteria screen displays all of the selection statements that you have saved and allows you to add new selection statements.

The fields on the Selection Criteria tab are:

Field Description
Description Describes the a 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.
File The file name where the column data is located.
Operator Indicates the selection operator code which applies to the value entered. See the The available Operator options are: table.
Value The value that corresponds to the field selection.
Group

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

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

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 Report

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

Note:  If you click the Run Report button without filling out any of the fields on the Selection screen, IntelliDealer runs all reports with all report criteria.
Load Saved Query Recalls a previously created query.
Save Query Saves the current query on the Selection tab.
Clear Select Clears the selected query from the tab.
Close Closes the Selection Criteria tab without saving and returns to the previous screen.

Revision: 2025.07