Is this really the version you are looking for? Kentico Xperience 10 Documentation is no longer updated. Use the switcher in the header to choose your product version.
The SQL search is an obsolete search engine for pages in the content tree of websites.
We highly recommend using the index-based smart search instead.
The system continues supporting the SQL search for the following reasons:
This search engine uses standard SQL queries to search for expressions:
To integrate the SQL search into website pages, use the web parts in the Full-text search category (SQL search dialog, SQL search box, etc.) or the CMSSearchDialog and CMSSearchResults server controls (in your ASP.NET code).
To exclude pages from the SQL search, open the Settings application and select the System -> Search category:
Exclude page types from SQL search - enter page type code names, for example cms.article.
Exclude pages from SQL search - allows you to exclude entire website sections from the SQL search
To directly exclude individual pages from the SQL search:
If you wish to change the format of the SQL search results:
If you need to integrate a custom search engine or make additional modifications to the search results returned by the SQL search engine, you can develop your own search provider. You can find more details in Creating custom SQL search providers.