FROM Clause

Use the FROM clause to specify the files on which to perform the search. The FROM clause defines the query scope.

Syntax

FROM [ Catalog_Name.. ] { SCOPE( [ 'Scope_Arguments' ] ) | View_Name }

Elements

' [ Traversal_Type ] ( "Path" [ , "Path", ...] )'

Examples

1. The following example defines a deep traversal search (default scope). It searches for the word "smith" in the DocAuthor property for all files starting from the virtual root directory "/".

   
   SELECT DocAuthor, DocTitle
   FROM SCOPE() 
   WHERE CONTAINS(DocAuthor, 'smith') > 0

2. The following example defines a shallow traversal of \Contracts\open on drive D (the top directory only) and all the subdirectories at /reports/year 97.

   
   SELECT DocAuthor, size,  DocTitle,  write 
   FROM SCOPE(' SHALLOW TRAVERSAL OF "D:\Contracts\open" ',
   		  ' DEEP TRAVERSAL OF "/Reports/Year 97" ') 
   WHERE CONTAINS(DocTitle, '"Contract Expenses"') > 0
   

   Since DEEP TRAVERSAL OF is the default traversal selection, its inclusion is optional. You may want to use it to increase readability of the statement.

   Note that single quoted strings are used to associate traversal type to a specific path or set of paths.

3. The following example statements are equivalent, but the FROM clause of the latter is more verbose than the former. In the second example, extra parentheses are added around the paths to enhance readability.

   
   SELECT DocAuthor, size,  DocTitle,  write 
   FROM SCOPE(' "D:\Word97\specs", "E:\DAPI\specs"  ' )  
       WHERE CONTAINS(Contents, '"content search"') > 0

   
   SELECT DocAuthor, size,  DocTitle,  write 
   FROM SCOPE(' DEEP TRAVERSAL OF ( "D:\Word97\specs", 
       "E:\DAPI\specs" ) ')
       WHERE CONTAINS(Contents, '"content search"') > 0

4. The following example obtains DocAuthor, size, DocTitle, write property information from files in all directories at and below /reports/1997 and /reports/1996 and from files in the E:\temp\reports and the E:\scratch directories that contain the phrase "development status".

   
   SELECT DocAuthor, size,  DocTitle,  write 
   FROM SCOPE(' "/reports/1997" , "/reports/1996" ',
   		  ' SHALLOW TRAVERSAL OF ( "E:\temp\reports","E:\scratch") ') 
   WHERE CONTAINS(CONTENTS, '"development status"') > 0
   

© 1997 by Microsoft Corporation. All rights reserved.