Using Folder,FilesOnly,Recursive,RecursiveAll in SPquery in SharePoint

Using the Folder attribute with SPquery - This is used when you want to Retrive items from a specific folder only. The msdn example says "Gets or sets the folder within a document library from which to return items in the query."

example -

SPList oList = oWebsiteRoot.Lists["Document_Library_Name"];
SPFolder oFolder = oList.RootFolder.SubFolders["Folder_Name"];

SPQuery oQuery = new SPQuery();
oQuery.Folder = oFolder;
SPListItemCollection collListItems = oList.GetItems(oQuery);

Using FilesOnly attribute with SPquery - FilesOnly will get all the files of a specific folder.

SPList oList = oWebsiteRoot.Lists["Document_Library_Name"];
SPFolder oFolder = oList.RootFolder.SubFolders["Folder_Name"];

SPQuery oQuery = new SPQuery();
oQuery.Folder = oFolder;
query.ViewAttributes = "Scope=\"FilesOnly\"";
SPListItemCollection collListItems = oList.GetItems(oQuery);


Using Recursive attribute - Show all files and all subfolders of all folders.
SPList oList = oWebsiteRoot.Lists["Document_Library_Name"];
SPFolder oFolder = oList.RootFolder.SubFolders["Folder_Name"];

SPView view = list.Views["View_Name"];

SPQuery oQuery = new SPQuery(view);
oQuery.ViewAttributes = "Scope=\"Recursive\"";
SPListItemCollection myItems = list.GetItems(oQuery);

Using RecursiveAll attribute - Show all files and all subfolders of all folders.

SPList oList = oWebsiteRoot.Lists["Document_Library_Name"];
SPFolder oFolder = oList.RootFolder.SubFolders["Folder_Name"];

SPView view = list.Views["View_Name"];

SPQuery oQuery = new SPQuery(view);
oQuery.ViewAttributes = "Scope=\"RecursiveAll\"";
SPListItemCollection myItems = list.GetItems(oQuery);

Ads by Google