Contents

Creating Duplicate Detection Rules

Mohammed Jamal Updated by Mohammed Jamal

To enable the system to identify and flag duplicate records, you need to create the rules and conditions for this. Once flagged, you can merge duplicate records as required.

You can only create rules and conditions for Business Objects and Fields that are enabled for duplicate detection. OneAdvanced is responsible for this setting.

Duplicate Detection Rules determine the Business Objects, or record types, that are subject to duplicate detection.

To create a Duplicate Detection Rule:

  1. Navigate to Settings > Configuration > Data Management. The 'Data Management' page is displayed.
  2. Expand the Duplicate Detection section, and select Duplicate Detection Rules. The 'Duplicate Detection Rules' page is displayed.
  3. Select the Create new record button on the toolbar. The 'Duplicate Detection Rules: New' page is displayed:

  1. Complete the fields on the page, mandatory fields are marked with a red asterisk *.

The table below describes the fields on the page.

Field

Description

Field Logic Type

Name*

Name of the rule.

Text

Max. 300 characters

Record Type*

Type of record (Business Object) to which the rule is applied.

Reference values are filtered to only display Business Objects where Available for duplicate detection? = 'Yes'.

Selection

Description

Description of the rule.

Text

Max. 4000 characters

Exclude Inactive Matching Records

Indicates whether to exclude inactive matching records.

Yes/No radio button

Set to 'No' by default

Execute On Create

Indicates the rule will execute when a record is created.

Yes/No radio button

Set to 'Yes' by default

Execute On Update

Indicates the rule will execute when a record is updated.

Yes/No radio button

Published

Indicates whether the rule is published.

Published rules are applied by the system.

Yes/No radio button

Set to 'No' by default

Valid for Export

Indicates whether the rule will be included in the export file.

Yes/No radio button

Set to 'No' by default

  1. Select the Save button on the toolbar.

The Duplicate Detection Conditions pane is displayed below.

This is where you specify the fields that the system uses to detect duplicate records.

A rule cannot be published until at least one condition has been added.



Adding Duplicate Detection Conditions

Once a rule has been created that subjects a record type to duplicate detection, you need to specify the fields that the system uses to compare records and identify duplicates. In addition, you can configure the following finer details:

  • What constitutes a duplication (e.g. the same date and time for a date field, or just the same date)?
  • How many characters must match for a text field?
  • Whether blank fields are considered a duplication by the system.

To add a condition to a Duplicate Detection Rule, do the following:

  1. Open the relevant Duplicate Detection Rule record.
  2. Scroll down to the Duplicate Detection Condition pane.
  3. Select the Create new record button on the toolbar. The 'Duplicate Detection Condition' page is displayed:

  1. Complete the fields on the page, mandatory fields are marked with a red asterisk *

Field

Description

Field Logic

Rule*

Duplicate Detection Rule to which the condition applies.

  • Reference to Duplicate Detection Rule setup data object
  • Parent Duplicate Detection Rule is specified by default

Field*

Field that is used by the system Cloud to detect duplicate records.

Reference values are filtered to only display Fields where Available for duplicate detection? = 'Yes'.

  • Reference to Business Object Field system metadata object

Criterion*

Operator by which the system determines whether fields are duplicates or not.

The drop-down options are filtered according to the specified Field. For example, if the specified Field is a text field, you can configure the system to compare the first 10 characters or the last 10 characters.

For more information, see section 'Criterion Operators' below.

Drop-down selection

Ignore Blank Values

Indicates whether two blank field values are deemed a duplication by the system.

  • Yes: Two blank values are not a duplication
  • No: Two blank values are a duplication

No. of Characters

Number of characters used by the system when comparing two field values.

For example:

  • No. of Characters = 5
  • Criterion = Same First Characters

In this scenario, the system compares the first five characters of the field values.

No. of Characters is redundant if specified Field is not a text field or Criterion = Exact Match.

  • Visible and mandatory if Criterion = Same First Characters

  1. Select the Save and Close button on the toolbar.

You are returned to the Duplicate Detection Rule screen.

  1. As a condition has been added to the rule, you can publish the rule whenever you are ready by setting the Published option to Yes.
  2. Select the Save button on the toolbar.



Criterion Operators

The following table describes the operators available for each type of field:

Field Type

Available Operators

Date

  • Same Date
  • Same Date and Time

Text

  • Exact Match - the field values must match in their entirety
  • Same First Characters

Look Up

  • Equals

Pick List

  • Equals

Boolean

  • Equals

Was this article useful?

Viewing Duplicate Records

Contact