CAML (Collaborative Application Markup Language)
The CAML queries are internally used to query the SharePoint List with specific conditions and formatting. It is very powerful as SQL queries and improves the performance. The CAML query can be split into
- Display Part
- Conditional Part
They are generally used to display the content in a grouped and ordered manner.
Eg: OrderBy, GroupBy
They are used to retrieve data with certain conditions. Like using logical operators. The following example queries will give an overview.
The condition (Name ==”Balaji”) in CAML form would look like
Multiple condition with Logical operators have a tricky part that each logical operator can have two parts more than two should have another logical operator to be defined encapsulating it.
The condition((Name ==”Balaji”) && (Location==”Chennai”) && (ID==1))in CAML form would look like
|Normal Operator||SharePoint specific|
Generally CAML queries can be easily generated using several tools. Refer the following link for more info http://msdn.microsoft.com/en-us/library/ff648040.aspx