Category Archives: CAML

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