Item count should be 10 but is 0

Question

the items.count should be atlease 10. I have 10 subfolders (Release 1 ..... Release 10) with in this documnent library "Auto Cad" and each subfolder has a file called license.txt. hmmm Why this is not returning any file(s)?

private void btnGetFileGuid_Click(object sender, EventArgs e)
{ 

using (SPSite site = new SPSite("https://www.abc.com/sites/Software"))
 { 
 using (SPWeb web = site.OpenWeb())
 { 
  SPList spList = web.Lists["Auto Cad"];
  string fileName = "license.txt"; 
  SPQuery query = new SPQuery(); 
  query.Query="<Where><Eq><FieldRef Name='FileLeafRef' /><Value Type='Text'>" + fileName + "</Value></Eq></Where>"; 
  SPListItemCollection items = spList.GetItems(query); 
  if (items.Count > 0) 
   { 
    Guid id = items[0].UniqueId; 
    lblGuid.Text = id.ToString(); 
   } 
  }
 } 
}

Please use code formatting so that your code snippet is more readable. — Drew, Dec 14 '10 at 04:49
Drew, I can see the code block in the gray area and each code line has it's own line. Am I missing something? — John Locke, Dec 14 '10 at 05:01

score 0 · Answer 1 · answered Dec 14 '10 at 04:53

0

query.Query="" + fileName + "";

This line is wrong. This should be CAML query and not name of filename.

answered Dec 14 '10 at 04:53

Madhur Ahuja

22,211
14
71
124

The post is now edited. When I saw the post, it was Query="license.txt". – Madhur Ahuja Dec 14 '10 at 06:15
1

And before you give the comment of my posting as intention of scoring points. Have etiquette on having good subject "Em3rgency kinda situ@tion" – Madhur Ahuja Dec 14 '10 at 06:17

score 0 · Accepted Answer · answered Dec 14 '10 at 10:08

SPQuery only searches a particular folder - to recursively search through subfolders you need to set

SPQuery.ViewAttributes = "Scope=\"Recursive\"";

So your code should be

SPQuery query = new SPQuery(); 
query.ViewAttributes = "Scope=\"Recursive\"";
query.Query=".... REST OF YOUR CODE HERE "

score 0 · Answer 3 · edited May 23 '17 at 09:58

0

You need to make a recursive call use the solution provided in question link provided below

i would recommend use qry.ViewAttributes = "Scope='RecursiveAll'"; to get documents and folders as well query to get all items in a list including items in the sub folders in sharepoint

edited May 23 '17 at 09:58

Community

1
1

answered Dec 14 '10 at 11:48

Ashutosh Singh-MVP SharePoint

5,283
5
26
42

ashutosh: looks like Ryan's type solution. I will sure to try this one as well. What's the main difference between these two? – John Locke Dec 15 '10 at 04:18
if you see the link provided with the answer and see their it answers the question you have asked – Ashutosh Singh-MVP SharePoint Dec 15 '10 at 06:44
How does an identical answer that came hours after get more up votes? Points jealousy much ;) – Ryan Dec 15 '10 at 12:52
Recursive returns all files from all subfolders - RecursiveAll returns both Files AND folders from all subfolders. Basically RecursiveAll does exactly the same in this context as he's looking for files, not folders. http://msdn.microsoft.com/en-us/library/microsoft.sharepoint.spviewscope.aspx – Ryan Dec 15 '10 at 15:45
1

@Ryan - See here for a discussion about this: http://meta.stackexchange.com/questions/72439/reason-for-loss-of-reputation – Brad Larson Dec 17 '10 at 04:26

Item count should be 10 but is 0

3 Answers3