How do I make a field searchable in the UI?
You can enable additional fields for search, including custom ones. You can also remove existing fields from use.
By default, the work areas powered by Adaptive Search include all of the key fields you need for search. (See the topic Adaptive Search Configuration Provided by Oracle for a list.)
To make the field searchable in work areas powered by Adaptive Search and Global Search, including Sales in the Redwood User Experience, involves these steps:
-
You must make the field searchable for its business object.
-
Optionally, you can enable the field for search of a related object.
-
You must publish your configuration.
This example shows you how to enable the Chief Executive Name field, a standard application text field, but the same procedure applies to any field, even a custom field on a standard application object. When you're done with this configuration and publish it, a salesperson can enter the CEO name, in either Global Search or in the search box for those work areas powered by Adaptive Search, to find the account where the person is the CEO. The search also returns all of the opportunities for that account when you enable opportunities to be searched by account fields.
Suppose that you added the CEO name field to the Account UI and want to make entries in this field searchable. Here's a screenshot of the Edit Account page highlighting the location of the field.
Make the Field Searchable in Its Business Object
Here's how you make the field available for searching its business object. For example, making the account searchable by the CEO name.
-
Navigate to the Setup and Maintenance work area, and use the following:
-
Offering: Sales
-
Functional Area: Sales Foundation
-
Show: All Tasks
-
Task: Configure Adaptive Search
-
-
On the Configure Adaptive Search page, Setup tab (callout 1 in the screenshot), click Advanced (callout 2).
-
In the left pane, click the name link for the object where the custom field appears (callout 3). The CEO name field is an account field, so you click Account.
The field is listed in the Configure Fields section.
-
Select the Enable option to index the field for Workspace and Global Search (callout 4).
-
For a text field, including Chief Executive Officer, select the Analyzed Text Search option to index individual words in the field. Your selection also enables fuzzy search (search that retrieves results with similar spellings). And you enable other search operators, including All of the words and Any of the words.
Note: For fuzzy search to work, the first 3 characters of the word should match and in the remaining part of the word there can be 1 character difference. This can be changed to 2 characters difference if needed, but the first 3 characters still need to match. -
Select the Include in Keyword Search option to enable the field for both Global Search and search using the Workspace search box.
Restriction: Because they're Personal Identifiable Information (PII), you can't make contact email addresses and phone numbers available for search using global search or the Workspace search box.If you leave this check box deselected, users can't search for accounts using the CEO name. But in Workspace, they can still add the Chief Executive Name field as a filter for accounts and search the field there. Global Search doesn't permit you to add filters, only to search by keyword.
-
Select the Include in Object Reference option to enable the field for search in related objects. You can enable up to 15 fields. Make the selection if you want to use the CEO name when searching for opportunities, for example.
If you didn't select the Include in Keyword Search option, but select Include in Object Reference, then users searching opportunities can use the field only as a filter in Workspace.
Make the Field Available for Searching a Related Object
You can only make the field available for search in a related business object if you selected the Include in Object Reference option for the field.
-
In the left pane of the window, open the object where you want to enable the search. For this example, Opportunity (callout 1 in the screenshot).
-
Select the field in the left pane, in this example, Account (Callout 2).
-
In the right pane, select Enable (callout 3).
-
If you want to use the field for searches in Global Search and in the Workspace Search box, you must select the Include in Keyword Search option (callout 4).
If you don't select this option, but selected Enable, then the field remains available as a filter in Workspace, but can't be searched in Global Search.
The Include in Object Reference option isn't relevant here. Here's a summary of the two use cases:
Use Case
Enable
Include in Keyword Search
Users can search on the field using Global Search and in the Workspace Search box. For example, entering the CEO name, they get results containing, not only the account where the person is a CEO, but the opportunities for that account as well. In Workspace, they can also select the fields as a filter when searching for the object. For example, when searching for opportunities in Workspace, they can filter by CEO name.
Selected
Selected
Users can add the field as a filter in Workspace, but can't search on it using the Search box or using Global Search.
Selected
Deselected
Publish Your Configuration
After making your option selections, click Publish.
Publishing triggers an indexing process that you can monitor on the Monitor tab, Publish subtab. Your new configuration becomes available after the indexing process completes. If the process completes with errors for some reason, contact your help desk.
Enable the Field for Use As a Filter in the UI
For the field to be used as a filter and added as a column in search results, you must enable it for display on the UI:
-
In the Configure Adaptive Search page, click Configure UI.
-
To enable the field for use as a filter on its object (for example, to enable the account field to be used as a filter when searching accounts), do the following:
-
Select the object in the left pane of the Configure UI tab.
-
Select the Display in UI option for the field.
-
-
To enable the field for use in the UI of other related objects (for example, to enable the account field as a filter in opportunity searches), do the following:
-
Display the related object hierarchy for the object where you want to enable the filter in the left pane of the Configure UI tab. For example, select Opportunity (callout 1 in the following screenshot).
-
Locate and select the field's object in the object hierarchy. For example, select Account (callout 2).
-
Select Display in UI option for the field (callout 3).
-
-
Click Save and Close.