Full-Text Search in the CML

The search queries executed by the CML application search its Microsoft SQL Server database, FmLib. But in specific cases, SQL Server passes the query on to search a catalog generated by Index Server. These catalog searches occur only when the following circumstances coincide:

• The query searches a textual column in a database table.
• The query uses the CONTAINS predicate.
• The column being searched has been enabled for full-text search.
• For the query to search a generated catalog, that catalog must exist. For more information on setting up the generation of indexed catalogs, see Scheduling SQL Server Tasks.

Optionally, the database table could include timestamps that help the catalog generation create incremental catalogs. That is, instead of regenerating an entire catalog from the database each time, only those items changed since the last generation would be added to the new catalog listings.

For more information, see About Full-Text Search and CML and Full-Text Search.

Searches of this kind are possible from both the Library Search page and the Library Catalog page of the CML application.