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:



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



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



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



Step 5: Connecting to the server:



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



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



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



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



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



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



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



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



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



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



Step 16



Step 17: Various types of query options:



Step 18: Files and folders options:



Step 19: Query for CAML:



Step 20: Server On:



Step 21: CSOM Rest, JSON:



Step 22: CSOM Rest, Atom:



Step 23: Web Services:



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