System Administration

Manage Duplicate Detection

Duplicate Detection is a validation rule included with the DSP® that uses search engine indexes to find possible duplicate records. Unlike most validation rules, which are hard coded views residing in the database, DSP® dynamically builds a derived table at runtime to perform Duplicate Detection. The derived table is treated much the same way as any user-defined validation rule. The results of the query display the same as any other validation results.

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)

NOTE: If both search and duplicate detection are used, the user can enable a validation as a page event that runs in the foreground to check for duplicates when a single record is added. Refer to Configure an Index, Add a Column to an Index and Register a Validation Rule to a Page for more information.

  • A user manually triggers an event that contains the validation rule

NOTE: The validation can be assigned to any event, with any severity or priority. Add a Duplicate Detection validation rule to the OnValidate event as a warning. Refer to Create Events for more information.

The Duplicate Detection validation rule is available for use on a page if the following criteria have been met:

  • The page must be indexed.
  • Duplicate detection must be enabled on one or more index columns.

Refer to Build indices for a Data Source for Search and Duplicate Detection and Enable Duplicate Detection for more information.

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. 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. The results are stored in a DSP®-created table where a client can use them.

This section contains these topics: