web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Duplicate Detection Cr...
Microsoft Dynamics CRM (Archived)

Duplicate Detection Criteria For CRM Contacts

(0) ShareShare
ReportReport
Posted on by Suganthar_Satkunam 210

Hi All

I currently have an requirement to add the below condition in Dynamics CRM as a duplicate detection rule. How can i achieve this without using the java script or custom code.

(Last name and Date Of Birth) OR (Email and Mobile Phone) OR (Email and Home Phone)

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    gdas Profile Picture
    gdas 50,091 Moderator on at

    Hi Satkunam,

    Dynamics CRM does not support AND/OR condition in the duplicate detection rules. Try to create three different rules with those condition.

  • Suggested answer
    Mahendar Pal Profile Picture
    Mahendar Pal 45,095 on at

    All the condition use And in Duplicate detction, from SDK-

    "A rule can have one or more duplicate detection rule conditions that are represented by the duplicate rule condition (DuplicateRuleCondition) entity. The conditions are combined by the system as in logical AND operation. A duplicate detection rule specifies a base entity type and a matching entity type. A duplicate rule condition specifies the name of a base attribute and the name of a matching attribute. For example, specify an account as a base entity and a contact as a matching entity to compare last names and addresses. The matching criteria consist of operators such as exactly match, first n-number of characters, or last n-number of characters."

    reference: msdn.microsoft.com/.../gg309427.aspx

    So if you want to implement your requirement you need to look for to implement plugin logic.

  • Suganthar_Satkunam Profile Picture
    Suganthar_Satkunam 210 on at

    Thanks for this. In case, if i require to use the java script, how can i invoke the duplicate dectection dialog with all the possible duplicate records? Is it possible to invoke by java script

  • Verified answer
    gdas Profile Picture
    gdas 50,091 Moderator on at

    Hi Satkunam,

    yes its possible , you need to make ODATA Web API/FetchXML  request to get the data with condition , if records matches then prevent save using execObj.getEventArgs().isDefaultPrevented() and set form notification.

    Please refer below -

    msdn.microsoft.com/.../gg509060.aspx

    Make sure  doing validation in Javascript will not fire when record will create from other sources .

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
ScottDurow Profile Picture

ScottDurow 2

#2
GJones Profile Picture

GJones 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans