Dynamics CRM, Search

Full-Text Search in MS Dynamics 365

Microsoft Dynamics 365 offers you the option, to enable fulltext search. This search will use your Quick Find settings and the fulltext-search of the sql-server. To enable this, naviate to Administration > System Settings and select “Enable full-text search for Quick Find”. If the full-text catalog is build, your search will speedup for all your searches.

Enabling full-text search
System settings to enable full-text search

Enabling the search takes up to 24 hours, because the sql-server has to build the fulltext-catalog. If you want to speed it up, you can rebuild the catalog manually.

Therefore

  1. Open you SQL Management Studio
  2. Select your database
  3. Navigate to the section “Storage”
  4. Navigate to “Full Text Catalogs”

Path to the full-text search

There should be one called “CRMFullTextCatalog”. Open this with an double-click. In the opened view, you have three pages on the left.

The first page shows a summary of your catalog and also the actions to optimize or rebuild the catalog. Selecting rebuild and pressing ok will rebuild your catalog. This will take some time.

Details of the catalog
The first view shows the summary and some actions

In the second view “Tables/Views” you can check, on which table your catalog is build.

Details tableview of catalog