In my project, I need to get the item from SharePoint library which contain many folder level.
However, I don't know how to write the query to get the file from particular folder and inside the sub folder.
For now, I can get the file in one folder level. My code now:
query.Folder = web.GetFolder(folderLevelTwoId); query.ViewXml = @"<View Scope=\'RecursiveAll\'><Query><Where> <Or> <Contains> <FieldRef Name='FileLeafRef' /> <Value Type='Text'>.jpg</Value> </Contains> <Contains> <FieldRef Name='FileLeafRef' /> <Value Type='Text'>.png</Value> </Contains> </Or> </Where></Query></View>"; items = docLib.GetItems(query);
My Folder level:
Library -item1 <=== if i remove query.Folder = web.GetFolder(folderLevelTwoId); -item2 <=== i can only get these three items -item3 <=== the items inside folder will not pass to me folder 1 -item1 -item2 -item3 folder 2 <--- the GUID i used in code above -item1 -item2 folder 3 ... folder 4 folder 5 folder 6
By using the above code, I can get the SPListItemCollection for folder 2.
How can I get SPListItemCollection in folder 3,4,5,6 by using the folder 2?