SQL search controls allow users to search through the content of a website's documents. The controls use the SQL search engine, which utilizes standard queries to find results in the Kentico CMS database.

 

Note: Kentico CMS provides an index-based Smart search engine. The smart search has significantly better performance than the SQL search.

 

The SQL search uses the following queries:

 

•Automatically generated queries for the data of individual document types. To override the search query for a document type, create a new query named searchtree in Site Manager -> Development -> Document types -> Edit document type -> Queries.

•The cms.root.searchdocuments query for common fields (such as the document name).

•The cms.root.searchattachments query for files uploaded as attachments. To search uploaded files, you need to configure the system for full-text search in files.

 

Available controls:

 

•CMSSearchDialog

•CMSSearchResults