Syntax for Default Query Category Matching

The category portion of the default query searches category name, keywords, subject, title, and description and returns a list of links to relevant category folders. Users can browse categories from the result list on the dashboard site.

The following example, written in SQL with full-text extensions, demonstrates how the default query for the dashboard site performs category matches. In this example the query is searching for categories relevant to the terms "SharePoint Portal Server."

 SELECT "DAV:href", "DAV:displayname", "DAV:contentclass", "urn:schemas-microsoft-com:office:office#Category", "urn:schemas-microsoft-com:office:office#Description" FROM workspace..SCOPE() WHERE WITH  ("urn:schemas-microsoft-com:office:office#Keywords":1.0, "urn:schemas-microsoft-com:office:office#Subject":1.0,  "urn:schemas-microsoft-com:office:office#Title":1.0,  "urn:schemas.microsoft.com:fulltextqueryinfo:description":1.0 )  AS #WeightedCatProps (FREETEXT(#WeightedCatProps, 'SharePoint Portal Server') OR CONTAINS("DAV:displayname", '"SharePoint Portal Server"')) AND ("DAV:contentclass" = 'urn:content-classes:categoryfolder') ORDER BY "urn:schemas-microsoft-com:office:office#Category" ASC 

The search engine executes the category search against the primary workspace only, and does not include results from index workspaces. This restriction improves category search latency, with no loss of results since the categories should be the same among primary and index workspaces.