Indexing Service Predefined Views

  • 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.

 

The SQL extensions include several predefined views that you can use without writing an explicit CREATE VIEW statement. Because the predefined view names are permanent, they do not need to be preceded by the number sign (#).

The following table lists the predefined views for Indexing Service, which are always available, regardless of the catalog you are currently using.

Predefined View Properties Description
FILEINFO path, FileName, size, write, attrib Standard file result list
FILEINFO_ABSTRACT path, FileName, size, write, attrib, Characterization Standard file result list plus abstract
EXTENDED_FILEINFO path, FileName, size, write, attrib, DocTitle, DocAuthor, DocSubject, DocKeywords, Characterization Extended file result list
WEBINFO Vpath, path, FileName, size, write, attrib, Characterization, DocTitle Standard Web results
EXTENDED_WEBINFO Vpath, path, FileName, size, Characterization, write, DocAuthor, DocSubject, DocKeywords, DocTitle Extended Web results

 

Example

The following example shows a conceptual SQL statement that defines the FILEINFO predefined view. All predefined views are constructed using the default scope.

CREATE VIEW FILEINFO AS
  SELECT path, FileName, size, write, attrib
  FROM SCOPE()

Without creating the FILEINFO view (it is predefined), you can issue queries such as the following.

SELECT * FROM FILEINFO
  WHERE size > 20000
SELECT path, FileName, attrib
  FROM FILEINFO
  WHERE attrib = ALL ARRAY [0x820]
  OR FileName LIKE 'arch%.xls'

CREATE VIEW Statement

Site Server Predefined Views