Category Archives: CAML

Overcoming the List View Threshold in SharePoint CAML queries

Great article written by Jonathan Cardy: https://www.codeproject.com/Articles/1076854/Overcoming-the-List-View-Threshold-in-SharePoint-C How to write scalable CAML queries that won’t return list view threshold errors on large SharePoint lists. Introduction When your CAML queries start to hit the list view threshold, you’ll think it will … Continue reading

Posted in CAML, SharePoint 2010, SharePoint 2016 | Leave a comment

SharePoint: CAML Query Joins and Projections

Referenc (by Nadeem Yousuf): http://sharepointnadeem.blogspot.com.au/2013/08/caml-query-joins-and-projections.html Scenario: A user asked a question, can I still perform CAML query joins even if I don’t connect Lookup to ID of another list. I want to connect Lookup to the Title field of the … Continue reading

Posted in CAML, SharePoint 2010, Visual Studio 2010 | Leave a comment

CAML Query that filters against a Lookup Column

Standard what (based on value): 1 2 3 4 5 6 <Where>     <Eq>         <FieldRef Name=”Category” />         <Value Type=”Lookup”>My category</Value>     </Eq> </Where> By ID: 1 2 3 4 5 6 <Where>     <Eq>         <FieldRef Name=”Category” LookupId=”TRUE” />         <Value Type=”Lookup”>234</Value>     </Eq> </Where>

Posted in CAML, SharePoint 2010, Visual Studio 2010 | Leave a comment

A CAML Query Quick Reference

The info below was from this link: http://joshmccarty.com/2012/06/a-caml-query-quick-reference/ Single Line of Text Value Type Text Example <Query><Where><Eq><FieldRef Name=”Title” /><Value Type=”Text”>Hello World!</Value></Eq></Where></Query> Notes This is one of the simplest queries. The example selects items with a title equal to “Hello World!” … Continue reading

Posted in CAML, SharePoint 2010, Visual Studio 2010 | Leave a comment