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 CRM (Archived)

Using SQL Thesaurus for Duplicate Detection

(0) ShareShare
ReportReport
Posted on by 3,079

We've done some playing around with putting commonly substituted words/names in SQL's thesaurus functionality, to enhance searching.  For example, we've put in the pair Bob and Robert, so when someone searches for Bob Smith, they'll also get Robert Smith.  That's working fine, and is dead easy.  So far so good.  :-)

However, we'd like to see these same matches used in Duplicate Detection.  Is there any way to do this?  By default, the dup rules just allow you to specify exact match, starts with, or ends with - and the exact match unfortunately doesn't take those thesaurus entries into account.

Thank you!

*This post is locked for comments

I have the same question (0)
  • ashlega Profile Picture
    34,477 on at

    I'm guessing it wont work for duplicate detection - full-text search can be configured for quick find:

    technet.microsoft.com/.../dn919650.aspx

    And, then, in order to use the thesaurus, those queries have to start using "contains" etc(which probably happens once you enable full-text search for the quick find):

    www.codenutz.com/using-sql-server-full-text-index-search-with-a-thesaurus

    But nowhere can you enable full-text for anything else (duplicate detection, workflows, advanced find..) - those "tools" are probably using regular queries all the time

  • awalters Profile Picture
    3,079 on at

    What about writing that "contains" into a plugin?  I can do that easily enough, but I don't know what messages to hook into that are part of the duplicate detection rule processing.  And I'd rather not re-write the entire duplicate detection functionality - just want to enhance what's there.

  • ashlega Profile Picture
    34,477 on at

    Actually, I just found this:

    "Advanced Find search is not affected when you enable full-text indexing for Quick Find. Advanced Find will continue to use the same standard indexing that was available in previous releases of Microsoft Dynamics 365."

    https://technet.microsoft.com/en-us/library/dn919650.aspx

    It's probably the same for all other places where you can build filters (duplicate rules, for example)

    Can only build a theory as to "why", but, to me, it's the internal workings of Dynamics/SQL.. it probably has something to do with the fact that quick find search is a "like"-type search, so it can be performed on the index that has all the quick find columns added to it (there can be only one full-text index per table in SQL). Duplicate detection etc are using more granular search, so they are not relying on the full-text. Probably:))

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 CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans