PRB: Undocumented Filter Syntax for IReposQuery::GetCollection Method (297211)

MORE INFORMATION

Steps to Reproduce Behavior

1. If you have not already done so, run the Visual Basic FileSys.vbp FileSystem sample that is included with the Repository 3.0 SDK, and populate your Repository with some sample folders and file names for testing purposes.
2. Create a new Visual Basic Standard EXE project.
3. Set a project reference to Microsoft Repository.
4. Place a command button on Form1.
5. Paste the following code in the code module for Form1:

   Private Sub Command1_Click()
     Dim repos As Repository
     Dim reposq As IReposQuery
     Dim strFilter
     Dim coll As IObjectCol2
     Dim itm As RepositoryObject
     Set repos = New Repository
     repos.Open "Driver={SQL Server};Server=(local);Database=FileSys;UID=user;PWD=password"
     Set reposq = repos
     strFilter = "[FileSystem._FolderDef.Name] LIKE '%'"
     Debug.Print strFilter
     Set coll = reposq.GetCollection(strFilter, FILTERCOL_SYNC)
     For Each itm In coll
       Debug.Print vbTab & itm.Name
     Next
   End Sub
   					

6. Edit the ODBC connection parameters for your SQL Server and Repository database.
7. Run the project, and click the command button. In the Immediate (Debug) window, notice that this filter has returned all items, both folders and files, that you saved to your FileSystem repository because the "Name" property on which you filtered is defined on the parent FolderItemDef interface, which both FolderDef and FileDef inherit.
8. To return only the folders, add an Implements() clause to the Filter expression as follows:

     strFilter = "[FileSystem._FolderDef.Name] LIKE '%' AND " & _
       "Implements ([FileSystem._FolderDef])"
   					

9. Run the code again. Notice that only the folders are listed in the Debug window (that is, items that implement the _FolderDef interface). Notice the space after the Implements keyword.
10. Remove the space after Implements, and run the code again. You receive the following error message, which is misleading but alerts you to the invalid syntax:
    The property name [FileSystem._FolderDef]) inside [] could not be resolved.
    Note the mismatched parentheses in the error message.
11. Change the filter string as follows:

      strFilter = "[FileSystem._FolderDef.Name] LIKE '%' AND " & _
        "InstanceOf ([FileSystem.FolderDef])"
    					

12. Run the code again. This also returns only folders (that is, instances of the FolderDef class).
13. Remove the space after InstanceOf, and run the code again. You receive the same error message as above.