Hi imagine a doc library in sharepoint holding PDF's called DocA.
DocA has subfolders e.g DocA\sub1, DocA\sub2
I am writing a CAML query to extract PDF's which were created older than 7 days.
My issues is i cant get the PDf's items in CAML query and it just shows the folder only.
Here is my code.
SPSite site = new SPSite(Site);
SPWeb web = site.OpenWeb();
SPList list = web.Lists["DocA"];
string querystring = "<Leq>" +
"<FieldRef Name='Created' />" +
"<Value Type='DateTime'><Today /></Value>" +
SPQuery query = new SPQuery();
query.RecurrenceOrderBy = true;
query.Query = querystring;
DataTable table = list.GetItems(query).GetDataTable();
View Complete Post