Rows

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

The Rows tab allows you 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 data base.

The following fields appear on the Rows tab:

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 will be 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 following is a list of available Operator options:

Operator	Description
Equal to	Using the equal to option indicates that the Field value is equal to the value entered in the Value field [e.g. if in customer group file maintenance, Salesperson (CUSMN) = 12, indicates that customers with a salesperson ID = 12 will be selected].
Not Equal to	Using the not equal to option will include Field values not equal to the value entered in the Value field [e.g. if in customer group file maintenance, Province/State (CUPRV) = 06 indicates that customers with a province/state not = 06 will be selected].
Greater Than	Using the greater than option will include Field values greater than the value entered in the Value field [e.g. if in customer group file maintenance, Size (CUSIZ) = 100, indicates that customers with a size > 100 will be selected].
Less Than	Using the less than option will include Field values less than the value entered in the Value field [e.g. if in customer group file maintenance, Size (CUSIZ) = 75, indicates that customers with a size < 75 will be selected].
Contains	Using the contains option will include 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 will be selected).
Does Not Contain	Using the does not contain option will not include the Field value entered in the Value field (e.g. if in customer group file maintenance, Business Class does not contain X, indicates that customers whose business class does not contain the letter X will be selected).
Range	Using the range option will include the values entered in the From and To fields [e.g. 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.
Prompt at Runtime	Using this option will prompt you for operator values, before running the query. After selecting the Run Report button the Select Criteria screen will appear allowing you to select which operator values you wish to apply to the query.

Click a Description to alter the selection criteria.

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

The following buttons allow you to complete your work on the Rows tab:

Button	Function
Run Report	Runs the selected 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.
Share	Opens the Upload Query to Data Miner Repository screen, allowing you to upload the selected query to the Data Miner Repository. Note:  This button will only appear 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.