Show/Hide All
This field displays the name of the data field used for selection. This field can only be viewed.
This field displays the data type of the data field. This field can only be viewed.
Select the logical operator (And or Or) to use in conjunction with the prior selection field. This field is not available for the first selection field selected for editing.
Select the type of relation to use to evaluate the value in the data field for record selection.
Select Equal (=) to require that the selection field have a value equal to the value entered.
Select Not Equal (<>) to require that the selection field have a value not equal to the value entered.
Select Less Than (<) to require that the selection field have a value less than the value entered.
Select Greater Than (>) to require that the selection field have a value greater than the value entered.
Select Less Than or Equal (<=) to require that the selection field have a value less than or equal to the value entered.
Select Greater Than or Equal (>=) to require that the selection field have a value greater than or equal to the value entered.
Select Range to require that the selection field have a value within the starting and ending values entered.
Select List to require that the selection field be equal to one of the values entered in a list. This option is available only for non-numeric data items such as string, phone, or zero filled. Additionally, the List relation is only available for data items with a length of six characters or less, and is not available for Yes/No fields.
Select this check box to evaluate only a portion of a non-numeric item. You must enter the starting character position and the length to be evaluated.
Select this check box to allow the entry of the selection value at the time of importing.
Select this check box if case is be significant when using the equal (=) relation to compare a data item. Clear this check box to ignore case when comparing values. This field is available only for Equal (=) relations.
When this check box is cleared and the selection value is CA, data items with CA, ca, Ca, and cA will all be selected. When the check box is selected, only CA will be selected.
If the Sub String check box is selected, you can enter the starting position and the length of the portion of a non-numeric data item to evaluate.
Type the prompt to display to enter the selection value at run time. This field appears only if the User Input check box is selected. Click the Change Case button to change the text entered at the Prompt field from uppercase to lowercase, and vice versa.
Type the starting value of a range of values to compare against the data item. This field appears only if Range is selected in the Relation field.
Type the ending value of a range of values to compare against the data item. This field appears only if Range is selected in the Relation field.
Enter the list of values to match the records to import. A record will be selected for importing if the data item in the record contains a value matching one of the listed values. The data item must be a string-type item with a maximum of six characters. This field appears only if List is selected in the Relation field.
Type the value to compare against the data item This field appears only if an option other than Range, List, or Mask is selected in the Relation field.
Select this check box to select a data item that contains the selection value anywhere in the field. Clear this check box to check the character in the selection value against the entire data field. This field is available only if Equal (=) is selected in the Relation field.
An example of using the Character Match feature is if you were trying to find a customer with the last name Henry. Your selection value would be Henry, the Character Match check box would be selected, and any name field containing Henry would be selected.
