CAML Query Designer in Sharepoint 2013

Collaborative Application Markup Language (CAML) is an XML-based query language. CAML Designer is a tool that helps you to generate CAML queries to SharePoint lists.

You can download this tool from http://www.biwug.be/. In that web site go to the Downloads tab then select "CAML Designer".

Advantages of CAMLDesigner

The main advantages of this tool is that it is user friendly. You can build CAML queries for single lists and build queries that can be executed with SPSiteDataQuery. In addition to the pure CAML queries, you can also get code snippets for the server-side object model, the .NET client-side object model and the JavaScript client-side object model.
 
How to use CamlDesigner 2013

Step 1: Click on "CONNECTION" in "CamlDesigner 2013"; see:

CAML1.jpg

Step 2: Here we have various options for connecting to Server OM, Client OM, Web Services and Current Credentials.

CAML2.jpg

Step 3: Here we are connecting to Server On; see:

CAML3.jpg

Step 4: Here we are entering the URL that we need to connect to then click the "Connect Button".

CAML4.jpg

Step 5: Connecting to the server:

CAML5.jpg

Step 6: It's showing all the site details here:

CAML6.jpg

Step 7: Here we select the "Employee Information" and its showing all the fields in that list

CAML7.jpg

Step 8: In this step we dragged three fields to the right side; see:

CAML8.jpg

Step 9: Here click on "Test" then see the results and the generated query also; see:

CAML9.jpg

Step 10: Here we are adding the order by clues by "City"; see:

CAML10.jpg

Step 11: Order by "City" fields; the query is also updated; see:

CAML11.jpg

Step 12: Here we are adding the Where conditions with "Gender" fields; see:

CAML12.jpg

Step 13: Right-click on the round symbol so we will get the more options for the "where" conditions; see:

CAML13.jpg

Step 14: The Where conditions using the "Date" fields:

CAML14.jpg

Step 15: To specify a "Date" in the "Where" condition:

CAML15.jpg

Step 16

CAML16.jpg

Step 17: Various types of query options:

CAML17.jpg

Step 18: Files and folders options:

CAML18.jpg

Step 19: Query for CAML:

CAML19.jpg

Step 20: Server On:

CAML20.jpg

Step 21: CSOM Rest, JSON:

CAML21.jpg

Step 22: CSOM Rest, Atom:

CAML22.jpg

Step 23: Web Services:

CAML23.jpg

Summary
 
In this article I tried to explore how to use the CamlDesigner 2013 for SharePoint 2013.

 

Up Next
    Ebook Download
    View all
    Learn
    View all