Creating In and Not In Lists

In addition to the standard query operators (conditions) that can be used to select quality results, you can define custom "in" and "not in" list operators. See: Finding Quality Results.

The "in" record selection condition allows you to create a user-defined list of values. Only quality results values that match the values in this list are selected. The "not in" record selection condition also allows you to create a user-defined list of values. However in this instance, only quality results values that do not match the values in this list are selected.

To define "in" and "not in" lists of values for conditional results selection

  1. From the query operators list, select the in or not in Condition. (Multiple) appears in the From field.

  2. Position the cursor in the From field.

  3. From the Edit Menu choose List of Values. The In List Value window appears.

  4. Enter the Values in List.

    The data type of the selected collection element restricts the data type of the values you can enter.