Skip to main content
Logo
There is a newer version of Contensis. Click to find out more and download the latest version.

Configure and manage full-text search indexing

This article explains how you can manage and configure full text search indexing. It covers a range of topics including creating a full text catalog, extending the search catalog with additional metadata, locating the full text catalog as well as rebuilding the catalog when things go wrong.

Locate the full text catalog

  1. Open SQL Server Management Studio
  2. Expand Databases
  3. Expand the Contensis CMS-Database [1]
  4. Expand Storage
  5. Expand Full Text Catalogs
  6. Right click the SearchContent [2] catalog and select Properties from the context menu, the Full-Text Catalog Properties box will open.

The Last Population Date in the properties pane shows when the catalog was last populated. Any changes made in the CMS since this timestamp will not be reflected in the catalog and therefore will not be returned in the search results.

[1] The database name may differ from these instructions depending on the configuration by your organisation.

[2] SearchContent is the default catalog name, but may have been configured differently.

Configure a full text catalog

The full text catalog is generated by pressing the Create Search Table button when creating a publishing server in the CMS, by default the catalog is set up to index page titles and page content.

Adding additional metadata to the search index

If you have created custom metadata (such as description and keywords) in the CMS that you would like to search against, its simply a matter of adding those columns to the search catalog.

  1. Locate the full text catalog. Click Tables/Views in the left hand pane
  2. With the dbo.SearchContent table assigned to the catalog, check the Eligible Columns you would like to be indexed, in this case MD_Description and MD_Keywords

Automatically track changes between the search table and full text catalog

To keep the changes between the dbo.SearchContent table and the full-text catalog in synchronisation we rely on the SQL Server 2008 track changes feature, which should be set to automatic by default. If you need to configure this setting manually for any reason.

  1. Locate the full text catalog. Click Tables/Views in the left hand pane
  2. With the dbo.SearchContent table assigned to the catalog, check the Automatic radio button is selected in the Track changes section of the dialog
  3. Click OK.

Maintenance

Rebuild the full text catalog

If you suspect the search is not working because the catalog is out of date then you can force the catalog to rebuild immediately and then repeat the search to check that the rebuild has fixed the issue.

  1. Right click on the SearchContent catalog and select Rebuild from the context menu. A confirmation dialog will open asking ‘Do you want to delete the full text catalog and rebuild it?'. Click OK.
  2. A status window will appear with the progress of the rebuild, once it has completed click Close.