Rows

Use the Rows tab to set the criteria of your query by choosing an operator and value which sorts and includes the selected field value once it is selected from a database.

To open the Rows tab, click a Query Name or the Need to create a new query? Click here to add link on the Data Miner screen.

The fields on the Rows tab are:

Field Description
Description The field text description.
Field The name of the field that is represented by the selection data.
File The data file from where the data is extracted.
Operator Indicates the operator value chosen for the query (e.g. equal to, greater than, less than, not equal to, contains, does not contain, range, and prompt at runtime are available).
Value The value that corresponds to the field selection.

The available Operator options are:

Operator Description
Equal to

Using the equal to option indicates that the Field value is 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 are selected.
Not Equal to

Using the not equal to option includes 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 not = 06 are selected.
Greater Than

Using the greater than option includes 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 are selected.
Less Than

Using the less than option includes 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 are selected.
Contains Using the contains option includes the Field value entered in the Value field (e.g. if in customer group file maintenance, Business Class contains A, indicates that customers whose business class contains the letter A are selected).
Does Not Contain

Using the does not contain option does not include the Field value entered in the Value 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 are selected.
Range

Using the range option includes the values entered in the From and To fields.

For example, if in customer group file maintenance, Customer Number (CUCUS) range from 00110 to 00120, then customers with customer numbers in the range of 00110 to 00120 are selected.
Prompt at Runtime Using this option prompts you for operator values before running the query. After clicking Run Report, the Select Criteria screen appears to select which operator values to apply to the query.

Click a Description to alter the selection criteria.

Click the Click here to add Selection criteria link to add a selection criteria.

Use these buttons to complete your work on the Rows tab:

Button Description
Run Report Runs the selected report. Error messages 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.
Share Opens the Upload Query to Data Miner Repository screen to upload the selected query to the Data Miner Repository. This button only appears if the Upload Queries to Data Miner Repository switch is activated in security system 505.
Clear Select Removes the selected criteria.
Close Closes the Rows tab and returns to the Data Miner screen.

Security: 505 - Data Miner

Revision: 2026.01