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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics 365 | Integration, Dataverse...
Suggested Answer

How to query records with the same name D365?

(0) ShareShare
ReportReport
Posted on by 1,088

Hi, how to build a query to get duplicate records by name (custom entity), but using fetchxml or odata.

is it possible?

I have the same question (0)
  • Suggested answer
    Community Member Profile Picture
    on at

    Hi PabloCRP,

    D365 has the OOTB function of deleting duplicates, you can also see all the duplicates through it.

    Go to Settings>>Data Management>>Duplicate Detection jobs>>New>>Enter the fields & criteria and run the job. You will get the list within CRM.

    As long as you set the duplicate detection rules accurately, you can correctly filter out the duplicates you want and then delete them.

    1. Enabled Duplicate Detection - https://www.marksgroup.net/blog/dynamics-365-spring-cleaning/
    2. Set up the duplicate detection rules for the lead entity - https://www.marksgroup.net/blog/dynamics-365-duplicate-detection-rules/
    3. Perform the duplicate detection job - https://www.marksgroup.net/blog/dynamics-365-duplicate-detection-jobs-merging-records/

    Or you can use Deduplicator of XrmToolBox to detect and export to Excel.

    Deduplicator  Â· XrmToolBox

    XrmToolBox  download: https://www.xrmtoolbox.com/

  • Community Member Profile Picture
    on at

    Hi Partner,

    Can you click Yes under "Did this answer your question?" to close this thread if my answer is helpful.

     Image

    Thanks in advance. 

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Microsoft Dynamics 365 | Integration, Dataverse, and general topics

#1
Martin Dráb Profile Picture

Martin Dráb 49 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 38 Super User 2025 Season 2

#3
#ManoVerse Profile Picture

#ManoVerse 31

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans