Starting With CAML Builder

Go to Start, All Programs, U2U Training nv, then U2U CAML Query Builder.

U2U CAML Query Builder

The following screen will appear.

click connect

Enter your online SharePoint site URL.

online SharePoint site

Select “Connect to SharePoint Online” and also select “Custom Credentials”. Enter the username and password for SharePoint Online site.

Connect to SharePoint Online

Click Connect button. The following screen will appear.

Click Connect button

Select your list name. Here I have selected “MyList”.

Select your list name

Click New query, then Simple Query.

Simple Query

The following screen will appear.

CML Query Builder

Select your column name in second drop down list. Here I have query based on location column name.

Select your column name

Click Execute query. The results will show as in the following.

Click execute query

Query with View Fields,

Click New query, then Query with ViewFields.

Query with ViewFields

First select your queried column name. Here I have selected location column name.

First select your queried column

Click View fields tab.

View fields tab

Select your columns (What are all the columns needed).

columns needed

Select your columns

Click Execute query. The results will be like the following.

execute query

Summary

In this article we saw how to use CAML Query builder for SharePoint 2013 Online.