Monday 22 December 2014

Below is the piece of code for accessing list items in a view of a Sharepoint List using CSOM. 
  1. To Access List Items in a Specific view of SharePoint List 2013


  2. ClientContext context = new ClientContext("http://mysites/");  
  3. List list = context.Web.Lists.GetByTitle("Customer");  
  4. context.Load(list);  
  5. context.ExecuteQuery();  
  6. View view = list.Views.GetByTitle("All Items");  
  7.   
  8. context.Load(view);  
  9. context.ExecuteQuery();  
  10. CamlQuery query = new CamlQuery();  
  11. query.ViewXml = view.ViewQuery;  
  12.   
  13. ListItemCollection items = list.GetItems(query);  
  14.   
  15. context.Load(list);  
  16. context.Load(items);  
  17. context.ExecuteQuery();  
  18. Console.Write(items.Count);   
Here is the Code Snippet to get the Latest Version of a SharePoint List Item in SharePoint 2013.
 
  1. private SPListItem LatestVersionItem(SPListItem item)  
  2.         {  
  3.   
  4.             if ((item.Versions != null) && (item.Versions.Count > 0))  
  5.             {  
  6.                 SPListItemVersionCollection versions = item.Versions;  
  7.                 SPListItem latestItemversion;  
  8.                 if (item.Versions.Count > 1)  
  9.                     latestItemversion= item.Versions[item.Versions.Count - 1].ListItem;  
  10.                 else  
  11.                     latestItemversion= item.Versions[0].ListItem;  
  12.   
  13.                 return latestItemversion;  
  14.             }  
  15.             else  
  16.             {  
  17.                 return item;  
  18.             }  
  19.         }  

No comments:

Post a Comment