Saturday 19 July 2014

SharePoint query on all document libraries

SPSiteDataQuery query = new SPSiteDataQuery();
query.Lists = "<Lists ServerTemplate='101' />";

query.Query = simpleQuery;
query.ViewFields = "<FieldRef Name='Title' /><FieldRef Name='Validated' /><FieldRef Name='ContentType' /><FieldRef Name='FileRef' />";
query.Webs = "<Webs Scope='SiteCollection' />";
DataTable dataTable = site.RootWeb.GetSiteData(query);