The attempted operation is prohibited because it exceeds the list view threshold
Hi, We are fetching documents from a specific folder using the below code. Microsoft.SharePoint.Client.List spList = clientContext.Web.Lists.GetByTitle("Testable"); clientContext.Load(spList); clientContext.ExecuteQuery(); CamlQuery camlQuery = new CamlQuery(); camlQuery.ViewXml = @"<View Scope='RecursiveAll'> <Query> <Where> <IsNotNull> <FieldRef Name='Title'></FieldRef> </IsNotNull> </Where> <OrderBy> <FieldRef Name='Created' Ascending='true' /> </OrderBy> </Query> </View>"; Folder folder = clientContext.Web.GetFolderByServerRelativeUrl(relativeURL); clientContext.Load(folder); clientContext.ExecuteQuery(); camlQuery.FolderServerRelativeUrl = folder.ServerRelativeUrl; ListItemCollection listItems = spList.GetItems(camlQuery); clientContext.Load(listItems, items => items.Include( item => item, item => item["Title"])); clientContext.ExecuteQuery(); The folder has 10-12 documents only but still, it is throwing the error "The attempted operation is prohibited because it exceeds the list view threshold" when executing the last line.
how to get maximum of another column for a grouped column
Hello in my SharePoint list I have below columns and meta data: Doc No Rev Doc-0001 00 Doc-0001 01 Doc-0001 02 Doc-0002 00 Doc-0002 01 Now I want below to result in the view or query, that added another column that show maximum Rev for each Doc No Doc No Rev Maximum Rev Doc-0001 00 02 Doc-0001 01 02 Doc-0001 02 02 Doc-0002 00 01 Doc-0002 01 01 I read something about CAML in the NET, but I do not know how I have to use that for solving my problem. Regards, Masoud