Enable Additional Search Operators for Text and List Field Searches

You can enable additional operators (Is Blank, Is Not Blank, and Does Not Equal) for searches in text fields and fields validated by lists of values. For example, selecting the Is Blank operator, makes it possible for salespeople to search for records missing values.

These operators aren't available by default because their use can affect search performance. You can make these operators available on mandatory standard and custom fields, by setting one or both of the following two system profile options to Yes:

• Enable Additional Search Operators for Text Fields (ZCA_ENABLE_ADDITIONAL_TEXT_OPERATORS) enables the Is Blank and Is Not Blank operators in text field searches.

• Enable Additional Search Operators for List of Values (ZCA_ENABLE_ADDITIONAL_LOV_OPERATORS) enables the Is Blank, Is Not Blank, and Does Not Equal operators in fields validated by lists of values (both fixed choice and dynamic choice list fields).

Here's how to display the additional operators:

1. Navigate to the Setup and Maintenance work area, and use the following:

   • Offering: Sales

   • Functional Area: Sales Foundation

   • Task: Manage Administrator Profile Values

2. In the Search: Profile Option region, Profile Display Name field, enter Enable Additional Search Operators%.

3. Click Search.

   The application displays information for the two system profile options.

4. Select the name of the system profile option you want to enable.

5. In the Profile Values section, select Yes from the Profile Value list.

6. Click Save and Close.