Property Querying

  • Article

Note

Indexing Service is no longer supported as of Windows XP and is unavailable for use as of Windows 8. Instead, use Windows Search for client side search and Microsoft Search Server Express for server side search.

 

After the document properties are filtered and indexed, they are available for querying. The type of query operations that Indexing Service can perform on a specified property depends on the type of the property.

  • If the property is a text-type property, the only possible queries are content searches for the property.
  • If the property is a value-type property, queries can retrieve, relationally manipulate, and sort the property as well as perform content searches for it.

Conceptually, these capabilities exist because there are single-valued entries for the value-type properties in the "table" for the catalog, but there can be — and usually are — multi-valued entries for the text-type properties.

The following table gives several examples of query types and the types of properties that each can use.

Query Type Example Property Types
Content search     (Short form)
    (WHERE clause)
 
@Chapter "Confessions"
WHERE CONTAINS(Chapter,"Confessions")
 Text and value types
Retrieval     (SELECT statement)
 
SELECT DocTitle
  FROM SCOPE()
  WHERE CONTAINS(Chapter,"Confessions")
 Value type
Relational     (WHERE clause)
 
SELECT DocTitle
  FROM SCOPE()
  WHERE Book = 'Stormy Night'
 Value type
Sorted     (ORDER BY clause)
 
SELECT DocTitle, Book
  FROM SCOPE()
  WHERE CONTAINS(Chapter,"Confessions")
  ORDER BY DocTitle Book DESC
 Value type