Configuring the User Interface › How to Configure the User Interface › Search Configuration › Prevent Duplicate Object Records

Prevent Duplicate Object Records

CA APM lets you prevent duplicate object records from appearing in the search results. For example, you have several people in your enterprise with the name John Smith. Their first and last names are the same, but their additional contact information (email address, supervisor, department, and so forth) is different.

You have a saved contact search in which only the first and last name of the contact appears in the results. When you search using the saved contact search and specify John as the first name and Smith as the last name, two instances of John Smith appear in the search results. When you prevent duplicate records from appearing, only one instance of John Smith appears.

To prevent duplicate object records from appearing in the search results

1. Click the tab and optional subtab for the object that you want to find.
2. On the left, click Manage Searches.

   A list of saved searches displays.

3. Click the search for which you want to prevent duplicate records from appearing.
4. In the Additional Settings, Unique Search Characteristics area, select the Make Results Unique check box.
5. Click Go.

   The results appear without the duplicate records and help you see the impact on the results before you save your settings. The DISTINCT argument is added to the SQL statement, preventing duplicate records from appearing in the search results.