Find Duplicates Overview

Common provides a quick and easy method to identify and resolve duplicate data.

NOTE: There is a distinction between Duplicate Detection, configured in System Administration, and Bulk Duplicate Detection performed in Common. Bulk Duplicate Detection is an extension of the Duplicate Detection capability. The Duplicate Detection validation rule runs as a foreground event, triggered when:

  • A record is created or modified on a page where Duplicate Detection is enabled for a column(s)
  • A user manually triggers an event that contains the validation rule

Bulk Duplicate Detection is a background event that detects duplicates for each record in a table. An Administrator or Designer runs the Bulk Duplicate Detection process in Common.

This use case covers the following topics:

 

NOTE: To allow business users to see the results of the Duplicate Detection process:

  1. Add the business user to the Common WebApp, then add the user to the Analyze WebApp Group. Refer to Assign Users to WebApp Groups in System Administration for more information.
  2. Assign a user-specific security definition to each business user. Add the Analyze data source(s) that are used in the Duplicate Detection process as a key to each user’s security definition. Refer to Establish User-specific Security Definitions in System Administration for more information.