Querying the Index with ISearchQueryHelper
You can use the ISearchQueryHelper interface to query the index. This interface is implemented as a helper class to ISearchCatalogManager (and ISearchCatalogManager2), and is obtained by calling ISearchCatalogManager::GetQueryHelper. This interface permits you to:
- Obtain an OLE DB connection string to connect to the Windows Search database.
- Convert Advanced Query Syntax (AQS) user queries to Windows Search Structured Query Language (SQL).
- Specify query restrictions that can be expressed in SQL, but not in AQS.
This topic is organized as follows:
- Getting Started with ISearchQueryHelper
- Using the GenerateSqlFromUserQuery Method
- Working with Locale Identifiers
- Working with Properties and Columns
- Working with Query Term Expansion
- Working with Other ISearchQueryHelper Methods
- Related topics
There are a few key interfaces and methods you should be aware of before you can start programmatically querying Windows Search using the ISearchQueryHelper interface. At a high level, you need to follow these steps:
- Instantiate an ISearchManager instance.
// Create ISearchManager instance ISearchManager* pSearchManager; hr = CoCreateInstance(CLSID_CSearchManager, NULL, CLSCTX_LOCAL_SERVER, IID_PPV_ARGS(&pSearchManager));
- Obtain an instance of ISearchCatalogManager using ISearchManager::GetCatalog. The name of the system catalog for Windows Search is
// Create ISearchCatalogManager instance ISearchCatalogManager* pSearchCatalogManager; // Call ISearchManager::GetCatalog for "SystemIndex" to access the catalog to the ISearchCatalogManager hr = pSearchManager->GetCatalog(L"SystemIndex", &pSearchCatalogManager);
- Obtain an instance of ISearchQueryHelper using ISearchCatalogManager::GetQueryHelper.
// Call ISearchCatalogManager::GetQueryHelper to get the ISearchQueryHelper interface ISearchQueryHelper* pQueryHelper; hr = pSearchCatalogManager->GetQueryHelper(&pQueryHelper);
- After you have an instance of ISearchQueryHelper, you can then get the connection string used to connect to the Windows Search index OLE DB connector.
// Call get_ConnectionString to get the OLE DB connection string LPWSTR pszConnectionString=NULL; hr = pQueryHelper->get_ConnectionString(&pszConnectionString); // NOTE: YOU MUST call CoTaskMemFree() on the string
The ISearchQueryHelper::GenerateSQLFromUserQuery method transforms user input into a SQL query string, which can then be submitted to the OLE DB provider for Windows Search. This method translates the Advanced Query Syntax (AQS) or Natural Query Syntax (NQS) query entered by the user into SQL, and lets you add other SQL fragments as needed.
The SQL query string is returned in the following form:
SELECT <QuerySelectColumns> FROM <CatalogName that created query helper> WHERE <Result of interpreting the user query passed into this function according to QuerySyntax> [ AND|OR <QueryWhereRestrictions> ]
The following is an example of the SQL string returned from the call
SELECT "System.ItemUrl" FROM "SystemIndex" WHERE ((CONTAINS(*,'"comput*"',1033) RANK BY COERCION(Absolute, 1)) OR (FREETEXT(("System.ItemNameDisplay":0.9, *:0.1), 'comput', 1033) AND CONTAINS(*,'"comput"',1033))) ORDER BY "System.ItemUrl"
|Gets/Puts the language code identifier (LCID) of the query. This helps get the correct wordbreaker and stemmer to compare query terms against the catalog/inverted index. The default is the current input locale.|
|Gets/Puts the LCID for the language to use when parsing Advanced Query Syntax (AQS) keywords. The default is the default user locale.|
The content locale and keyword locale are locale identifiers (LCID) that help the search engine use the correct word breakers by identifying the language of the query terms and the language the AQS keywords. These are not always the same LCIDs because Windows Search is offered in a number of international versions and also includes Multilingual User Interface (MUI) packs for more languages. The content locale identifies the LCID for the language users input their search query in, while the keyword locale identifies the LCID the search engine uses when parsing Advanced Query Syntax (AQS) keywords.
For example, if you have the English-US version with no MUI packs, both the content locale and keyword locale are 1033. If you have the German version with no MUI packs, then both the content locale and keyword locale are 1031 (gr-gr). However, if you have the English version with the Romanian MUI pack, the content locale is 2072 (ro) and the keyword locale is 1033 (en-us).
|Gets/Sets the content properties for the search (property column listed in the CONTAINS or FREETEXT clauses).|
|Gets/Sets the columns (or properties) requested in the SELECT statement. The default is System.ItemUrl and properties used in the WHERE clause.|
Items are represented in the property store as a row. Each row contains a number of columns that represent properties for that item. Not all items will have a value for a given property. For example, an audio file would typically not contain a value for the System.Property.FromName property but may contain information regarding the System.Music.Artist.
With these methods, you access or modify the property with a comma delimited, null-terminated, Unicode string that specifies one or more column names of the property store: "System.Document.Author, System.Document.Title".
|Gets/Sets the search term expansion flag.|
This method enables the expansion of some query terms with wild card characters, similar to regular expression expansion. Prefix expansion searches for words with the same prefix (fun/funnel). If not set, the default value is SEARCH_TERM_PREFIX_ALL. The supported values of the SEARCH_TERM_EXPANSION enumeration are as follows:
- SEARCH_TERM_PREFIX_ALL - All search terms are expanded
- SEARCH_TERM_NO_EXPANSION - No search terms are expanded
Many of the methods in the ISearchQueryHelper interface are used to set query arguments or define the properties returned.
|Returns the OLE DB connection string. This is the preferred method of getting a properly formatted and correct connection string.|
|Gets/Sets the maximum number of results to be returned by a query (that is, SELECT TOP n). The default is -1, meaning that no maximum results clause is generated.|
|Gets/Sets the sort order for the query result set (ORDER BY). If no ORDER BY clause exists, the results are returned in non-deterministic order.|
|Gets/Sets the syntax of the query: Advanced Query Syntax or Natural Query Syntax.|
|Gets/Sets the restrictions appended via WHERE clauses.|
- Querying the Index Programmatically
- Using SQL and AQS Approaches to Query the Index
- Querying the Index with the search-ms Protocol
- Querying the Index with Windows Search SQL Syntax
- Using Advanced Query Syntax Programmatically