Skip to main content

Notifications

Microsoft Dynamics CRM (Archived)

How to create Duplicate detection jobs to get report of duplicate records

Posted on by 645

Hi,

How to frame the query for Duplicate detection job, to get report of duplicate records based on First name and Family name exact match criteria.

I tried below but i am not getting result even though we have duplicate records matching below criteria.

7245.Capture.JPG

*This post is locked for comments

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How to create Duplicate detection jobs to get report of duplicate records

    Hi Krish,

    Account name = Exact Match is wrong because its search with account name  with exact match text, you have pass the  account name manually 

    1145.Capture1.PNG

    Best regards,

    Purushotham Boomireddy,

    for any doubt contact to b.purushotham1020@outlook.com

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How to create Duplicate detection jobs to get report of duplicate records

    Hi Krish,

    After creating duplication detection rules and you should publish the rules. Based on the rules duplicate detection job is created i.e if create same data automatically duplicate detection job creates.

    Best Regards

    Purushotham Boomireddy.

  • Integration Profile Picture
    Integration 645 on at
    RE: How to create Duplicate detection jobs to get report of duplicate records

    Hi,

    I enabled duplicate detection rules based on our business criteria. But below job I wanted to find the records which not fall under the criteria defined by us under duplicate rules.

    48330.Capture.JPG

  • Suggested answer
    chauhanhardik Profile Picture
    chauhanhardik 685 on at
    RE: How to create Duplicate detection jobs to get report of duplicate records

    Hi Krish,

    Please refer below links, it will help you to solve your query.

    https://www.microsoft.com/en-us/dynamics/crm-customer-center/set-up-duplicate-detection-rules-to-keep-your-data-clean.aspx 

    http://www.marksgroup.net/blog/dynamics-365-duplicate-detection-rules/ 

    Thanks,

    Hardik Chauhan

  • Suggested answer
    RaviKashyap Profile Picture
    RaviKashyap 55,410 on at
    RE: How to create Duplicate detection jobs to get report of duplicate records

    Hi Krish,

    Could you please share the full screenshot?

    Duplicate Detection Job works based on the Duplicate Detection Rules published. The criteria you select on the Duplicate Detection Job os to filter out the records on which you run the duplicate detection.

    Hope this helps.

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

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,240 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans