SQL search controls

✖
Copy to clipboard

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

Note: Current versions of Kentico provide 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 page types. To override the search query for a page type, create a new query named searchtree in Page types -> Edit page type -> Queries.
  • The searchdocuments query of the Root page type for fields that are shared by all pages (such as the document name).
  • The searchattachments query of the Root page type for files uploaded as page attachments. To search attachments, you need to configure the system as described in Configuring SQL search for attachment files.
Available controls: