How to get specific list items in Document Library subfolder?

Question

I'm attempting to retrieve items from a subfolder in a document library. I must get these items where value is 'Like'. How can I do this via C# using the SP object model or by CAML query?

this is what I have so far:

        using (SPSite site = new SPSite("http://mySite/Shared Documents/"))
        {
            using (SPWeb web = site.OpenWeb())
            {
                //get sub folder url
                string SubFolderUrl = web.ServerRelativeUrl + "/shared documents/SubFolderName";

                //able to get the subfolder at this point
                SPFolder SubFolder = web.GetFolder(SubFolderUrl);

                //Now what could I do from here to get the items in the subfolder?
                //use SPQuery object against the folder?
            }
         }

any suggestions are welcomed, thanks.

Answer 1

We can indeed use SPQuery for this. Here's some code that does what you want to do:

using (SPSite site = new SPSite("http://mySite/Shared Documents/"))
{
    using (SPWeb web = site.OpenWeb())
    {
        //get sub folder url
        string SubFolderUrl = web.ServerRelativeUrl + "/shared documents/SubFolderName";

        //able to get the subfolder at this point
        SPFolder SubFolder = web.GetFolder(SubFolderUrl);

        //create an SPQuery that gets us what we want
        string fileName = "FileName";
        SPQuery query = new SPQuery();
        query.Query = "<Where><Contains><FieldRef Name=\"Title\" /><Value Type=\"Text\">" + fileName + "</Value></Contains></Where>";
        query.Folder = SubFolder;  // This should restrict the query to the subfolder

        //run the SPQuery against the SPList
        SPDocumentLibrary list = SubFolder.DocumentLibrary;
        SPListItemCollection files = list.GetItems(query);
    }
}

This code takes whatever the search query should be in the string fileName and returns all files with fileName in its Title.

The SPListItemCollection files should contain the files you're looking for. Please note that I haven't tested this code nor have I done error checking (you should probably check if the SPDocumentLibrary list is not null at least).