Explorer: 
- Folder: E:\Users\Public\Documents\Administrative
- Search term: author:eva

SELECT "System.ParsingPath", "System.CanonicalType" 
FROM SYSTEMINDEX..SCOPE() 
WHERE "Scope"='file:E:/Users/Public/Documents/Administrative' 
  AND "System.Author" LIKE 'eva%'

- Search Results: click on Index

SELECT "System.ParsingPath", "System.CanonicalType" 
FROM SYSTEMINDEX..SCOPE() 
WHERE "System.Author" LIKE 'eva%'

Explorer: 
- Folder: E:\Users\Public\Documents\Administrative
- Search term: eva

?

Explorer: 
- Folder: E:\Users\Public\Documents\Administrative
- Search term: Lorem ipsum

SELECT "System.ParsingPath", "System.CanonicalType" 
FROM SYSTEMINDEX..SCOPE() 
WHERE "Scope"='file:E:/Users/Public/Documents/Administrative' 
  AND CONTAINS('"Lorem ipsum"')

Explorer: 
- Folder: E:\Program Files\Microsoft SDKs\Windows\v1.0\Include

SELECT "System.ParsingName", "System.ParentFolder"
FROM SYSTEMINDEX..SCOPE() 
WHERE "DIRECTORY"='file:E:/Program Files/Microsoft SDKs/Windows/v1.0/Include

- Search term: ShellExecute

SELECT "System.ParsingName", "System.ParentFolder"
FROM SYSTEMINDEX..SCOPE() 
WHERE "DIRECTORY"='file:E:/Program Files/Microsoft
  AND CONTAINS('ShellExecute')

