Compartir a través de

FROM Clause

  • Artículo

Following the SELECT statement, you use the FROM clause to specify where to search for matching documents. Following is the top-level syntax of the FROM clause:

FROM [<machinename>.]SYSTEMINDEX

The scope of a search is the location from which the query returns the results. You must qualify FROM clause scope specifications with the catalog name, SYSTEMINDEX. To query the local index of a remote machine, include the machine name before the catalog. In SharePoint Server, the FROM clause has to be in the format: SYSTEMINDEX..SCOPE(). This is supported in Windows Search but is not required.

It is no longer possible to qualify a scope specifications within the FROM clause. Instead, you specify a scope as a restriction in the WHERE clause, with either SCOPE or DIRECTORY:

FROM SYSTEMINDEX WHERE SCOPE=<scope>
FROM SYSTEMINDEX WHERE DIRECTORY=<scope>

Using SCOPE results in a deep traversal of the specified folder and its subfolders, while DIRECTORY results in a shallow traversal of only the specified folder. For more information, refer to WHERE Clause.

Note  UNION ALL is not supported in Windows Search.

Examples

SELECT System.ItemName,System.ItemUrl
FROM SYSTEMINDEX WHERE...

SELECT System.Author,System.ItemName,System.ItemUrl
FROM [MachineName].SYSTEMINDEX WHERE SCOPE='file:C:/Files'